-
1. Re: HILO, oracle9i
lafr Jul 15, 2006 4:36 AM (in response to ssgemail)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
ssgemail Jul 21, 2006 3:33 AM (in response to ssgemail)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
ssgemail Jul 21, 2006 3:34 AM (in response to ssgemail)the database user owns all role and all privillages
so I don't know what happen! :( -
4. Re: HILO, oracle9i
ssgemail Jul 21, 2006 3:35 AM (in response to ssgemail)but everything is ok when sqlserver, why?
-
5. Re: HILO, oracle9i
ssgemail Jul 21, 2006 3:48 AM (in response to ssgemail)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)