5 Replies Latest reply on Jul 21, 2006 3:48 AM by s sg

    HILO, oracle9i

    s sg Newbie

      I am using the jboss4.0.3 ,
      and datasource from sqlserver to oracle9i

      now, when I deploy the oracle-ds.xml, ejb is ok! But it show me
      the errors as following:

      someone help?

      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
      State: FAILED
      Reason: java.sql.SQLException: ORA-00942: ???????

        • 1. Re: HILO, oracle9i
          Frank Langelage Master

          ORA 942: "table does not exist".
          So you'll have to create the table or allow jboss to do it on startup.

          • 2. Re: HILO, oracle9i
            s sg Newbie

            before starting the jboss, I create table in sqlplus with the same user as oracle-ds.xml.

            once run the jboss, the table that created would be deleted by jboss automatically

            • 3. Re: HILO, oracle9i
              s sg Newbie

              the database user owns all role and all privillages
              so I don't know what happen! :(

              • 4. Re: HILO, oracle9i
                s sg Newbie

                but everything is ok when sqlserver, why?

                • 5. Re: HILO, oracle9i
                  s sg Newbie

                  15:44:47,609 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=oracleds'
                  to JNDI name 'java:oracleds'
                  15:44:49,718 WARN [ServiceController] Problem starting service jboss:service=KeyGeneratorFactory,type=HiLo
                  java.sql.SQLException: ORA-00942: table or view not exists

                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
                  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
                  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
                  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
                  at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
                  at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
                  at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
                  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:865)
                  at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:161)
                  at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.dropTableIfExists(HiLoKeyGeneratorFactory.java:315)
                  at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:211)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
                  at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)