Nevermind, As a side note, I have smacked myself and yelled: RTFM, or at least, RTFFYI. Anyhow, if anyone else gets stuck doing this, I've figured out that you can specify SQL statements to be run upon valid connection. Therefore, modifying my orace-ds.xml by looking at the WIKI where it states:
anonymous wrote : | <new-connection-sql> - an sql statement that is executed against each new connection. This can be used to set the connection schema, etc. | I've added a line to my oracle-dx.xml that looks like: | <new-connection-sql>ALTER SESSION SET current_schema=DB_ANOTHERUSER</new-connection-sql> | I will not say this is the most elegant way nor it is the proper way, but it does work for me :-D Anyhow, maybe it will help someone down the road! Thanks! Joshua Preston. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3929874#3929874 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3929874 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
