[esb-issues] [JBoss JIRA] Commented: (JBESB-1648) Error running helloworld_tx_sql_action quickstart - does not work as expected, doumentation is incorrect

Jiri Pechanec (JIRA) jira-events at lists.jboss.org
Thu Apr 10 09:46:56 EDT 2008 

    [ http://jira.jboss.com/jira/browse/JBESB-1648?page=comments#action_12408085 ] 
            
Jiri Pechanec commented on JBESB-1648:
--------------------------------------

Output from log
2008-04-10 15:41:15,907 INFO  [STDOUT] 
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,907 INFO  [STDOUT] column DATA_COLUMN = <data 111111>column TIMESTAMP_COL = <null>column UNIQUE_ID = <1>
2008-04-10 15:41:15,907 INFO  [STDOUT] &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,907 INFO  [STDOUT] Will commit transaction. Will not see record again!
2008-04-10 15:41:15,909 INFO  [STDOUT] Message structure: 
2008-04-10 15:41:15,909 INFO  [STDOUT] [column DATA_COLUMN = <data 111111>column TIMESTAMP_COL = <null>column UNIQUE_ID = <1>].
2008-04-10 15:41:15,912 INFO  [STDOUT] 
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,912 INFO  [STDOUT] DATA READ: data 22
2008-04-10 15:41:15,912 INFO  [STDOUT] column DATA_COLUMN = <data 22>
2008-04-10 15:41:15,912 INFO  [STDOUT] &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,912 INFO  [STDOUT] Will rollback transaction. Expect to see record again!
2008-04-10 15:41:15,912 INFO  [STDOUT] BAD READ ON DATA!
2008-04-10 15:41:15,913 WARN  [org.jboss.soa.esb.listeners.message.ActionProcessingPipeline] Unexpected exception caught while processing the action pipeline: header: [ To: JDBCEpr [ PortReference < <wsa:Address jdbc:hsqldb:hsql://localhost:1703/>, <wsa:ReferenceProperties jbossesb:postDelete : true/>, <wsa:ReferenceProperties jbossesb:errorDelete : true/>, <wsa:ReferenceProperties jbossesb:datasource : java:/QuickstartDB/>, <wsa:ReferenceProperties jbossesb:tablename : TX_ESB_MESSAGES/>, <wsa:ReferenceProperties jbossesb:message_id_column : MESSAGE_ID/>, <wsa:ReferenceProperties jbossesb:status_column : STATUS_COL/>, <wsa:ReferenceProperties jbossesb:message_column : DATA_COLUMN/>, <wsa:ReferenceProperties jbossesb:insert_timestamp_column : TIMESTAMP_COL/>, <wsa:ReferenceProperties jbossesb:type : urn:jboss/esb/epr/type/jdbc/> > ] MessageID: 2241d1e9-0196-4df5-b0c6-8ecfb3cff0e9 ]
java.lang.RuntimeException
        at org.jboss.soa.esb.samples.quickstart.helloworldtxsqlaction.MyAction.displayMessage(MyAction.java:79)
        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$1.run(MessageAwareListener.java:303)
        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-04-10 15:41:15,924 WARN  [org.jboss.soa.esb.listeners.message.ActionProcessingPipeline] No fault address defined for fault message! To: JDBCEpr [ PortReference < <wsa:Address jdbc:hsqldb:hsql://localhost:1703/>, <wsa:ReferenceProperties jbossesb:postDelete : true/>, <wsa:ReferenceProperties jbossesb:errorDelete : true/>, <wsa:ReferenceProperties jbossesb:datasource : java:/QuickstartDB/>, <wsa:ReferenceProperties jbossesb:tablename : TX_ESB_MESSAGES/>, <wsa:ReferenceProperties jbossesb:message_id_column : MESSAGE_ID/>, <wsa:ReferenceProperties jbossesb:status_column : STATUS_COL/>, <wsa:ReferenceProperties jbossesb:message_column : DATA_COLUMN/>, <wsa:ReferenceProperties jbossesb:insert_timestamp_column : TIMESTAMP_COL/>, <wsa:ReferenceProperties jbossesb:type : urn:jboss/esb/epr/type/jdbc/> > ] MessageID: 2241d1e9-0196-4df5-b0c6-8ecfb3cff0e9
2008-04-10 15:41:15,992 INFO  [STDOUT] 
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,992 INFO  [STDOUT] column DATA_COLUMN = <data 333333333333111111>column TIMESTAMP_COL = <null>column UNIQUE_ID = <3>
2008-04-10 15:41:15,992 INFO  [STDOUT] &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,992 INFO  [STDOUT] Will commit transaction. Will not see record again!
2008-04-10 15:41:15,993 INFO  [STDOUT] Message structure: 
2008-04-10 15:41:15,993 INFO  [STDOUT] [column DATA_COLUMN = <data 333333333333111111>column TIMESTAMP_COL = <null>column UNIQUE_ID = <3>].
2008-04-10 15:41:15,995 INFO  [STDOUT] 
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,996 INFO  [STDOUT] column DATA_COLUMN = <data d d d d>column TIMESTAMP_COL = <null>column UNIQUE_ID = <4>
2008-04-10 15:41:15,996 INFO  [STDOUT] &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,996 INFO  [STDOUT] Will commit transaction. Will not see record again!
2008-04-10 15:41:15,996 INFO  [STDOUT] Message structure: 
2008-04-10 15:41:15,996 INFO  [STDOUT] [column DATA_COLUMN = <data d d d d>column TIMESTAMP_COL = <null>column UNIQUE_ID = <4>].
2008-04-10 15:41:15,998 INFO  [STDOUT] 
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,998 INFO  [STDOUT] column DATA_COLUMN = <data last record>column TIMESTAMP_COL = <null>column UNIQUE_ID = <6>
2008-04-10 15:41:15,998 INFO  [STDOUT] &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
2008-04-10 15:41:15,998 INFO  [STDOUT] Will commit transaction. Will not see record again!
2008-04-10 15:41:15,998 INFO  [STDOUT] Message structure: 
2008-04-10 15:41:15,998 INFO  [STDOUT] [column DATA_COLUMN = <data last record>column TIMESTAMP_COL = <null>column UNIQUE_ID = <6>].

I suppose that record with data 22 should be present twice in log, not only once

> 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

More information about the esb-issues mailing list