[esb-issues] [JBoss JIRA] Commented: (JBESB-1855) Upper / lower case problems in SqlTableGatewayListener

Upper / lower case problems in SqlTableGatewayListener ------------------------------------------------------ Key: JBESB-1855 URL: http://jira.jboss.com/jira/browse/JBESB-1855 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Transports Affects Versions: 4.3 Reporter: Tom Cunningham Assigned To: Tom Cunningham Fix For: 4.4 There are a few upper/lower case problems in trunk in SqlTableGatewayListener, where we are either looking for the upper-cased column name but try to find the lower-cased version, or we are looking for the lower cased version and send in the upper-cased version. The Quickstart only uses upper-cased column names (something we should probably change), so these problems likely did not show up during integration testing. A workaround for now for users would be to use all upper-case letters in their column names in jboss-esb.xml. I don't see this problem in CP branch. Index: src/org/jboss/soa/esb/listeners/gateway/SqlTableGatewayListener.java =================================================================== --- src/org/jboss/soa/esb/listeners/gateway/SqlTableGatewayListener.java (revision 20835) +++ src/org/jboss/soa/esb/listeners/gateway/SqlTableGatewayListener.java (working copy) @@ -663,7 +663,7 @@ if (_currentRow.containsKey(sColName)) { val = String.valueOf(_currentRow.get(sColName)); } else { - val = String.valueOf(_upperCurrentRow.get(sColName)); + val = String.valueOf(_upperCurrentRow.get(sColName.toUpperCase())); } _PSdeleteRow.setString(iParm++, val); } @@ -740,7 +740,7 @@ for (String sColName : _keys) { Object oVal = null; if (_currentRow.containsKey(sColName)) { - oVal = String.valueOf(_currentRow.get(sColName.toUpperCase())); + oVal = String.valueOf(_currentRow.get(sColName)); } else { oVal = String.valueOf(_upperCurrentRow.get(sColName.toUpperCase())); }