[esb-issues] [JBoss JIRA] Closed: (JBESB-1834) SQLCourier BLOB support does not work on mysql

SQLCourier BLOB support does not work on mysql ---------------------------------------------- Key: JBESB-1834 URL: http://jira.jboss.com/jira/browse/JBESB-1834 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Rosetta Affects Versions: 4.3, 4.2.1 CP3 Reporter: Jiri Pechanec Assigned To: Kevin Conner Fix For: 4.2.1 CP4, 4.4 Attachments: jboss-esb.xml, mysql-tx.log.gz, mysql-xa-ds.xml The BLOB support, added as part of JBESB-1690, is not sufficient for mysql. When the BYTEA datatype is used the record is read from gw table and status changed to D but the record in ESB message table is not nevertheless created. When varchar and text datatype are used and the exception is thrown the transaction is correctly rolled back but the record in ESB message table has status set to D, so no retry is exexcuted 2008-06-19 15:46:10,081 WARN [org.jboss.soa.esb.listeners.message.ActionProcessingPipeline] Unexpected exception caught while processing the action pipeline: header: [ To: JDBCEpr [ PortReference < <wsa:Address jdbc:mysql://localhost:3306/soaesb1/>, <wsa:ReferenceProperties jbossesb:errorDelete : true/>, <wsa:ReferenceProperties jbossesb:datasource : java:/DefaultXADS/>, <wsa:ReferenceProperties jbossesb:tablename : CLOB_ESB_MESSAGE_TABLE/>, <wsa:ReferenceProperties jbossesb:message_id_column : UNIQUE_ID/>, <wsa:ReferenceProperties jbossesb:status_column : STATUS_COL/>, <wsa:ReferenceProperties jbossesb:message_column : CLOB_DATA_COLUMN/>, <wsa:ReferenceProperties jbossesb:insert_timestamp_column : TIMESTAMP_COL/>, <wsa:ReferenceProperties jbossesb:type : urn:jboss/esb/epr/type/jdbc/> > ] MessageID: f37d7f32-eef1-45e5-b1b9-8bf72ae782d9 ] java.lang.NullPointerException: Simulate exception at org.jboss.soa.esb.samples.quickstart.tx_bpm.FailingAction.process(FailingAction.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.soa.esb.listeners.message.ActionProcessorMethodInfo.processMethods(ActionProcessorMethodInfo.java:102) at org.jboss.soa.esb.listeners.message.OverriddenActionLifecycleProcessor.process(OverriddenActionLifecycleProcessor.java:74) at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:316) at org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:530) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:595) 2008-06-19 15:46:10,082 TRACE [org.jboss.soa.esb.common.JBossESBPropertyService$JTATransactionStrategy] Rollback transaction on current thread 2008-06-19 15:46:10,092 ERROR [STDERR] Exception in thread "pool-63-thread-1" 2008-06-19 15:46:10,092 ERROR [STDERR] java.lang.NullPointerException: Simulate exception 2008-06-19 15:46:10,092 ERROR [STDERR] at org.jboss.soa.esb.samples.quickstart.tx_bpm.FailingAction.process(FailingAction.java:45) 2008-06-19 15:46:10,092 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2008-06-19 15:46:10,092 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2008-06-19 15:46:10,092 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2008-06-19 15:46:10,092 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585) 2008-06-19 15:46:10,092 ERROR [STDERR] at org.jboss.soa.esb.listeners.message.ActionProcessorMethodInfo.processMethods(ActionProcessorMethodInfo.java:102) 2008-06-19 15:46:10,092 ERROR [STDERR] at org.jboss.soa.esb.listeners.message.OverriddenActionLifecycleProcessor.process(OverriddenActionLifecycleProcessor.java:74) 2008-06-19 15:46:10,092 ERROR [STDERR] at org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:316) 2008-06-19 15:46:10,092 ERROR [STDERR] at org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:530) 2008-06-19 15:46:10,092 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) 2008-06-19 15:46:10,092 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) 2008-06-19 15:46:10,092 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595) Please see attached log file, jboss-esb.xml file and datasource config file.