jboss 5.0 data source configuration in ear file. How can I run oracle 10g and 11g on the same serve
- by Joe
Currently my setup is:
in my ear META-INF/jboss-app.xml
    <jboss-app>
    <service>datasource-ds.xml</service>
    </module>
and datasource-ds.xml
    <datasources>
      <local-tx-datasource>
        <jndi-name>jdbc/mydeployment</jndi-name>
        <connection-url>jdbc:oracle:thin:@eir:myport:mydbname</connection-url>
            <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>myuser</user-name>
        <password>mypassword</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
           <metadata>
             <type-mapping>Oracle9i</type-mapping>
          </metadata>
      </local-tx-datasource>
    </datasources>
and it works when ojdbc5.jar is in my servername/lib
How can I config my oracle driver information in my .ear file so that I can have two different ear deployments, one using oracle 10g and one using oracle 11g?