1 Reply Latest reply on Sep 9, 2004 11:26 AM by adrian.brock

    Unknown Table JMS_MESSAGES

    hjolldar

      Hi,

      I tried to get a Borland Interbase database (Version 7.1) running with JBoss (Version 3.2.5).
      I installed the database (dialect 3) and created the correct Data source:

      <datasources>
       <local-tx-datasource>
       <jndi-name>DefaultDS</jndi-name>
       <connection-url>jdbc:interbase://localhost/c:\mydatabase\db-file</connection-url>
       <driver-class>interbase.interclient.Driver</driver-class>
       <user-name>sysdba</user-name>
       <password>123456</password>
       <min-pool-size>0</min-pool-size>
       </local-tx-datasource>
      </datasources>
      


      At the JBoss' startup the datasource loads correctly and is available in the JNDI. But then, when the jboss continues to start, provides the following message:


      15:04:36,062 ERROR [PersistenceManager] Starting failed
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql
      .SQLException: [interclient][interbase]Dynamic SQL Error
      [interclient][interbase]SQL error code = -204
      [interclient][interbase]Table unknown
      [interclient][interbase]JMS_MESSAGES)


      Where does this error come from and how can I fix it?

      Thanks a lot
      Matthias