I originally posted this in the JCA forum but it was suggested that I post it here. So,
here it is...
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=....
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=4179411#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...