8 Replies Latest reply on Oct 22, 2009 1:35 AM by jaikiran pai

    'table does not exist' error after changing default databse

    Bob Walker Newbie

      I've changed the default database (DefaultDS) to Oracle as per instructions elsewhere. jBoss comes up and works. Tables, with what look like sample entries, are created in Oracle. However, the startup logs show an error attempting to access (25 times) a table that does not exist. Any ideas?

      Thanks, Bob
      -------------
      09:49:48,870 WARN [JDBCSupport] SQLException caught, SQLState 42000 code:942- assuming deadlock detected, try:25
      java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
      at org.jboss.messaging.core.impl.JDBCPersistenceManager$1ReserveIDBlockRunner.doTransaction(JDBCPersistenceManager.java:407)

      ...snipped for brevity...

      at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
      at org.jboss.Main.boot(Main.java:221)
      at org.jboss.Main$1.run(Main.java:556)
      at java.lang.Thread.run(Thread.java:619)

      09:49:48,872 ERROR [JDBCSupport] Retried 25 times, now giving up
      09:49:48,875 ERROR [ExceptionUtil] ServerPeer[0] startService
      java.lang.IllegalStateException: Failed to execute transaction
      at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry(JDBCSupport.java:544)
      at org.jboss.messaging.core.impl.JDBCPersistenceManager.reserveIDBlock(JDBCPersistenceManager.java:477)
      at org.jboss.messaging.core.impl.IDManager.getNextBigBlock(IDManager.java:87)
      at org.jboss.messaging.core.impl.IDManager.start(IDManager.java:74)
      at org.jboss.jms.server.ServerPeer.startService(ServerPeer.java:310)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)