aspose file tools*
The moose likes Tomcat and the fly likes How to set autocommit to false at tomcat connection-pool? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "How to set autocommit to false at tomcat connection-pool?" Watch "How to set autocommit to false at tomcat connection-pool?" New topic
Author

How to set autocommit to false at tomcat connection-pool?

starki fox
Greenhorn

Joined: Jul 20, 2005
Posts: 15
Hi, my example works but I cannot set the
autocommit parameter to false, but this is quite important to me.
(i don't want to set it to false at the connection-object)
Can someone give me advice how to handle this?

Thanks Starki



<ResourceParams name="jdbc/test">
<parameter>
<name>validationQuery</name>
<value>select * from dual</value>
</parameter>

<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>xtest</value>

</parameter>
<parameter>
<name>url</name>
<value>jdbc racle:thin:@xinfosap.w1:1521 rcl;autocommit=false</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>

<parameter>
<name>auto-commit</name>
<value>false</value>
</parameter>
<parameter>
<name>autoCommit</name>
<value>false</value>
</parameter>
<parameter>
<name>autocommit</name>
<value>false</value>
</parameter>
<parameter>
<name>maxIdle</name>

<value>2</value>
</parameter>

<parameter>
<name>username</name>
<value>xtest</value>
</parameter>


</ResourceParams>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to set autocommit to false at tomcat connection-pool?
 
Similar Threads
Configuration multiple resource DB.
War Deployment Problem in Tomcat
HELP! DBCP configuraiton for Tomcat 5
Configuring Tomcat's Resource Factory...
DBCP could not obtain an idle db connection