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
4:50 a.m.
New subject: [JBoss JIRA] Updated: (JBESB-1690) The SQL listener is not usable with most of databases
[ 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
4:50 a.m.
New subject: [JBoss JIRA] Updated: (JBESB-1690) The SQL listener is not usable with most of databases
[ http://jira.jboss.com/jira/browse/JBESB-1690?page=all ]
Jiri Pechanec updated JBESB-1690:
---------------------------------
Attachment: msg.ser
Exmaple of serialized message attached
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
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
<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
10:03 a.m.
New subject: [JBoss JIRA] Work started: (JBESB-1690) The SQL listener is not usable with most of databases
[ 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
4:25 a.m.
New subject: [JBoss JIRA] Closed: (JBESB-1690) The SQL listener is not usable with most of databases
[ http://jira.jboss.com/jira/browse/JBESB-1690?page=all ]
Kevin Conner closed JBESB-1690.
-------------------------------
Resolution: Done
I have added support for BLOB and CLOB in SqlTableCourier and SqlTableGatewayListener.
The helloworld_tx_sql_action quickstart was also updated to use CLOB for the listener
table, as an example of the usage.
Committed in revision 20263.
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
6:46 p.m.
New subject: [JBoss JIRA] Commented: (JBESB-1690) The SQL listener is not usable with most of databases
[
https://jira.jboss.org/jira/browse/JBESB-1690?page=com.atlassian.jira.plu...
]
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
5985
days inactive
6077
days old
5 comments
3 participants
participants (3)
-
Darrin Mison (JIRA) -
Jiri Pechanec (JIRA)
-
Kevin Conner (JIRA)