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> View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3833771#3833771 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3833771 ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
