Specifying an Oracle database schema for CMP beans

[shanika]

Hi, I'm sort of new to EJBs. I am working with CMP beans that uses JBOSS 4.0 as the application server and Oracle8i as the database. I am able to create and deploy a simple CMP bean that creates a table in the Oracle databse. In my Oracle-ds.xml i have given the database configuration including the user /password.
My problem is that when the bean gets deployed, by default the table gets created in a schema named the same as the user name specified in my Oracle-ds.xml.
How can I get my tables created in a different schema in the Oracle db other than in the "username" schema? Please help.

thanks in advance
wkst

[adrian.brock]

You can set the schmea using an sql statement as each connection is created.
There is no support for per bean configuration.

In your oracle-ds.xml

<new-connection-sql>set schema whatever</new-connection-sql>

Regards,
Adrian

[jimbrady]

For ORACLE 8 this is now:
ALTER SESSION SET CURRENT_SCHEMA = whatever

Note: NO QUOTES