Ok I got the trigger given on that site working too. Just replace 'ofbiz' in the 'if' condn with 'OFBIZ' and it works. Seems Oracle converts it to uppercase.
jaki wrote: > > Thanks a lot for all the help and suggestions. I got that trigger to work > by removing the lines making the check for username. Don't know why it > doesn't work with those lines included but I'll make a post as soon as I > find out > > > BJ Freeman wrote: >> >> 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) >>>>> >>>> >>> >> >> >> > > -- View this message in context: http://www.nabble.com/Getting-SQL-Exceptions-during-ant-run-tp17033489p17224305.html Sent from the OFBiz - User mailing list archive at Nabble.com.
