2 Replies Latest reply on Feb 14, 2004 6:17 AM by Heiko Rupp

    MSSQL problem with JMS messages

    Sebastiaan Kortleven Newbie

      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!