0 Replies Latest reply on Jun 8, 2004 5:30 AM by Jon

    config more than one datasource in jboss 3.2.X ?

    Jon Newbie

      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