how to configure the default database DefaultDS to oracle in

[jack0501]

I tried to configure the default database DefaultDS to oracle 9i in the clustered environment.
The step I did is in the following:
1. delete the hsqldb.xml.
2. configure DefaultDS datasource to oracle in the oracle-ds.xml
3. change login-config.xml, oracle-jdbc2-service.xml and oracle-jdbc-state-service.xml file to use DefaultDS.

When I start the jboss, the exception occur in the jboss console. When I check the database, I found 5 tables created in order to use the JMS feature, I can not found the HILOSequence table which supposed to create in the database.
I really appreciate some one help.
Thanks.
Jack

The error message is in the following:

--- MBeans waiting for other MBeans ---

ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: ORA-00942: table or view does not exist
I Depend On:
jboss:service=TransactionManager
jboss.jca:name=DefaultDS,service=DataSourceBinding

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: FAILED
Reason: java.sql.SQLException: ORA-00942: table or view does not exist
I Depend On:
jboss:service=TransactionManager
jboss.jca:name=DefaultDS,service=DataSourceBinding

[ren0130]

Start JBoss, then goto http://localhost:8080/jmx-console/
find link: service=KeyGeneratorFactory,type=HiLo
click, then change its value
jboss.jca.name=DefaultDS to your datasource value

in "List of MBean attributes" section

[sumtraveller]

How do I persist this change? I don't want to have to make that change each and every time I start the application?

Thanks!!!

[arthomas73]

Has anyone figured this out?

[arthomas73]

I found the answer... here

www.oreilly.com/catalog/jbossadn/chapter/ch09.pdf

I simply removed the deploy/uuid-key-generator.sar

however if you want to change the datasource form DefaultDS you need to explode the sar and change jboss-service.xml file.