[OFBiz] Dev - Problems with TIMESTAMP data type

[Michael Irving]

I’m using an Oracle database and all the tables were successfully created.  The problem is that when I run startofbiz, I get the following.  The problem is in the WHERE clause:  WHERE((RUN_TIIME <= ‘2500-08-20 19:34:52.0’   In oracle, the timestamp uses the following format:  01-JAN-00 12.00.00.000000 AM.  What is the suggested way to get OFBIZ and Oracle to cooperate with Timestamps?

 

 

 

 

 

 

313031[ BeanShellContainer.java:110:INFO ] NOTICE: BeanShell service ports are not secure. Please protect the ports

323141[   GenericDelegator.java:1010: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 OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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 OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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 OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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:315)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1007)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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:438)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1007)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

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:573)

oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)

oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)

oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)

oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)

oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)

org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)

org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1007)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

--------------------------------------------------------------------------------

 

323141[    TransactionUtil.java:281:WARN ]

---- exception report ----------------------------------------------------------

[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening:

Exception: java.lang.Exception

Message: null

---- stack trace ---------------------------------------------------------------

java.lang.Exception

org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:281)

org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1013)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

--------------------------------------------------------------------------------

 

323141[         JobManager.java:158:ERROR]

 

-----------------------------------------

Michael Irving

Keynetx, Inc. - Building Solutions for Success

Mobile: [phone]

Fax: [phone]

email: [hidden email]

 

* * * Visit Our Web Site: http://www.keynetx.net * * *

 

--------------------------------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.

 

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev