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 Tie
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=3959139#3959139
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959139
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
