Re: Timestamp & Oracle

Fri, 17 Nov 2006 02:47:29 -0800 

ant run-install

Chandresh Turakhia wrote:

Dear all & Maurizo,

Do we need a script to create Oracle tables for ofbiz.

I saw some script for HSQL.

Nice if someone can share Oracle table creation script

Chand
----- Original Message ----- From: "yh-maurizio" <    >
To: <[email protected]>
Sent: Friday, November 17, 2006 2:01 AM
Subject: Timestamp & Oracle




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.

Reply via email to