Using Oracle with JBoss

[balanscott]

I understand that we need to modify/create a -db.xml file for Oracle so we can use it. However, I cannot locate any information as to naming conventions (if required). Does anyone have a sample file to share that currently works?

Thanks.

[darranl]

Examples can be found in '{jboss.home}\docs\examples\jca'

The getting started guide (Available from the Documentation link) also describes configuring additional datasources .

[hernant]

here you have an example of oracle-ds.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<!--JBoss Server Configuration-->
<!--$Id: oracle-ds.xml,v 1.1.2.2 2003/04/01 04:51:12 d_jencks Exp $-->
<!--Datasource config for Oracle originally from Steven Coy-->


<local-tx-datasource>
<jndi-name>OracleDS2</jndi-name>
<connection-url>jdbc:oracle:thin:@SERVER1:1521:DB1</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>USERNAME</user-name>
PASSWORD
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>



you can add more local-tx-datasource(s).

Hope this helps.

Hernan Terzian

[hernant]

Don't know what happened with the password...

the password goes within < password > tag

Hernan.

[balanscott]

Thanks to everyone. It appears based on the responses we have it running. Now we can design some code and test (at least now I see the entries I specified.)