Hi,
I know how config one datasource changing the DefaultsDS for one of my DataSource and my aplication run OK. But I need to configure more than one datasource because in my oracle I have two schemas.
I have a Servlet aplication, then I use Tomcat over jboss
my jboss-web.xml is
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/OracleLimsDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<jndi-name>java:jdbc/OracleLimsDS</jndi-name>
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/OracleStatsDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<jndi-name>java:/OracleStatsDS</jndi-name>
</resource-ref>
</jboss-web>
and my web.xml have the resource-ref too.
I put into de server/default/deploy two files OracleStats-ds.xml and OracleLims-ds.xml with the datasource configuration
<local-tx-datasource>
<jndi-name>jdbc/OracleLimsDS</jndi-name>
<connection-url>jdbc:oracle:thin:@my_server:1521:OR01</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>my_user</user-name>
< password>my_pass< /password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
but the aplication view tha java class LinkRef but not DataSource and I can't connect
¿other configuration in standardjaws.xml or standardjbosscmp-jdbc.xml or login-config.xml without modify DefaultDS?
thanks
Jon