You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2004/12/23 09:37:46 UTC
DO NOT REPLY [Bug 32825] New: -
Setting the defaultAutoCommit property to false breaks the MySQL DataSource
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=32825>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=32825
Summary: Setting the defaultAutoCommit property to false breaks
the MySQL DataSource
Product: Commons
Version: 1.2 Final
Platform: PC
OS/Version: Windows 2000
Status: NEW
Severity: normal
Priority: P3
Component: Dbcp
AssignedTo: commons-dev@jakarta.apache.org
ReportedBy: jvdsandt@xs4all.nl
I'm using the following datasource definition in Spring:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"><value>${jdbc.driverClassName}</value></property>
<property name="url"><value>${jdbc.url}</value></property>
<property name="username"><value>${jdbc.username}</value></property>
<property name="password"><value>${jdbc.password}</value></property>
<property name="maxActive"><value>8</value></property>
<property name="maxIdle"><value>2</value></property>
<property name="maxWait"><value>4000</value></property>
<property name="defaultAutoCommit"><value>false</value></property>
<property name="defaultTransactionIsolation"><value>2</value></property>
</bean>
When I comment out the "defaultAutoCommit" everything works fine. But when the
property is included a number of queries don't work. They don't return an error,
they just don't modify the database as they should.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org