jboss 5.0 data source configuration in ear file. How can I run oracle 10g and 11g on the same serve

Posted by Joe on Stack Overflow See other posts from Stack Overflow or by Joe
Published on 2010-04-30T19:36:31Z Indexed on 2010/04/30 19:37 UTC
Read the original article Hit count: 694

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?

© Stack Overflow or respective owner

Related posts about jboss5.x

Related posts about datasource