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

    Datasource Issue for Java Web Application

    himurashiori

      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.