[jboss-user] [JCA/JBoss] - 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 



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959295#3959295

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959295