4:50 a.m.
[ http://jira.jboss.com/jira/browse/JBESB-1690?page=all ]
Jiri Pechanec updated JBESB-1690:
---------------------------------
Environment: FC8/PostgreSQL
Description:
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
was:
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>
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