[esb-issues] [JBoss JIRA] Commented: (JBESB-1648) Error running helloworld_tx_sql_action quickstart - does not work as expected, doumentation is incorrect
[ http://jira.jboss.com/jira/browse/JBESB-1648?page=comments#action_12408122 ]
Len DiMaggio commented on JBESB-1648:
-------------------------------------
In SOA-P GA - the quickstart puts the server into an infinite loop with this exception:
11:43:19,138 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:43:19,139 ERROR [STDERR] java.sql.SQLException: Table not found in statement [select
MESSAGE_ID,TIMESTAMP_COL from TX_ESB_MESSAGES where STATUS_COL='P' order by 2]
11:43:19,139 ERROR [STDERR] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
11:43:19,139 ERROR [STDERR] at
org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
11:43:19,139 ERROR [STDERR] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown
Source)
11:43:19,139 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
11:43:19,139 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:337)
11:43:19,139 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
11:43:19,139 ERROR [STDERR] at
org.jboss.soa.esb.helpers.persist.JdbcCleanConn.prepareStatement(JdbcCleanConn.java:144)
11:43:19,139 ERROR [STDERR] at
org.jboss.internal.soa.esb.couriers.SqlTableCourier.listStatement(SqlTableCourier.java:542)
11:43:19,139 ERROR [STDERR] at
org.jboss.internal.soa.esb.couriers.SqlTableCourier.getRowList(SqlTableCourier.java:452)
11:43:19,139 ERROR [STDERR] at
org.jboss.internal.soa.esb.couriers.SqlTableCourier.pickup(SqlTableCourier.java:272)
11:43:19,139 ERROR [STDERR] at
org.jboss.internal.soa.esb.couriers.TwoWayCourierImpl.pickup(TwoWayCourierImpl.java:223)
11:43:19,139 ERROR [STDERR] at
org.jboss.internal.soa.esb.couriers.TwoWayCourierImpl.pickup(TwoWayCourierImpl.java:205)
11:43:19,139 ERROR [STDERR] at
org.jboss.soa.esb.listeners.message.MessageAwareListener.waitForEventAndProcess(MessageAwareListener.java:304)
11:43:19,139 ERROR [STDERR] at
org.jboss.soa.esb.listeners.message.MessageAwareListener.doRun(MessageAwareListener.java:264)
11:43:19,139 ERROR [STDERR] at
org.jboss.soa.esb.listeners.lifecycle.AbstractThreadedManagedLifecycle.run(AbstractThreadedManagedLifecycle.java:115)
11:43:19,139 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
Error running helloworld_tx_sql_action quickstart - does not work as
expected, doumentation is incorrect
--------------------------------------------------------------------------------------------------------
Key: JBESB-1648
URL: http://jira.jboss.com/jira/browse/JBESB-1648
Project: JBoss ESB
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Examples, Rosetta
Affects Versions: 4.2.1 CP1
Environment: JBoss SOA Platform? Standalone Server - Version 4.2.0.GA_CP01
Reporter: Jehudi Castro
Assigned To: Mark Little
Priority: Critical
Attachments: server.log.zip
There are two issues with this quickstart
1) It does not describe what is expected to happen in it - transaction procession
2) The output of this test should be that rolled back record should be present twice in
processing, but it is processed only once
Maybe is not TX processing working?
--
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