SourceForge Submitter: lafr .
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.