[jboss-user] [Beginner's Corner] - 'table does not exist' error after changing default databse

[bwalker55]

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)



View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4259690#4259690

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4259690