Configuring Oracle 11 G Datasource to use a default schema

[vhegde]

How can I configure the datasource in oracle-ds.xml to also include the database schema name?

If this is possible or not via DB URL or any other configuration?

I am using Spring JDBC which access the JBoss 5.0.1 AS configured DataSource to get DB Connection to connect and execute operations on DB.

Please not the user name is not the same as the schema name that we are using in our organisation. So I cant replace the user name with the schema name.

Please share this info if any have solution for this type of situation. Thank you very much in advance.

Regards'

Vikram

[peterj]

Cross posted here: http://www.coderanch.com/t/587652/JBoss/Configuring-Oracle-Datasource-default-schema

My advice is the same...