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