[esb-issues] [JBoss JIRA] Closed: (JBESB-1690) The SQL listener is not usable with most of databases

[Kevin Conner (JIRA)]

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

Kevin Conner closed JBESB-1690.
-------------------------------

    Resolution: Done

I have added support for BLOB and CLOB in SqlTableCourier and SqlTableGatewayListener.

The helloworld_tx_sql_action quickstart was also updated to use CLOB for the listener table, as an example of the usage.

Committed in revision 20263.

> The SQL listener is not usable with most of databases
> -----------------------------------------------------
>
>                 Key: JBESB-1690
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1690
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Rosetta, Transports
>    Affects Versions: 4.2.1 CP2
>         Environment: FC8/PostgreSQL
>            Reporter: Jiri Pechanec
>         Assigned To: Kevin Conner
>            Priority: Critical
>             Fix For: 4.2.1 CP3
>
>         Attachments: msg.ser
>
>
> When the message is serialized to SQL table it is very long even for really short payload. It prevents the listener to be used with most of databases as the typical character type is not longer then 4000 char. The implementation should be switched to use BLOBs.
> See example of the message
> Payload sent to GW
> Hello ESB World!
> Serialized message created by GW
> in attachment

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