commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Phil Steitz (JIRA)" <>
Subject [jira] Commented: (DBCP-259) defualtReadOnly not working in conncetion pooling
Date Sat, 02 Feb 2008 05:23:07 GMT


Phil Steitz commented on DBCP-259:

Your understanding may not be correct, depending on the JDBC driver and database.  PoolableConnectionFactory
will invoke the underlying Connection's setReadOnly(true) method when a PoolableConnection
with defaultReadOnly = true is activated.  What that means in practice regarding what can
be done with the connection, what is optimized, etc. depends on the driver.  The driver documentation
should say whether or not and how readOnly connections are supported.

> defualtReadOnly not working in conncetion pooling
> -------------------------------------------------
>                 Key: DBCP-259
>                 URL:
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>         Environment: commons-pool 1.2, jdk 1.4
>            Reporter: Raghu
> Hi All
> I am trying to set up a connection pooling using Jakarta commons-dbcp 1.2.1....
> When defaultReadOnly property is set to true and if my understanding is correct i would
not be able to perform update,insert or delete operations.
> When i set defualtReadOnly as true in the constructor PoolableConnectionFactory which
looks like -
> poolableConnectionFactory = new PoolableConnectionFactory(
>                     connectionFactory, connectionPool, null,
>                     "sql query", true, true);
> But still i am able to perform the delete or insert opertations where i am expecting
to throw an excpetion.
> Am i missing some thing or is ther anything fishy???
> Thanks

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

View raw message