JBoss Version is 4.2.0.GA I searched the Wiki and forums for a solution to this problem. I've seen two other posts with the same problem but nobody responded with a solution to I'll try.
I'm trying to change the DefaultDS datasource from hsql to Oracle. I've followed the instructions I found in the wiki at http://wiki.jboss.org/auth/wiki/ConfigJBossMQDB?action=e&windowstate=normal&mode=view. All the JMS tables are being created but the KeyGeneratorFactory fails to deploy. I get the following stack trace in the log: 2008-09-26 08:35:26,847 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Starting jboss:service=KeyGeneratorFactory,type=HiLo 2008-09-26 08:35:26,863 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing SQL: select HIGHVALUES from HILOSEQUENCES where SEQUENCENAME='general' 2008-09-26 08:35:26,894 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Starting failed jboss:service=KeyGeneratorFactory,type=HiLo java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:320) at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:281) If anyone is interested in the entire stack trace I will post it. Can anyone tell me what I need to do to get this to fix this? Thanks, Dave. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4179091#4179091 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179091 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user