[jboss-user] [Beginner's Corner] - 'table does not exist' error after changing default databse
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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...