[esb-issues] [JBoss JIRA] Created: (JBESB-1246) SqlTableGatewayListener : Field names not handled well in terms of case (Upper/Lowercase)

[Tom Cunningham (JIRA)]

SqlTableGatewayListener : Field names not handled well in terms of case (Upper/Lowercase)
-----------------------------------------------------------------------------------------

                 Key: JBESB-1246
                 URL: http://jira.jboss.com/jira/browse/JBESB-1246
             Project: JBoss ESB
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Transports
    Affects Versions: 4.2.1 IR2
            Reporter: Tom Cunningham
         Assigned To: Mark Little
             Fix For: 4.2.1


In SqlTableGatewayListener, a row is grabbed and then turned into a hash, which is checked to change status.     If the case of the field name in the hash doesn't match the case of the field name in jboss-esb.xml, the row will never be updated.      The case in which the drivers return the field name differs from database to database, so we should probably do something here to make the field names case-insensitive by uppercasing what we see in jboss-esb.xml for status_column, message-id-column, order-by-column, etc. and upper casing what is in the currentRow hash.

I saw problems in MySQL with this code while testing the helloworld_sql_action example.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira