0 Replies Latest reply on Mar 19, 2003 6:25 PM by Cameron Taggart

    No Transactions Datasource - JBoss 3.2 RC3

    Cameron Taggart Newbie

      Do you get better performance out of a database connection if transactions aren't enabled? If yes, how do I create a datasource without local transaction support. Here is my presidents-jdbc-ds.xml file. It works, but is there a way to do it without transaction support?


      <?xml version="1.0" encoding="UTF-8"?>

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->


      <local-tx-datasource>
      jboss:service=Hypersonic
      <jndi-name>jdbc/Presidents</jndi-name>
      <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
      <driver-class>org.hsqldb.jdbcDriver</driver-class>
      <connection-property name="user">sa</connection-property>
      <connection-property name="password"></connection-property>
      <min-pool-size>5</min-pool-size>
      </local-tx-datasource>


      1701
      true
      default
      false
      true