AutoCommit
lundorff May 20, 2002 12:37 PMI am using JBoss 3.0 RC2 with an Oracle database.
I have a problem with the pooling of connections for local transactions.
Basically, if I get a connection from the pool do a connection.setAutoCommit(false) on it, this does not get reset when returned to the pool. I assumed that the connection pool was responsible for restoring the original state of the connections, so it becomes transparent for the user, that the connections are recycled. Is that an incorrect assumption, or could there be a problem with org.jboss.resource.connectionmanager.LocalTxConnectionManager?
I have included the configuration of the connection manager below.
Any advice would be appreciated.
Cheers, Kim
<?xml version="1.0" encoding="UTF-8"?>
OracleDbRealm
<depends optional-attribute-name="ManagedConnectionFactoryName">
ExcediaDB
<!-- <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@127.0.0.1:1521:kajej</config-property> -->
<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:oci8:@(description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=wiggum)))</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<depends optional-attribute-name="ManagedConnectionPool">
10
60
5000
15
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager
java:/TransactionManager
jboss.jca:service=RARDeployer
OracleDbNTRealm
<depends optional-attribute-name="ManagedConnectionFactoryName">
ExcediaDBNT
<!-- <config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:thin:@127.0.0.1:1521:wiggum</config-property> -->
<config-property name="ConnectionURL" type="java.lang.String">jdbc:oracle:oci8:@(description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=wiggum)))</config-property>
<config-property name="DriverClass" type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<depends optional-attribute-name="ManagedConnectionPool">
10
60
5000
15
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager
java:/TransactionManager
jboss.jca:service=RARDeployer