[
http://jira.jboss.com/jira/browse/JBESB-1419?page=comments#action_12393671 ]
Tom Cunningham commented on JBESB-1419:
---------------------------------------
From Jiri via email :
"the problem is lack of
documentation. The SQL gateway is not documented but from the code is clear that it is
expected that both lower/upper case chars are supported. If it is not the case please
record it and close the bug."
Will add documentation.
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
--
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