You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Albert Xaubet (JIRA)" <ji...@apache.org> on 2006/11/10 10:53:37 UTC

[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

        

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

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
    [ 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

        

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

Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
    [ 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)

> 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

        

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

Posted by "David E. Jones (JIRA)" <ji...@apache.org>.
    [ 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.

> 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

        

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

Posted by "Albert Xaubet (JIRA)" <ji...@apache.org>.
    [ 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?

> 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