ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jaki <jackie_ja...@infosys.com>
Subject Re: Getting SQL Exceptions during ant run
Date Tue, 06 May 2008 04:14:24 GMT

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 <bjfree@free-man.net>:
>>>
>>>> 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
>>>>> (org.ofbiz.service.job.JobPoller@946d22)
>>>> [
>>>>> 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-tp17033489p17071567.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Mime
View raw message