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.
