[jboss-user] [JCA/JBoss] - Problems changing DefaultDS

[drathnow]

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