4 Replies Latest reply on Sep 15, 2004 12:39 AM by balanscott

    Using Oracle with JBoss

    balanscott Newbie

      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.

        • 1. Re: Using Oracle with JBoss
          Darran Lofthouse Master

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

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

          • 2. Re: Using Oracle with JBoss
            Newbie

            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

            • 3. Re: Using Oracle with JBoss
              Newbie

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

              the password goes within < password > tag

              Hernan.

              • 4. Re: Using Oracle with JBoss
                balanscott Newbie

                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.)