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>