Bugs item #840536, was opened at 2003-11-12 09:09 Message generated for change (Comment added) made by loubyansky You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=840536&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open >Resolution: Accepted Priority: 5 Submitted By: Frank Langelage (lafr) >Assigned to: Alexey Loubyansky (loubyansky) Summary: Oracle 9iR2: same table in diff. schema Initial Comment: I recently switched my database from informix to oracle and encountered some problems. With informix, you have one instance and many separate databases. Each datasource connects to exactly one database. With oracle you have one instance and database objects per user. You connect to the whole instance. I use the feature of jboss to build database tables on deployment, if they don't exist. With oracle DB I got messages that some tables already exist. But this table exist for another user (schema), not for the jboss user. This leads to exceptions (Table does not exist) when an foreign key constraint to this supposedly existing table. Shouldn't jboss use the username of oracle-ds.xml as schema for metadata access ? If I set schema to "jboss" instead of null in SQLUtil.tableExists(), the deployment and table creation works fine. Index: jboss-3.2/server/src/main/org/jboss/ejb/plugins/cmp/jdbc/SQLUtil.java =================================================================== RCS file: /cvsroot/jboss/jboss/src/main/org/jboss/ejb/plugins/cmp/jdbc/SQLUtil.java,v retrieving revision 1.12.4.14 diff -r1.12.4.14 SQLUtil.java 907c907 < String schema = null; --- > String schema = "JBOSS"; So, I think, schema should get the name of the database user from oracle-ds.xml. Oracle-ds.xml is attached. ---------------------------------------------------------------------- >Comment By: Alexey Loubyansky (loubyansky) Date: 2003-11-12 13:24 Message: Logged In: YES user_id=543482 It should. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=840536&group_id=22866 ------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development