OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-445) Oracle 10g entity creation problem

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-445) Oracle 10g entity creation problem

Oracle 10g entity creation problem
----------------------------------

Key: OFBIZ-445
URL: http://issues.apache.org/jira/browse/OFBIZ-445
Project: OFBiz (The Open for Business Project)
Issue Type: Bug
Components: framework
Environment: Linux. FC4 oracle 10g Express Edition
Reporter: Albert Xaubet
Priority: Minor

OFBiz doesn't detects that the database entities are already created and tries to create them again araising a big amount of SQLExceptions that aren't critical but very annoying.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-445) Oracle 10g entity creation problem

[ http://issues.apache.org/jira/browse/OFBIZ-445?page=comments#action_12448694 ]

Jacques Le Roux commented on OFBIZ-445:
---------------------------------------

(very) Short answer : did you check the JDBC driver ?

> Oracle 10g entity creation problem
> ----------------------------------
>
> Key: OFBIZ-445
> URL: http://issues.apache.org/jira/browse/OFBIZ-445
> Project: OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: framework
> Environment: Linux. FC4 oracle 10g Express Edition
> Reporter: Albert Xaubet
> Priority: Minor
>
> OFBiz doesn't detects that the database entities are already created and tries to create them again araising a big amount of SQLExceptions that aren't critical but very annoying.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-445) Oracle 10g entity creation problem

In reply to this post by Nicolas Malin (Jira)

[ http://issues.apache.org/jira/browse/OFBIZ-445?page=comments#action_12448710 ]

Albert Xaubet commented on OFBIZ-445:
-------------------------------------

Yes i'm using the Oracle Database 10g Release 2 (10.2.0.2) JDBC Driver that's the one that matches with the Oracle Express Edition that i'm using.

Did you had the same problem?

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-445) Oracle 10g entity creation problem

In reply to this post by Nicolas Malin (Jira)

[ http://issues.apache.org/jira/browse/OFBIZ-445?page=comments#action_12448716 ]

Jacques Le Roux commented on OFBIZ-445:
---------------------------------------

No, was just a quick check (there are often problems with JDBC drivers)

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-445) Oracle 10g entity creation problem

In reply to this post by Nicolas Malin (Jira)

[ http://issues.apache.org/jira/browse/OFBIZ-445?page=comments#action_12448934 ]

David E. Jones commented on OFBIZ-445:
--------------------------------------

My first guess would be the same as the one from Jacques. This sort of thing is usually a problem with the JDBC driver where it doesn't support getting certain meta data for the entire database, but instead only supporting getting it for one table or other higher level element at a time. It's hard to say without playing around with it though...

Sometimes there is an error right at the beginning that will give you a hint about what is happening, ie right before it tries to create all of the tables again.

Also note that you can turn off the add missing stuff in the datasource element in the entityengine.xml file. I've heard of various people doing this because of this problem instead of trying to fix it (a shame though...), and actually in production it's a very good idea.