4:48 a.m.
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
Reporter: Jiri Pechanec
Assigned To: Kevin Conner
Priority: Critical
Fix For: 4.2.1 CP3
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
<Envelope><Header
xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing">...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
xmlns:jbossesb="http://schemas.jboss.com/ws/2007/01/jbossesb"&g...
/><Body><Content><Key>b3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS5kZWZhdWx0RW50cnk=</Key><Value><marshalunmarshal><plugin-type>urn:xml/marshalunmarshal/plugin/serialization</plugin-type>rO0ABXNyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAx3CAAAABAAAAACdAAJdW5pcXVlX2lkc3IAEWphdmEubGFuZy5JbnRlZ2VyEuKgpPeBhzgCAAFJAAV2YWx1ZXhyABBqYXZhLmxhbmcuTnVtYmVyhqyVHQuU4IsCAAB4cAAAAAF0AAtkYXRhX2NvbHVtbnQAEEhlbGxvIEVTQiBXb3JsZCF4</marshalunmarshal></Value></Content><Content><Key>b3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS5kZWZhdWx0RW50cnktc2V0LXN0YWNr</Key><Value><marshalunmarshal><plugin-type>urn:xml/marshalunmarshal/plugin/serialization</plugin-type>rO0ABXNyABNqYXZhLmxhbmcuRXhjZXB0aW9u0P0fPho7HMQCAAB4cgATamF2YS5sYW5nLlRocm93YWJsZdXGNSc5d7jLAwADTAAFY2F1c2V0ABVMamF2YS9sYW5nL1Rocm93YWJsZTtMAA1kZXRhaWxNZXNzYWdldAASTGphdmEvbGFuZy9TdHJpbmc7WwAKc3RhY2tUcmFjZXQAHltMamF2YS9sYW5nL1N0YWNrVHJhY2VFbGVtZW50O3hwcQB+AAV0AERzZXRQYXlsb2FkIHN0YWNrIHRyYWNlIGZvciAnb3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS5kZWZhdWx0RW50cnknLnVyAB5bTGphdmEubGFuZy5TdGFja1RyYWNlRWxlbWVudDsCRio8PP0iOQIAAHhwAAAACnNyABtqYXZhLmxhbmcuU3RhY2tUcmFjZUVsZW1lbnRhCcWaJjbdhQIABEkACmxpbmVOdW1iZXJMAA5kZWNsYXJpbmdDbGFzc3EAfgADTAAIZmlsZU5hbWVxAH4AA0wACm1ldGhvZE5hbWVxAH4AA3hwAAAA1XQALW9yZy5qYm9zcy5zb2EuZXNiLm1lc3NhZ2UuTWVzc2FnZVBheWxvYWRQcm94eXQAGE1lc3NhZ2VQYXlsb2FkUHJveHkuamF2YXQACnNldFBheWxvYWRzcQB+AAkAAAC0cQB+AAtxAH4ADHEAfgANc3EAfgAJAAADPHQATm9yZy5qYm9zcy5zb2EuZXNiLmxpc3RlbmVycy5nYXRld2F5LlNxbFRhYmxlR2F0ZXdheUxpc3RlbmVyJFBhY2thZ2VSb3dDb250ZW50c3QAHFNxbFRhYmxlR2F0ZXdheUxpc3RlbmVyLmphdmF0AAdwcm9jZXNzc3EAfgAJ/////nQAJHN1bi5yZWZsZWN0Lk5hdGl2ZU1ldGhvZEFjY2Vzc29ySW1wbHQAHU5hdGl2ZU1ldGhvZEFjY2Vzc29ySW1wbC5qYXZhdAAHaW52b2tlMHNxAH4ACQAAACdxAH4AFHEAfgAVdAAGaW52b2tlc3EAfgAJAAAAGXQAKHN1bi5yZWZsZWN0LkRlbGVnYXRpbmdNZXRob2RBY2Nlc3NvckltcGx0ACFEZWxlZ2F0aW5nTWV0aG9kQWNjZXNzb3JJbXBsLmphdmFxAH4AGHNxAH4ACQAAAkl0ABhqYXZhLmxhbmcucmVmbGVjdC5NZXRob2R0AAtNZXRob2QuamF2YXEAfgAYc3EAfgAJAAAAt3QAO29yZy5qYm9zcy5zb2EuZXNiLmxpc3RlbmVycy5nYXRld2F5LlNxbFRhYmxlR2F0ZXdheUxpc3RlbmVycQB+ABF0AAVkb1J1bnNxAH4ACQAAAHN0AEZvcmcuamJvc3Muc29hLmVzYi5saXN0ZW5lcnMubGlmZWN5Y2xlLkFic3RyYWN0VGhyZWFkZWRNYW5hZ2VkTGlmZWN5Y2xldAAlQWJzdHJhY3RUaHJlYWRlZE1hbmFnZWRMaWZlY3ljbGUuamF2YXQAA3J1bnNxAH4ACQAAAlN0ABBqYXZhLmxhbmcuVGhyZWFkdAALVGhyZWFkLmphdmFxAH4AJXg=</marshalunmarshal></Value></Content></Body><Attachment
/><Properties><Property><Key>b3JnLmpib3NzLnNvYS5lc2IuZ2F0ZXdheS5vcmlnaW5hbC51cmw=</Key><Value>rO0ABXQAKGpkYmM6cG9zdGdyZXNxbDovL2xvY2FsaG9zdDo1NDMyL3NvYWVzYjE=</Value></Property><Property><Key>b3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS50aW1lLmRvYg==</Key><Value>rO0ABXQAHVdlZCBBcHIgMjMgMTE6Mzk6MzcgQ0VTVCAyMDA4</Value></Property><Property><Key>b3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS5zb3VyY2U=</Key><Value>rO0ABXQAOlBvcnRSZWZlcmVuY2UgPCBqZGJjOnBvc3RncmVzcWw6Ly9sb2NhbGhvc3Q6NTQzMi9zb2Flc2IxID4=</Value></Property><Property><Key>b3JnLmpib3NzLnNvYS5lc2IubWVzc2FnZS50cmFuc3BvcnQudHlwZQ==</Key><Value>rO0ABX5yAC9vcmcuamJvc3Muc29hLmVzYi5jb21tb24uRW52aXJvbm1lbnQkVHJhbnNwb3J0cwAAAAAAAAAAEgAAeHIADmphdmEubGFuZy5FbnVtAAAAAAAAAAASAAB4cHQAA1NRTA==</Value></Property></Properties></Envelope>
--
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