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 ([EMAIL PROTECTED]) [ 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.
