[ http://jira.jboss.com/jira/browse/JBESB-1834?page=all ] Jiri Pechanec updated JBESB-1834: --------------------------------- Description: 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. was: The BLOB support, added as part of JBESB-1690, is not sufficient for postgres. The issue lies in the creation of the table entries as the code uses the statement.setObject method to initialise the parameter. We need to change this to use the setCharacterStream/setBinaryStream equivalents. -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1834?page=all ] Jiri Pechanec updated JBESB-1834: --------------------------------- Attachment: mysql-xa-ds.xml -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1834?page=all ] Kevin Conner closed JBESB-1834. ------------------------------- Resolution: Done The changes for JBESB-1805 cover this case. -- 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