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?