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

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