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) Affects Versions: 4.2.1 Environment: FC7/PostgreSQL Reporter: Jiri Pechanec 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 -- 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