HI,
I get this error when I try to switch to oracle
Chand
[java] 3781 [ GenericDelegator.java:140:INFO ] Creating new Delegator
with name "default".
[java] 3968 [ GenericDelegator.java:124:ERROR] Error creating
delegator
[java] org.ofbiz.entity.GenericEntityConfException: Could not find a
delegator with the name
ault
[java] at
org.ofbiz.entity.model.ModelReader.getModelReader(ModelReader.java:85)
[java] at
org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:144)
[java] at
org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:12
[java] at
org.ofbiz.service.rmi.RmiServiceContainer.start(RmiServiceContainer.java:100)
[java] at
org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:12
[java] at
org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:71)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:178)
[java] at org.ofbiz.base.start.Start.start(Start.java:227)
[java] at org.ofbiz.base.start.Start.main(Start.java:287)
[java] 4031 [ ServiceDispatcher.java:74 :INFO ] [ServiceDispatcher] :
Creating new instance
[java] 4093 [ ServiceGroupReader.java:105:INFO ] Loaded 1 Group
definitions from file:/C:/do
ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/common/servicedef/groups_test.xml
[java] 4125 [ ServiceGroupReader.java:105:INFO ] Loaded 4 Group
definitions from file:/C:/do
ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/entityext/servicedef/groups.xml
[java] 4140 [ ServiceGroupReader.java:105:INFO ] Loaded 1 Group
definitions from file:/C:/do
ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/groups_shipment.xml
[java] 4140 [ ServiceGroupReader.java:105:INFO ] Loaded 4 Group
definitions from file:/C:/do
ad/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/accounting/servicedef/groups.xml
[java] 4187 [ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA
definitions from file:
download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/common/servicedef/secas_test.xml
[java] 4265 [ ServiceEcaUtil.java:139:INFO ] Loaded 1 Service ECA
definitions from file:
download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/content/servicedef/secas.xml
[java] 4281 [ ServiceEcaUtil.java:139:INFO ] Loaded 9 Service ECA
definitions from file:
download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/party/servicedef/secas.xml
[java] 4296 [ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA
definitions from file:
download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/workeffort/servicedef/secas.xml
[java] 4343 [ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA
definitions from file
/download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/secas.xml
[java] 4437 [ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA
definitions from file
/download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/product/servicedef/secas_shipment.xml
[java] 4468 [ ServiceEcaUtil.java:139:INFO ] Loaded 11 Service ECA
definitions from file
/download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/accounting/servicedef/secas.xml
[java] 4515 [ ServiceEcaUtil.java:139:INFO ] Loaded 28 Service ECA
definitions from file
/download/MobilePayment/ofbiz/ofbiz-3.0.0/ofbiz/components/order/servicedef/secas.xml
[java] java.lang.NullPointerException
[java] at
org.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:193)
[java] at org.ofbiz.service.job.JobPoller.<init>(JobPoller.java:69)
[java] at
org.ofbiz.service.job.JobManager.<init>(JobManager.java:77)
[java] at
org.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:88)
[java] at
org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:123)
[java] at
org.ofbiz.service.GenericDispatcher.init(GenericDispatcher.java:81)
[java] at
org.ofbiz.service.GenericDispatcher.<init>(GenericDispatcher.java:58)
[java] at
org.ofbiz.service.GenericDispatcher.<init>(GenericDispatcher.java:46)
[java] at
org.ofbiz.service.rmi.RmiServiceContainer.start(RmiServiceContainer.java:103)
[java] at
org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:12
[java] at
org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:71)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:178)
[java] at org.ofbiz.base.start.Start.start(Start.java:227)
[java] at org.ofbiz.base.start.Start.main(Start.java:287)
[java] Java Result: 99
----- Original Message -----
From: "Jacopo Cappellato" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, November 17, 2006 2:46 AM
Subject: Re: Timestamp & Oracle
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.
