[esb-issues] [JBoss JIRA] Resolved: (JBESB-1419) SQLGatewayListener has problems when uses lowercase values in process fields

SQLGatewayListener has problems when uses lowercase values in process fields ---------------------------------------------------------------------------- Key: JBESB-1419 URL: http://jira.jboss.com/jira/browse/JBESB-1419 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Adapters Affects Versions: 4.2.1 Environment: FC7/PostgreSQL Reporter: Jiri Pechanec Assigned To: Tom Cunningham Fix For: 4.2.1 CP1 Contents of the table soaesb1=> select * from gateway_table where upper(status_col) like 'P%'; unique_id | data_column | status_col -----------+------------------+------------ 1 | Hello ESB World! | p 2 | How why ya? | p 3 | Thanks. | p 4 | Cya! | p 5 | Bye ESB World | p Log messages 2007-12-21 07:01:56,925 WARN [org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener] Cannot change row state from Pending to Working. Number of rows in state Pending = 0