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

[Darrin Mison (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBESB-1690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12422466#action_12422466 ] 

Darrin Mison commented on JBESB-1690:
-------------------------------------

Proposed SOA 4.2 TP02 Release Note:
The SQL listener serialization is now implemented via BLOBs to be more usable with more databases

> The SQL listener is not usable with most of databases
> -----------------------------------------------------
>
>                 Key: JBESB-1690
>                 URL: https://jira.jboss.org/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
>            Assignee: 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: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira