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>
