0 Replies Latest reply on Jul 19, 2006 10:28 AM by jack tie

    how to configure the jboss default database DefaultDS to ora

    jack tie Newbie

      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