[JBoss-user] [JCA/JBoss] - Re: Specifying an Oracle database schema for CMP beans

2004-04-21 Thread jimbrady
For ORACLE 8 this is now:
   ALTER SESSION SET CURRENT_SCHEMA = whatever

Note: NO QUOTES

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831720#3831720

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831720


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: Specifying an Oracle database schema for CMP beans

2004-04-14 Thread [EMAIL PROTECTED]
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

  | set schema whatever
  | 

Regards,
Adrian

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830607#3830607

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830607


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user