You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Thomas Fischer <fi...@seitenbau.net> on 2005/11/08 11:09:25 UTC

[dbcp] Status of Bug 35591




Hi,

I just wondered what the status of the following bug is:

http://issues.apache.org/bugzilla/show_bug.cgi?id=35591

Basically this bug prevents one to create serializable connections with
connection checking and without auto commit for any oracle database. The
problem is that setting the transaction isolation after the validation
query does not work for oracle because the transaction isolation has to be
set before any query is issued to the database.

I believe I have analyzed the problem correctly; there is a testcase which
shows the problem, I believe I have provided a reasonable patch, but I did
never hear anything about it; at least there are no comments or anything
added in bugzilla.

The problem has appeared at the db-torque project
(http://db.apache.org/torque/) and it would be nice to know whether the
problem will be solved.

If you disagree with the solution or there is a problem with the provided
patch, please let me know. If another solution is preferred I'd volunteer
to implement it; just give some hint about the direction to go.

I appreciate that the problem is quite complex and the solution digs deep
into the internals of dbcp, so it is clear that it takes some time looking
at it. I just wanted to brush the dust off it.

    Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org