this is a Java, oracle problem. I suggest you take what was suggested and ask on the Oracle forum, for the speediest answer. the change from java timestamp to oracle is at the JDBC level, i believe. you might also check java forums on sun.
feel free, once you have solved the problem, to add to the page for future users. jaki sent the following on 5/4/2008 11:02 PM: > Tried the trigger given on that site but the problem persists. It comes up a > bit later now (after a 100 or so more lines in the log) but it still comes. > > > > Scott Gray wrote: >> This may help: >> http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle >> >> 2008/5/4 BJ Freeman <[EMAIL PROTECTED]>: >> >>> there was some discussion about a month ago. >>> it is an oracle specific problem. >>> I don't remember a specific solution on the ML since it has to with >>> oracle. >>> >>> >>> jaki sent the following on 5/3/2008 3:10 AM: >>>> hi, >>>> I got my database changed from derby to oracle 10g Enterprise Edition >>>> Release 10.1.0.2.0 with jdbc Oracle driver Version 9.2.0.1.0. The >>> 'ant.bat >>>> run-intall' got over successfully though whenever I start the server >>> using >>>> 'ant.bat run', I keep getting SQL Exceptions as below. And the ant run >>> just >>>> keeps on going without any end in sight (infact once when I redirected >>>> output to a txt file, it got as big as 400mb after which I manually >>> quit >>>> it!). But inspite of this the ecommerce, webtools and other apps which >>> come >>>> default with ofbiz seems to work fine. Kindly help >>>> >>>> Sample of the error log: >>>> >>>> [java] 2008-05-03 14:13:16,478 ([EMAIL PROTECTED]) >>> [ >>>> GenericDelegator.java:1103:ERROR] >>>> [java] ---- exception report >>>> ---------------------------------------------------------- >>>> [java] 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 <= '2008-05-03 14:13:16.415' 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 >>>> [java] )). Rolling back transaction. >>>> [java] Exception: org.ofbiz.entity.GenericDataSourceException >>>> [java] 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 <= '2008-05-03 >>>> 14:13:16.415' 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 >>>> [java] )) >>>> [java] ---- stack trace >>>> --------------------------------------------------------------- >>>> [java] 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 <= '2008-05-03 14:13:16.415' 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 >>>> [java] )) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) >>>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) >>>> [java] java.lang.Thread.run(Thread.java:595) >>>> [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception >>> while >>>> executing the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID >>> = ?, >>>> STATUS_ID = ? WHERE ((RUN_TIME <= '2008-05-03 14:13:16.415' 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 >>>> [java] ) >>>> [java] >>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:329) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) >>>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) >>>> [java] java.lang.Thread.run(Thread.java:595) >>>> [java] java.sql.SQLException: ORA-01843: not a valid month >>>> [java] >>> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) >>>> [java] oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) >>>> [java] oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) >>>> [java] >>> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) >>>> [java] >>>> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) >>>> [java] >>>> >>> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047) >>>> [java] >>>> >>> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) >>>> [java] >>>> >>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709) >>>> [java] >>>> >>> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) >>>> [java] >>>> >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >>>> [java] >>>> >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) >>>> [java] >>>> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:329) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) >>>> [java] >>>> >>> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) >>>> [java] >>>> >>> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) >>>> [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) >>>> [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) >>>> [java] java.lang.Thread.run(Thread.java:595) >>> >> >
