0 Replies Latest reply on Jan 9, 2006 5:27 AM by hai huang

    Datasource Issue for Java Web Application

    hai huang Newbie

      I need run two application in JBOSS server so that I just config two datasource in oracle-ds.xml as following:


      <local-tx-datasource>
      <jndi-name>StartDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@3.333.333.33:1521:aaaaaa</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>111111</user-name>
      111111
      <min-pool-size>2</min-pool-size>
      <max-pool-size>32</max-pool-size>

      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>

      <local-tx-datasource>
      <jndi-name>StatmayDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@4.444.444.44:1521:bbbbbb</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>222222</user-name>
      222222
      <min-pool-size>2</min-pool-size>
      <max-pool-size>32</max-pool-size>

      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </local-tx-datasource>





      the problem is that when I startup my JBOSS server, it can only recognize the StartDS which means only one application can work and another one met errors. The secord application take the same database connection as the first one. That's really confusing since I can run these two application in my local environment and when I upload to server , it met such problems. Please give your comments and thanks a lot.