commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dain Sundstrom (JIRA)" <>
Subject [jira] Updated: (DBCP-11) [dbcp] stmt.getConnection() != Connection used to create the statement
Date Wed, 18 Jul 2007 19:29:04 GMT


Dain Sundstrom updated DBCP-11:

    Attachment: back-pointers.patch

This patch assures that all all returned Statements, PreparedStatements, CallableStatements
and ResultSets are wrapped with a delegating object, which already properly handle the back
pointers for Connection and Statement.  This patch includes an extensive test to assure that
the *same* object used to create the statement or result set is returned from either the getConnection()
or getStatementMethod().  

> [dbcp] stmt.getConnection() != Connection used to create the statement
> ----------------------------------------------------------------------
>                 Key: DBCP-11
>                 URL:
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 1.2
>         Environment: Operating System: other
> Platform: All
>            Reporter: Alexander Rupsch
>             Fix For: 1.3
>         Attachments: back-pointers.patch
> Hi,
> I'm not an expert in implementing connection pools or jdbc itself. But shouldn't
> the following code work?
> Connection con = pool.getConnection()
> PreparedStatement ps = con.prepareStatement()
> con.equals(ps.getConnection) // returns false!
> Ok, I don't need it to be equal, but the following also does not work:
> ps.getConnection().close()
> con.isClosed() // is false!!!
> That means, if I have a Statment and want to close its connection, I have to
> remember the conncetion. Is that the requested behavior? Because of this my pool
> is running over.
> The java.sql API says that Statment.getConnection() has to be the connection
> which created the statement.

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

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message