Dev - Problems with TIMESTAMP data type

[Madhusudhana Kondragunta]

Any one found a solution for this?

http://lists.ofbiz.org/pipermail/dev/2005-August/009073.html

I'm using an Oracle database and all the tables were successfully created.

The problem is that when I run startofbiz, I get the following.  The problem

is in the WHERE clause:  WHERE((RUN_TIIME <= '2500-08-20 19:34:52.0'   In

oracle, the timestamp uses the following format:  01-JAN-00 12.00.00.000000

AM.  What is the suggested way to get OFBIZ and Oracle to cooperate with

Timestamps?

313031[ BeanShellContainer.java:110:INFO ] NOTICE: BeanShell service ports

are not secure. Please protect the ports

323141[   GenericDelegator.java:1010: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 OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ?

WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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 OFBIZ.JOB_SANDBOX SET

RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2005-08-20

19:34:52.0' 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 OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ?

WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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:315

)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD

AO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:100

7)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982

)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing

the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID

= ? WHERE ((RUN_TIME <= '2005-08-20 19:34:52.0' 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:438)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357

)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312

)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD

AO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:100

7)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982

)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

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:573)

oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)

oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)

oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047

)

oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java

:2709)

oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState

ment.java:589)

org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedSt

atementInPool.java:82)

org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357

)

org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312

)

org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperD

AO.java:231)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:100

7)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982

)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

----------------------------------------------------------------------------

----

323141[    TransactionUtil.java:281:WARN ] 

---- exception report

----------------------------------------------------------

[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this

stack trace shows where this is happening:

Exception: java.lang.Exception

Message: null

---- stack trace

---------------------------------------------------------------

java.lang.Exception

org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil

.java:281)

org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2

31)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:101

3)

org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:982

)

org.ofbiz.service.job.JobManager.poll(JobManager.java:152)

org.ofbiz.service.job.JobPoller.run(JobPoller.java:96)

java.lang.Thread.run(Thread.java:534)

----------------------------------------------------------------------------

----

323141[         JobManager.java:158:ERROR]

 

============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.


Disclaimer:


The contents of this E-mail (including the contents of the enclosure(s) or attachment(s) if any) are privileged and confidential material of Tech Mahindra and should not be disclosed to, used by or copied in any manner by anyone other than the intended addressee(s). In case you are not the desired addressee, you should delete this message and/or re-direct it to the sender. The views expressed in this E-mail message (including the enclosure(s) or attachment(s) if any) are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Tech Mahindra.


This e-mail message including attachment/(s), if any, is believed to be free of any virus. However, it is the responsibility of the recipient to ensure that it is virus free and Tech Mahindra is not responsible for any loss or damage arising in any way from its use.

============================================================================================================================

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev