Problem connecting two separate Ofbiz instances to a common Oracle DB

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem connecting two separate Ofbiz instances to a common Oracle DB

micman.manoj
I have installed Ofbiz in two local pcs. So long I have been accessing the embedded Derby databases in the respective OfBiz bundles. Now, I tried to connect to a common Oracle production database.  I made the changes in entityengine.xml file, then ran "build".  First, I did these operations from pc1 and the changes were successful. All the application tables and user defined entity tables were created successfully. However, when I tried to do the same from pc2 I ended up with many errors during the "build" phase.

     [java] Error was: java.sql.SQLException: ORA-00955: name is already used by
 an existing object


Probably, the access to the common database from pc2 tried to create all the application tables again and had bumped into this error.
One solution to this problem could be to drop the existing tables and try the build from pc2, but this is not a recommended solution. then how do I connect to the common Oracle DB?
or how do I populate seed data to existing oracle tables without encountering the above said error, which throws up for all the ofbiz tables in the bundle?
Reply | Threaded
Open this post in threaded view
|

Re: Problem connecting two separate Ofbiz instances to a common Oracle DB

micman.manoj
Problem Update:

The problem also throws up the same error if i try to re-run ofbiz in pc1.
Reply | Threaded
Open this post in threaded view
|

Re: Problem connecting two separate Ofbiz instances to a common Oracle DB

Mansour
In reply to this post by micman.manoj
I don't know a lot about Oracle, but a quick search, gave me this:
http://www.dbforums.com/oracle/1631298-java-sql-sqlexception-ora-00955-name-already-used-existing-object.html

Not sure if this is the case.


On Mon, Mar 26, 2012 at 6:04 AM, micman.manoj <[hidden email]> wrote:

> I have installed Ofbiz in two local pcs. So long I have been accessing the
> embedded Derby databases in the respective OfBiz bundles. Now, I tried to
> connect to a common Oracle production database.  I made the changes in/
> entityengine.xml /file, then ran "build".  First, I did these operations
> from pc1 and the changes were successful. All the application tables and
> user defined entity tables were created successfully. However, when I tried
> to do the same from pc2 I ended up with many errors during the "build"
> phase.
>
>    / [java] Error was: java.sql.SQLException: ORA-00955: name is already
> used by
>  an existing object/
>
> Probably, the access to the common database from pc2 tried to create all the
> application tables again and had bumped into this error.
> One solution to this problem could be to drop the existing tables and try
> the build from pc2, but this is not a recommended solution. then how do I
> connect to the common Oracle DB?
> or how do I populate seed data to existing oracle tables without
> encountering the above said error, which throws up for all the ofbiz tables
> in the bundle?
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-connecting-two-separate-Ofbiz-instances-to-a-common-Oracle-DB-tp4505305p4505305.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Reply | Threaded
Open this post in threaded view
|

Re: Problem connecting two separate Ofbiz instances to a common Oracle DB

micman.manoj
Thank You!
I have just found out that we can ignore these "errors" which throw up.
After getting exhausted complaining about all such errors, OFbiz proceeds with the rest of the job.