[esb-issues] [JBoss JIRA] Commented: (JBESB-1419) SQLGatewayListener has problems when uses lowercase values in process fields
Tom Cunningham (JIRA)
jira-events at lists.jboss.org
Wed Jan 2 16:09:43 EST 2008
[ 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
More information about the esb-issues
mailing list