You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by David E Jones <jo...@hotwaxmedia.com> on 2008/01/08 22:21:48 UTC
Re: Odd Error
The database you are using may not be schema-aware, but allows a "."
in the table name.
In the entityengine.xml file try turning off the schema (don't specify
a schema name in the datasource element).
You may have to rebuild the database when you do this.
Which database are you using, BTW? It may be that someone on the list
has some experience with it...
-David
On Jan 8, 2008, at 2:22 PM, Skip wrote:
> I have left the normal Ofbiz realm for a time and am attempting to
> use the
> framework for a mainframe project prototype. In doing so, I deleted
> all the
> applications except part of party. I have no errors in the build
> logs.
>
> However, when I attempt to log in, I get this exception:
>
> Exception in thread "default-invoker-Thread-9"
> java.lang.RuntimeException:
> Error
> while updating: [GenericEntity:RecurrenceInfo][createdStamp,2008-01-08
> 13:04:13
> .297(java.sql.Timestamp)][createdTxStamp,2008-01-08
> 13:04:13.296(java.sql.Timest
> amp)][exceptionDateTimes,null()][exceptionRuleId,null()]
> [lastUpdatedStamp,20
> 08-0
> 1-08 13:06:22.906(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-08
> 13:06:22.90
> 6(java.sql.Timestamp)][recurrenceCount,1(java.lang.Long)]
> [recurrenceDateTime
> s,nu
> ll()][recurrenceInfoId,270(java.lang.String)][recurrenceRuleId,
> 270(java.lang
> .Str
> ing)][startDateTime,2000-01-01 00:00:00.0(java.sql.Timestamp)] (SQL
> Exception wh
> ile executing the following:UPDATE OFBIZ.RECURRENCE_INFO SET
> START_DATE_TIME=?,
> EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
> RECURRENCE
> _RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
> LAST_UPDATED_TX_STAMP=?, C
> REATED_STAMP=?, CREATED_TX_STAMP=? WHERE RECURRENCE_INFO_ID=? (Schema
> 'OFBIZ' do
> es not exist))
> at
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.ja
> va:136)
>
> Note that it sez "Schema 'OFBIZ' does not exist"
>
> Here is a snipit from the ant run-install-seed log:
>
> DatabaseUtil.java:356:INFO ] Created table [OFBIZ.RECURRENCE_INFO]
>
> Anyone have a clue what this is?
>
>
> I am running Ofbiz as java -jar ofbiz.jar sc
>
> The "sc" is a specialpurpose application that is successfully
> connecting to
> a mainframe. I can see it coming up on a monitor application.
>
>
>
> Skip
>
RE: Odd Error
Posted by Skip <sk...@thedevers.org>.
This is using derby ootb and a two week old ofbiz with the framework
unmodified.
I am just now downloading postgres to see if I can figure it out better with
it.
Skip
-----Original Message-----
From: David E Jones [mailto:jonesde@hotwaxmedia.com]
Sent: Tuesday, January 08, 2008 1:22 PM
To: user@ofbiz.apache.org
Subject: Re: Odd Error
The database you are using may not be schema-aware, but allows a "."
in the table name.
In the entityengine.xml file try turning off the schema (don't specify
a schema name in the datasource element).
You may have to rebuild the database when you do this.
Which database are you using, BTW? It may be that someone on the list
has some experience with it...
-David
On Jan 8, 2008, at 2:22 PM, Skip wrote:
> I have left the normal Ofbiz realm for a time and am attempting to
> use the
> framework for a mainframe project prototype. In doing so, I deleted
> all the
> applications except part of party. I have no errors in the build
> logs.
>
> However, when I attempt to log in, I get this exception:
>
> Exception in thread "default-invoker-Thread-9"
> java.lang.RuntimeException:
> Error
> while updating: [GenericEntity:RecurrenceInfo][createdStamp,2008-01-08
> 13:04:13
> .297(java.sql.Timestamp)][createdTxStamp,2008-01-08
> 13:04:13.296(java.sql.Timest
> amp)][exceptionDateTimes,null()][exceptionRuleId,null()]
> [lastUpdatedStamp,20
> 08-0
> 1-08 13:06:22.906(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-08
> 13:06:22.90
> 6(java.sql.Timestamp)][recurrenceCount,1(java.lang.Long)]
> [recurrenceDateTime
> s,nu
> ll()][recurrenceInfoId,270(java.lang.String)][recurrenceRuleId,
> 270(java.lang
> .Str
> ing)][startDateTime,2000-01-01 00:00:00.0(java.sql.Timestamp)] (SQL
> Exception wh
> ile executing the following:UPDATE OFBIZ.RECURRENCE_INFO SET
> START_DATE_TIME=?,
> EXCEPTION_DATE_TIMES=?, RECURRENCE_DATE_TIMES=?, EXCEPTION_RULE_ID=?,
> RECURRENCE
> _RULE_ID=?, RECURRENCE_COUNT=?, LAST_UPDATED_STAMP=?,
> LAST_UPDATED_TX_STAMP=?, C
> REATED_STAMP=?, CREATED_TX_STAMP=? WHERE RECURRENCE_INFO_ID=? (Schema
> 'OFBIZ' do
> es not exist))
> at
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.ja
> va:136)
>
> Note that it sez "Schema 'OFBIZ' does not exist"
>
> Here is a snipit from the ant run-install-seed log:
>
> DatabaseUtil.java:356:INFO ] Created table [OFBIZ.RECURRENCE_INFO]
>
> Anyone have a clue what this is?
>
>
> I am running Ofbiz as java -jar ofbiz.jar sc
>
> The "sc" is a specialpurpose application that is successfully
> connecting to
> a mainframe. I can see it coming up on a monitor application.
>
>
>
> Skip
>