[esb-issues] [JBoss JIRA] Resolved: (JBESB-1418) SQLGateway duplicates column names in message and adds process column

[Tom Cunningham (JIRA)]

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

Tom Cunningham resolved JBESB-1418.
-----------------------------------

    Resolution: Done

Fixed - the message will no longer contain two sets of column names, but we still do the comparisons to upper-cased column names so that lower case column names work in MySQL.

drseuss:src tcunning$ svn commit org/jboss/soa/esb/listeners/gateway/SqlTableGatewayListener.java
Sending        org/jboss/soa/esb/listeners/gateway/SqlTableGatewayListener.java
Transmitting file data .
Committed revision 17500.

> SQLGateway duplicates column names in message and adds process column
> ---------------------------------------------------------------------
>
>                 Key: JBESB-1418
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1418
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Adapters, Rosetta
>    Affects Versions: 4.2.1
>         Environment: FC7/PostgreSQL
>            Reporter: Jiri Pechanec
>         Assigned To: Tom Cunningham
>             Fix For: 4.2.1 CP1
>
>
> Table was created
> create table GATEWAY_TABLE (UNIQUE_ID integer, DATA_COLUMN varchar(255), STATUS_COL varchar(255))
> body: [ objects: {org.jboss.soa.esb.message.defaultEntry={DATA_COLUMN=Bye ESB World, STATUS_COL=P, UNIQUE_ID=5, unique_id=5, status_col=P, data_column=Bye ESB World}, org.jboss.soa.esb.message.defaultEntry-set-stack=Deferred serialized value: 3fa3586c} ]
> The issue is probably related to upper/lower case names of columns

-- 
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