Timestamp & Oracle
Locked
 
|
Hello to everybody.
I'm working with OfBiz using an Oracle DB. I've got an error on the timestamp using the JOB_SANDBOX table. The problem is in the java.sql.Timestamp format that is not compatible with oracle.sql.TIMESTAMP. I've just tryed to convert all the occurrency of Timestamp type in the framework\service\src\org\ofbiz\service\job\JobManager.java source on TIMESTAMP type but without result. I'm looking for a solution, but if someone has already solved this same problem or want to give me a suggestion... I'd welcome his hints. Thanks in advance! 2006-11-16 18:24:42,562 (org.ofbiz.service.job.JobPoller@ab444) [ GenericDelegator.java:945:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month )). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month )) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month )) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) org.ofbiz.service.job.JobManager.poll(JobManager.java:151) org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) java.lang.Thread.run(Thread.java:595) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month ) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) org.ofbiz.service.job.JobManager.poll(JobManager.java:151) org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) java.lang.Thread.run(Thread.java:595) java.sql.SQLException: ORA-01843: not a valid month oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) org.ofbiz.service.job.JobManager.poll(JobManager.java:151) org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) java.lang.Thread.run(Thread.java:595) -------------------------------------------------------------------------------- |
|
|
Yes,
I've already seen something similar. Have a look at the info in this page and see if they can help: http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle (the doc server seems very low at the moment... if you can't reach this address now, I'm sure it will be available soon) Jacopo yh-maurizio wrote: > Hello to everybody. > > I'm working with OfBiz using an Oracle DB. I've got an error on the > timestamp using the JOB_SANDBOX table. The problem is in the > java.sql.Timestamp format that is not compatible with oracle.sql.TIMESTAMP. > I've just tryed to convert all the occurrency of Timestamp type in the > framework\service\src\org\ofbiz\service\job\JobManager.java source on > TIMESTAMP type but without result. > I'm looking for a solution, but if someone has already solved this same > problem or want to give me a suggestion... I'd welcome his hints. > > Thanks in advance! > > 2006-11-16 18:24:42,562 (org.ofbiz.service.job.JobPoller@ab444) [ > GenericDelegator.java:945:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception > occured in updateByCondition (SQL Exception while executing the > following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID > = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS > NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND > (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month > )). Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: Generic Entity Exception occured in updateByCondition (SQL > Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET > RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 > 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND > RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) > (ORA-01843: not a valid month > )) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception > occured in updateByCondition (SQL Exception while executing the > following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID > = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS > NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND > (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month > )) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND > START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID > IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid > month > ) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > java.sql.SQLException: ORA-01843: not a valid month > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) > oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) > oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) > org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > -------------------------------------------------------------------------------- > |
|
|
In reply to this post by yh-maurizio
Dear all & Maurizo,
Do we need a script to create Oracle tables for ofbiz. I saw some script for HSQL. Nice if someone can share Oracle table creation script Chand ----- Original Message ----- From: "yh-maurizio" < > To: <[hidden email]> Sent: Friday, November 17, 2006 2:01 AM Subject: Timestamp & Oracle > > Hello to everybody. > > I'm working with OfBiz using an Oracle DB. I've got an error on the > timestamp using the JOB_SANDBOX table. The problem is in the > java.sql.Timestamp format that is not compatible with > oracle.sql.TIMESTAMP. > I've just tryed to convert all the occurrency of Timestamp type in the > framework\service\src\org\ofbiz\service\job\JobManager.java source on > TIMESTAMP type but without result. > I'm looking for a solution, but if someone has already solved this same > problem or want to give me a suggestion... I'd welcome his hints. > > Thanks in advance! > > 2006-11-16 18:24:42,562 (org.ofbiz.service.job.JobPoller@ab444) [ > GenericDelegator.java:945:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception > occured in updateByCondition (SQL Exception while executing the > following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > STATUS_ID > = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS > NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND > (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month > )). Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: Generic Entity Exception occured in updateByCondition (SQL > Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET > RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 > 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND > RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) > (ORA-01843: not a valid month > )) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception > occured in updateByCondition (SQL Exception while executing the > following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > STATUS_ID > = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS > NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND > (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month > )) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, > STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND > START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND > RUN_BY_INSTANCE_ID > IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a > valid > month > ) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > java.sql.SQLException: ORA-01843: not a valid month > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) > oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) > oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) > org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) > org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) > java.lang.Thread.run(Thread.java:595) > -------------------------------------------------------------------------------- > > -- > View this message in context: > http://www.nabble.com/Timestamp---Oracle-tf2650556.html#a7396724 > Sent from the OFBiz - Dev mailing list archive at Nabble.com. > > |
|
|
ant run-install
Chandresh Turakhia wrote: > Dear all & Maurizo, > > Do we need a script to create Oracle tables for ofbiz. > > I saw some script for HSQL. > > Nice if someone can share Oracle table creation script > > Chand > ----- Original Message ----- From: "yh-maurizio" < > > To: <[hidden email]> > Sent: Friday, November 17, 2006 2:01 AM > Subject: Timestamp & Oracle > > >> >> Hello to everybody. >> >> I'm working with OfBiz using an Oracle DB. I've got an error on the >> timestamp using the JOB_SANDBOX table. The problem is in the >> java.sql.Timestamp format that is not compatible with >> oracle.sql.TIMESTAMP. >> I've just tryed to convert all the occurrency of Timestamp type in the >> framework\service\src\org\ofbiz\service\job\JobManager.java source on >> TIMESTAMP type but without result. >> I'm looking for a solution, but if someone has already solved this same >> problem or want to give me a suggestion... I'd welcome his hints. >> >> Thanks in advance! >> >> 2006-11-16 18:24:42,562 (org.ofbiz.service.job.JobPoller@ab444) [ >> GenericDelegator.java:945:ERROR] >> ---- exception report >> ---------------------------------------------------------- >> Failure in storeByCondition operation for entity [JobSandbox]: >> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >> occured in updateByCondition (SQL Exception while executing the >> following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >> STATUS_ID >> = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS >> NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND >> (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month >> )). Rolling back transaction. >> Exception: org.ofbiz.entity.GenericDataSourceException >> Message: Generic Entity Exception occured in updateByCondition (SQL >> Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET >> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 >> 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL >> AND >> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) >> (ORA-01843: not a valid month >> )) >> ---- stack trace >> --------------------------------------------------------------- >> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >> occured in updateByCondition (SQL Exception while executing the >> following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >> STATUS_ID >> = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS >> NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND >> (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month >> )) >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) >> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >> >> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >> java.lang.Thread.run(Thread.java:595) >> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >> executing >> the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >> STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND >> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >> RUN_BY_INSTANCE_ID >> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a >> valid >> month >> ) >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) >> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) >> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >> >> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >> java.lang.Thread.run(Thread.java:595) >> java.sql.SQLException: ORA-01843: not a valid month >> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) >> oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) >> oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) >> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) >> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) >> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) >> >> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) >> >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) >> >> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) >> >> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) >> >> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) >> >> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) >> >> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >> >> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >> >> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >> java.lang.Thread.run(Thread.java:595) >> -------------------------------------------------------------------------------- >> >> >> -- >> View this message in context: >> http://www.nabble.com/Timestamp---Oracle-tf2650556.html#a7396724 >> Sent from the OFBiz - Dev mailing list archive at Nabble.com. >> >> > |
|
|
In reply to this post by Jacopo Cappellato
Ok, it works fine!
Thank you Jacopo. P.S.: Jacopo are you Italian too? |
|
|
yh-maurizio wrote:
> Ok, it works fine! > Great! > Thank you Jacopo. > > P.S.: Jacopo are you Italian too? Già... vivo a Padova; piacere di conoscerti :-) |
|
|
In reply to this post by Jacopo Cappellato
HI,
I get this error when I try to switch to oracle Chand [java] 3781 [ GenericDelegator.java:140:INFO ] Creating new Delegator with name "default". [java] 3968 [ GenericDelegator.java:124:ERROR] Error creating delegator [java] org.ofbiz.entity.GenericEntityConfException: Could not find a delegator with the name ault [java] at org.ofbiz.entity.model.ModelReader.getModelReader(ModelReader.java:85) [java] at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:144) [java] at org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:12 [java] at org.ofbiz.service.rmi.RmiServiceContainer.start(RmiServiceContainer.java:100) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:12 [java] at org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:71) [java] at org.ofbiz.base.start.Start.startServer(Start.java:178) [java] at org.ofbiz.base.start.Start.start(Start.java:227) [java] at org.ofbiz.base.start.Start.main(Start.java:287) [java] 4031 [ ServiceDispatcher.java:74 :INFO ] [ServiceDispatcher] : Creating new instance [java] 4093 [ ServiceGroupReader.java:105:INFO ] Loaded 1 Group definitions from file:/C:/do ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/common/servicedef/groups_test.xml [java] 4125 [ ServiceGroupReader.java:105:INFO ] Loaded 4 Group definitions from file:/C:/do ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/entityext/servicedef/groups.xml [java] 4140 [ ServiceGroupReader.java:105:INFO ] Loaded 1 Group definitions from file:/C:/do ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/groups_shipment.xml [java] 4140 [ ServiceGroupReader.java:105:INFO ] Loaded 4 Group definitions from file:/C:/do ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/accounting/servicedef/groups.xml [java] 4187 [ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA definitions from file: download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/common/servicedef/secas_test.xml [java] 4265 [ ServiceEcaUtil.java:139:INFO ] Loaded 1 Service ECA definitions from file: download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/content/servicedef/secas.xml [java] 4281 [ ServiceEcaUtil.java:139:INFO ] Loaded 9 Service ECA definitions from file: download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/party/servicedef/secas.xml [java] 4296 [ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA definitions from file: download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/workeffort/servicedef/secas.xml [java] 4343 [ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA definitions from file /download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/secas.xml [java] 4437 [ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA definitions from file /download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/secas_shipment.xml [java] 4468 [ ServiceEcaUtil.java:139:INFO ] Loaded 11 Service ECA definitions from file /download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/accounting/servicedef/secas.xml [java] 4515 [ ServiceEcaUtil.java:139:INFO ] Loaded 28 Service ECA definitions from file /download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/order/servicedef/secas.xml [java] java.lang.NullPointerException [java] at org.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:193) [java] at org.ofbiz.service.job.JobPoller.<init>(JobPoller.java:69) [java] at org.ofbiz.service.job.JobManager.<init>(JobManager.java:77) [java] at org.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:88) [java] at org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:123) [java] at org.ofbiz.service.GenericDispatcher.init(GenericDispatcher.java:81) [java] at org.ofbiz.service.GenericDispatcher.<init>(GenericDispatcher.java:58) [java] at org.ofbiz.service.GenericDispatcher.<init>(GenericDispatcher.java:46) [java] at org.ofbiz.service.rmi.RmiServiceContainer.start(RmiServiceContainer.java:103) [java] at org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:12 [java] at org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:71) [java] at org.ofbiz.base.start.Start.startServer(Start.java:178) [java] at org.ofbiz.base.start.Start.start(Start.java:227) [java] at org.ofbiz.base.start.Start.main(Start.java:287) [java] Java Result: 99 ----- Original Message ----- From: "Jacopo Cappellato" <[hidden email]> To: <[hidden email]> Sent: Friday, November 17, 2006 2:46 AM Subject: Re: Timestamp & Oracle > ant run-install > > Chandresh Turakhia wrote: >> Dear all & Maurizo, >> >> Do we need a script to create Oracle tables for ofbiz. >> >> I saw some script for HSQL. >> >> Nice if someone can share Oracle table creation script >> >> Chand >> ----- Original Message ----- From: "yh-maurizio" < > >> To: <[hidden email]> >> Sent: Friday, November 17, 2006 2:01 AM >> Subject: Timestamp & Oracle >> >> >>> >>> Hello to everybody. >>> >>> I'm working with OfBiz using an Oracle DB. I've got an error on the >>> timestamp using the JOB_SANDBOX table. The problem is in the >>> java.sql.Timestamp format that is not compatible with >>> oracle.sql.TIMESTAMP. >>> I've just tryed to convert all the occurrency of Timestamp type in the >>> framework\service\src\org\ofbiz\service\job\JobManager.java source on >>> TIMESTAMP type but without result. >>> I'm looking for a solution, but if someone has already solved this same >>> problem or want to give me a suggestion... I'd welcome his hints. >>> >>> Thanks in advance! >>> >>> 2006-11-16 18:24:42,562 (org.ofbiz.service.job.JobPoller@ab444) [ >>> GenericDelegator.java:945:ERROR] >>> ---- exception report >>> ---------------------------------------------------------- >>> Failure in storeByCondition operation for entity [JobSandbox]: >>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >>> occured in updateByCondition (SQL Exception while executing the >>> following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>> STATUS_ID >>> = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS >>> NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND >>> (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month >>> )). Rolling back transaction. >>> Exception: org.ofbiz.entity.GenericDataSourceException >>> Message: Generic Entity Exception occured in updateByCondition (SQL >>> Exception while executing the following:UPDATE ECOMMERCE.JOB_SANDBOX SET >>> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 >>> 18:24:42.546' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL >>> AND >>> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) >>> (ORA-01843: not a valid month >>> )) >>> ---- stack trace >>> --------------------------------------------------------------- >>> org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception >>> occured in updateByCondition (SQL Exception while executing the >>> following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>> STATUS_ID >>> = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND START_DATE_TIME IS >>> NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND >>> (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a valid month >>> )) >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >>> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>> java.lang.Thread.run(Thread.java:595) >>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >>> executing >>> the following:UPDATE ECOMMERCE.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, >>> STATUS_ID = ? WHERE ((RUN_TIME <= '2006-11-16 18:24:42.546' AND >>> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND >>> RUN_BY_INSTANCE_ID >>> IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (ORA-01843: not a >>> valid >>> month >>> ) >>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:427) >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >>> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>> java.lang.Thread.run(Thread.java:595) >>> java.sql.SQLException: ORA-01843: not a valid month >>> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) >>> oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) >>> oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) >>> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) >>> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) >>> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) >>> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) >>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) >>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) >>> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) >>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:424) >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:330) >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:285) >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:942) >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:917) >>> org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>> org.ofbiz.service.job.JobPoller.run(JobPoller.java:82) >>> java.lang.Thread.run(Thread.java:595) >>> -------------------------------------------------------------------------------- >>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Timestamp---Oracle-tf2650556.html#a7396724 >>> Sent from the OFBiz - Dev mailing list archive at Nabble.com. >>> >>> >> > > |
Oracle : Warning or Error.
|
|
In reply to this post by Jacopo Cappellato
Dear all ,
I get tons of such messages but application / user registration works. What is reason and implications of this errors. Chand 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_ID] of table [OFBIZ.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_ID] of table [OFBIZ.ACCTG_TRANS_ATTRIBUTE] of entity [AcctgTransAttribute] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ATTR_NAME] of table [OFBIZ.ACCTG_TRANS_ATTRIBUTE] of entity [AcctgTransAttribute] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_ID] of table [OFBIZ.ACCTG_TRANS_ENTRY] of entity [AcctgTransEntry] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_ENTRY_SEQ_ID] of table [OFBIZ.ACCTG_TRANS_ENTRY] of entity [AcctgTransEntry] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_ENTRY_TYPE_ID] of table [OFBIZ.ACCTG_TRANS_ENTRY_TYPE] of entity [AcctgTransEntryType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_TYPE_ID] of table [OFBIZ.ACCTG_TRANS_TYPE] of entity [AcctgTransType] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ACCTG_TRANS_TYPE_ID] of table [OFBIZ.ACCTG_TRANS_TYPE_ATTR] of entity [AcctgTransTypeAttr] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ATTR_NAME] of table [OFBIZ.ACCTG_TRANS_TYPE_ATTR] of entity [AcctgTransTypeAttr] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ADDENDUM_ID] of table [OFBIZ.ADDENDUM] of entity [Addendum] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [MAP_KEY] of table [OFBIZ.ADDRESS_MATCH_MAP] of entity [AddressMatchMap] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [MAP_VALUE] of table [OFBIZ.ADDRESS_MATCH_MAP] of entity [AddressMatchMap] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [PARTY_ID] of table [OFBIZ.AFFILIATE] of entity [Affiliate] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT] of entity [Agreement] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT_ATTRIBUTE] of entity [AgreementAttribute] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [ATTR_NAME] of table [OFBIZ.AGREEMENT_ATTRIBUTE] of entity [AgreementAttribute] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity [AgreementGeographicalApplic] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [AGREEMENT_ITEM_SEQ_ID] of table [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity [AgreementGeographicalApplic] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [GEO_ID] of table [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity [AgreementGeographicalApplic] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT_ITEM] of entity [AgreementItem] IS NOT a primary key in the database, but IS a primary key in the entity definition. The primary key for this table needs to be re-created or modified to add this column to the primary key. Note that data may need to be added first as a primary key column cannot have an null values. ----- Original Message ----- From: "Jacopo Cappellato" <[hidden email]> To: <[hidden email]> Sent: Friday, November 17, 2006 3:17 AM Subject: Re: Timestamp & Oracle > yh-maurizio wrote: >> Ok, it works fine! >> > > Great! > >> Thank you Jacopo. >> >> P.S.: Jacopo are you Italian too? > > Già... vivo a Padova; piacere di conoscerti :-) > > |
Re: Oracle : Warning or Error.
|
|
It looks like your JDBC driver is not getting the meta data it needs for this. If you want it to work, check out DatabaseUtil.java and make changes there. The simplest way to avoid the warnings is to turn the feature off using the attributes on the datasource element in the entityengine.xml file. -David On Nov 17, 2006, at 11:59 AM, Chandresh Turakhia wrote: > Dear all , > > I get tons of such messages but application / user registration works. > > What is reason and implications of this errors. > > Chand > > > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_ID] of table [OFBIZ.ACCTG_TRANS] of > entity [AcctgTrans] IS NOT a primary key in the database, but IS a > primary key in the entity definition. The primary key for this > table needs to be re-created or modified to add this column to the > primary key. Note that data may need to be added first as a primary > key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_ID] of table > [OFBIZ.ACCTG_TRANS_ATTRIBUTE] of entity [AcctgTransAttribute] IS > NOT a primary key in the database, but IS a primary key in the > entity definition. The primary key for this table needs to be re- > created or modified to add this column to the primary key. Note > that data may need to be added first as a primary key column cannot > have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ATTR_NAME] of table [OFBIZ.ACCTG_TRANS_ATTRIBUTE] > of entity [AcctgTransAttribute] IS NOT a primary key in the > database, but IS a primary key in the entity definition. The > primary key for this table needs to be re-created or modified to > add this column to the primary key. Note that data may need to be > added first as a primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_ID] of table [OFBIZ.ACCTG_TRANS_ENTRY] > of entity [AcctgTransEntry] IS NOT a primary key in the database, > but IS a primary key in the entity definition. The primary key for > this table needs to be re-created or modified to add this column to > the primary key. Note that data may need to be added first as a > primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_ENTRY_SEQ_ID] of table > [OFBIZ.ACCTG_TRANS_ENTRY] of entity [AcctgTransEntry] IS NOT a > primary key in the database, but IS a primary key in the entity > definition. The primary key for this table needs to be re-created > or modified to add this column to the primary key. Note that data > may need to be added first as a primary key column cannot have an > null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_ENTRY_TYPE_ID] of table > [OFBIZ.ACCTG_TRANS_ENTRY_TYPE] of entity [AcctgTransEntryType] IS > NOT a primary key in the database, but IS a primary key in the > entity definition. The primary key for this table needs to be re- > created or modified to add this column to the primary key. Note > that data may need to be added first as a primary key column cannot > have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_TYPE_ID] of table > [OFBIZ.ACCTG_TRANS_TYPE] of entity [AcctgTransType] IS NOT a > primary key in the database, but IS a primary key in the entity > definition. The primary key for this table needs to be re-created > or modified to add this column to the primary key. Note that data > may need to be added first as a primary key column cannot have an > null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ACCTG_TRANS_TYPE_ID] of table > [OFBIZ.ACCTG_TRANS_TYPE_ATTR] of entity [AcctgTransTypeAttr] IS NOT > a primary key in the database, but IS a primary key in the entity > definition. The primary key for this table needs to be re-created > or modified to add this column to the primary key. Note that data > may need to be added first as a primary key column cannot have an > null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ATTR_NAME] of table [OFBIZ.ACCTG_TRANS_TYPE_ATTR] > of entity [AcctgTransTypeAttr] IS NOT a primary key in the > database, but IS a primary key in the entity definition. The > primary key for this table needs to be re-created or modified to > add this column to the primary key. Note that data may need to be > added first as a primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ADDENDUM_ID] of table [OFBIZ.ADDENDUM] of entity > [Addendum] IS NOT a primary key in the database, but IS a primary > key in the entity definition. The primary key for this table needs > to be re-created or modified to add this column to the primary key. > Note that data may need to be added first as a primary key column > cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [MAP_KEY] of table [OFBIZ.ADDRESS_MATCH_MAP] of > entity [AddressMatchMap] IS NOT a primary key in the database, but > IS a primary key in the entity definition. The primary key for this > table needs to be re-created or modified to add this column to the > primary key. Note that data may need to be added first as a primary > key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [MAP_VALUE] of table [OFBIZ.ADDRESS_MATCH_MAP] of > entity [AddressMatchMap] IS NOT a primary key in the database, but > IS a primary key in the entity definition. The primary key for this > table needs to be re-created or modified to add this column to the > primary key. Note that data may need to be added first as a primary > key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [PARTY_ID] of table [OFBIZ.AFFILIATE] of entity > [Affiliate] IS NOT a primary key in the database, but IS a primary > key in the entity definition. The primary key for this table needs > to be re-created or modified to add this column to the primary key. > Note that data may need to be added first as a primary key column > cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT] of entity > [Agreement] IS NOT a primary key in the database, but IS a primary > key in the entity definition. The primary key for this table needs > to be re-created or modified to add this column to the primary key. > Note that data may need to be added first as a primary key column > cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT_ATTRIBUTE] > of entity [AgreementAttribute] IS NOT a primary key in the > database, but IS a primary key in the entity definition. The > primary key for this table needs to be re-created or modified to > add this column to the primary key. Note that data may need to be > added first as a primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [ATTR_NAME] of table [OFBIZ.AGREEMENT_ATTRIBUTE] of > entity [AgreementAttribute] IS NOT a primary key in the database, > but IS a primary key in the entity definition. The primary key for > this table needs to be re-created or modified to add this column to > the primary key. Note that data may need to be added first as a > primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [AGREEMENT_ID] of table > [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity > [AgreementGeographicalApplic] IS NOT a primary key in the database, > but IS a primary key in the entity definition. The primary key for > this table needs to be re-created or modified to add this column to > the primary key. Note that data may need to be added first as a > primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [AGREEMENT_ITEM_SEQ_ID] of table > [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity > [AgreementGeographicalApplic] IS NOT a primary key in the database, > but IS a primary key in the entity definition. The primary key for > this table needs to be re-created or modified to add this column to > the primary key. Note that data may need to be added first as a > primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [GEO_ID] of table > [OFBIZ.AGREEMENT_GEOGRAPHICAL_APPLIC] of entity > [AgreementGeographicalApplic] IS NOT a primary key in the database, > but IS a primary key in the entity definition. The primary key for > this table needs to be re-created or modified to add this column to > the primary key. Note that data may need to be added first as a > primary key column cannot have an null values. > 2006-11-17 10:56:11,296 (main) [ DatabaseUtil.java:293:ERROR] > WARNING: Column [AGREEMENT_ID] of table [OFBIZ.AGREEMENT_ITEM] of > entity [AgreementItem] IS NOT a primary key in the database, but IS > a primary key in the entity definition. The primary key for this > table needs to be re-created or modified to add this column to the > primary key. Note that data may need to be added first as a primary > key column cannot have an null values. > > ----- Original Message ----- From: "Jacopo Cappellato" <[hidden email]> > To: <[hidden email]> > Sent: Friday, November 17, 2006 3:17 AM > Subject: Re: Timestamp & Oracle > > >> yh-maurizio wrote: >>> Ok, it works fine! >>> >> >> Great! >> >>> Thank you Jacopo. >>> >>> P.S.: Jacopo are you Italian too? >> >> Già... vivo a Padova; piacere di conoscerti :-) >> > > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |