commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Wyatt (JIRA)" <>
Subject [jira] Created: (DBCP-282) defaultReadOnly not honored in server.xml for PerUserPoolDataSource
Date Fri, 30 Jan 2009 14:44:00 GMT
defaultReadOnly not honored in server.xml for PerUserPoolDataSource

                 Key: DBCP-282
             Project: Commons Dbcp
          Issue Type: Bug
    Affects Versions: 1.2.2
         Environment: Tomcat 4.1.29/Apache-2.0.55/Oracle JDBC on RedHat ES3.0 on i386
            Reporter: Josh Wyatt

Running dbcp-1.2.2 on Apache-2.0.55/Tomcat-4.1.29/Jakarta on Linux, using JDBC to connect
to Oracle 10g DB.

We are seeing the constant SET TRANSACTION READ WRITE activity against the DB connection,
and although I appreciate the discussion about a new configuration option, I am not able to
figure out how to disable this activity.

Background on this issue can be found at:

For reference, assume that we do not have control over the codebase, although we have full
control over the server configuration (server.xml, etc).

I found the configuration options page for DBCP- but there appears to be no discussion on
the logistics/mechanics of how to set or change these configuration options.

Our connections are implemented as  type="org.apache.commons.dbcp.datasources.PerUserPoolDataSource"
in server.xml.  We have tried setting the parameter in the ResourceParams section for the
JDBC stanza, like this:

<ResourceParams name="jdbc/OURDBINSTANCENAME">

...with no success.

It should be noted that previous to discovering this issue, we did not have this parameter
set at all; so I'm not even sure if this is the proper location for this configuration directive.
 I could not find any guidance in the DBCP documentation on where to put this stuff.

Please advise,

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message