I have turned on audiiting in Oracle. The results are: OWNER OBJ_NAME ACTION_NAME ------------------------------------------------- JBOSS JMS_USERS CREATE TABLE JBOSS JMS_ROLES CREATE TABLE JBOSS JMS_SUBSCRIPTIONS CREATE TABLE JBOSS JMS_ROLES SESSION REC JBOSS JMS_USERS SESSION REC JBOSS JMS_TRANSACTIONS SELECT
It would appear that the table that is missing is JMS_TRANSACTIONS. Note that the other three tables have a CREATE TABLE attempt (which will only be successful the first time), then a SELECT. JMS_TRANSACTIONS is never created, so the SELECT statement always fails. I have verified this by created a dummy JMS_TRANSACTIONS table. The error in the log file has changed to: ... Caused by: java.sql.SQLException: ORA-00904: "TXID": invalid identifier ... So obviously TXID is at least one of the column names in JMS_TRANSACTIONS. Can someone please post the schema for JMS_TRANSACTIONS. Thanks, Bob. PS Might also want to raise this issue in the appropriate place to get a CREATE TABLE statement added. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4261364#4261364 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4261364 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
