Hey guys, I am running JBoss 4.0.3SP1 utilizing a poorly clustered Oracle database. I have run into a problem where the user that logs into the database must use a different database schema than the default one. How can I specify what database schema to use?
By default, if I use the user: db_username to login to the database, the schema it uses is DB_USERNAME. I am however obliged to use the schema DB_ANOTHERUSER for one specific web application. I must however, log in as db_username to perform this duty. Below is my oracle-ds.xml which works, but does not specify the database schema to use, which of course causes all sorts of errors because the database schema in use, is not the correct one. | <?xml version="1.0" encoding="UTF-8"?> | | <datasources> | <local-tx-datasource> | <jndi-name>OracleDS</jndi-name> | <connection-url>jdbc:oracle:thin:@db4:1521:DB01</connection-url> | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <user-name>db_username</user-name> | <password>db_password</password> | | <!-- Checks the Oracle error codes and messages for fatal errors --> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | | <metadata> | <type-mapping>Oracle8</type-mapping> | </metadata> | </local-tx-datasource> | | </datasources> | Any ideas? Thanks! Joshua Preston. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3929853#3929853 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3929853 ------------------------------------------------------- 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
