MSSQL problem with JMS messages

aquila125 Feb 12, 2004 4:10 AM

Hi there,

I just recently started using JBoss and I encountered this problem:

I'm using MSSQL2K and have changed the .xml files to map DefaultDS to this database. When I start the server I get this error:

2004-02-12 10:43:58,001 ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'JMS_MESSAGES'.)

If I deploy a CMP EJB the tables get generated just fine...
What am I doing wrong?

tnx in advance!

1. Re: MSSQL problem with JMS messages

pilhuhn Feb 14, 2004 5:11 AM (in response to aquila125)

Is the table created by jboss at all? Are underscores allowed in table names inMSSQL?
If the tables do not get created, you might have a look at the table creation in deploy/jms/hsqldb-jdbc2-service.xml. There are sql statements to create the tables. Adapt them to mssql and after having done this, submit your findings at the trackers at http://sf.net/projects/jboss/
Actions
2. Re: MSSQL problem with JMS messages

pilhuhn Feb 14, 2004 6:17 AM (in response to aquila125)

Btw.: in docs/examples/jms/ there is already a mssql-jdb2-service.xml that you can drop in instead of the default hsqldb-jdbc2-service.xml
Actions

Go to original post