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

[Tom Cunningham (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-1419?page=all ]

Tom Cunningham resolved JBESB-1419.
-----------------------------------

    Resolution: Done

Add documentation for SQL gateway into Programmer's Guide and into javadoc.

> 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