[jboss-user] [Beginner's Corner] - Re: 'table does not exist' error after changing default data

[bwalker55]

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