Satish Kumar L V wrote:
Hi,
I am deploying a session and MDB. While starting the persistence manager, JBoss throws the following exception...
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: ORA-00942: table or view does not exist What does this mean? Do I have to create the tables prior to deployment. I see the create statements for the tables in the jboss-mq-service.xml under the persistence manager. Can anybody explain this?

The tables for storing the JMS messages do not exist. There are created automatically during JBoss startup but perhaps your db user did not have enough rights to do this or the SQL did not match to your database. You can create these tables yourself with the sql persistence manager settings (CREATE_MESSAGE_TABLE and CREATE_TX_TABLE) in jbossmq-service.xml.


-marek



-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to