0 Replies Latest reply on May 5, 2004 10:14 AM by pjrichter

    Database connection without pooling

    pjrichter Newbie

      How can I set up a datasource that does not use connection pooling/ I want it to establish a new connection to the sql2000 db on demand and release it when I'm done. I've attached my *-db.xml data.

      <?xml version="1.0" encoding="UTF-8"?>
      
      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->
      
      <datasources>
       <local-tx-datasource>
       <jndi-name>OracleDS</jndi-name>
       <connection-url>jdbc:oracle:thin:@10.128.0.44:1521:DV01</connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>eis_emery</user-name>
       <password>emery</password>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       </local-tx-datasource>
      
       <local-tx-datasource>
       <jndi-name>FascorDS</jndi-name>
       <connection-url>jdbc:jtds:sqlserver://10.128.0.20:1433/DC02EWH</connection-url>
       <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
       <user-name>dc02ewh</user-name>
       <password>dc02ewh</password>
       </local-tx-datasource>
      
      </datasources>