[esb-issues] [JBoss JIRA] Work started: (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 ]

Work on JBESB-1690 started by Kevin Conner.

> 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