[ openjms-Bugs-1691158 ] Non-coherent use of identifier upper/lower-case

Bugs item #1691158, was opened at 2007-03-30 20:24
Message generated for change (Comment added) made by tanderson
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=1691158&group_id=54559

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: persistence
Group: v0.7.7-beta-1
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: marcos (marsangr)
>Assigned to: Tim Anderson (tanderson)
Summary: Non-coherent use of identifier upper/lower-case

Initial Comment:
It is impossible to use openjms 0.7.7b1 with RDBMS that are configured with case-sensitive identifiers.

The reason is that openjms is not coherent itself in the use of column names. For instance, the column expiryTime in the table message_handles:

>From class Messages:
"delete from message_handles where expiryTime > 0 ..."

>From class MessageHandles:
"select messageid, destinationid, consumerid, priority, acceptedtime, sequencenumber, expirytime ..."

I think that should be made coherent in the openjms code since that is holding back potential customers from employing this product.

----------------------------------------------------------------------

>Comment By: Tim Anderson (tanderson)
Date: 2007-04-16 14:05

Message:
Logged In: YES 
user_id=557161
Originator: NO

Fixed in CVS. Many thanks for the patches.
The fix will be available in the 0.7.7-beta-2 release.
Please verify the changes by downloading
http://openjms.sourceforge.net/openjms-0.7.7-beta-2-SNAPSHOT.zip

----------------------------------------------------------------------

Comment By: marcos (marsangr)
Date: 2007-04-02 20:05

Message:
Logged In: YES 
user_id=1730110
Originator: YES

File Added: RDBMSAdapter_fix.patch

----------------------------------------------------------------------

Comment By: marcos (marsangr)
Date: 2007-04-02 20:05

Message:
Logged In: YES 
user_id=1730110
Originator: YES

File Added: Messages_fix.patch

----------------------------------------------------------------------

Comment By: marcos (marsangr)
Date: 2007-04-02 20:05

Message:
Logged In: YES 
user_id=1730110
Originator: YES

File Added: MessageHandles_fix.patch

----------------------------------------------------------------------

Comment By: marcos (marsangr)
Date: 2007-04-02 20:04

Message:
Logged In: YES 
user_id=1730110
Originator: YES

File Added: Destinations_fix.patch

----------------------------------------------------------------------

Comment By: marcos (marsangr)
Date: 2007-04-02 20:04

Message:
Logged In: YES 
user_id=1730110
Originator: YES

File Added: Consumers_fix.patch

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2007-03-31 00:04

Message:
Logged In: YES 
user_id=557161
Originator: NO

Submit a patch, and I'll put it in before the 0.7.7 final release.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=1691158&group_id=54559

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/