Commons Dbcp
  1. Commons Dbcp
  2. DBCP-11

[dbcp] stmt.getConnection() != Connection used to create the statement

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.2
    • Fix Version/s: 1.3
    • Labels:
      None
    • Environment:

      Operating System: other
      Platform: All

      Description

      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.

      1. back-pointers.patch
        21 kB
        Dain Sundstrom

        Activity

        Henri Yandell made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Phil Steitz made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Dain Sundstrom made changes -
        Attachment back-pointers.patch [ 12362088 ]
        Phil Steitz made changes -
        Bugzilla Id 36077
        Fix Version/s 1.2.2 [ 12311976 ]
        Fix Version/s 1.3 [ 12311977 ]
        Phil Steitz made changes -
        Fix Version/s 1.2.2 [ 12311976 ]
        Bugzilla Id 36077
        Henri Yandell made changes -
        Affects Version/s 1.2 Final [ 12311721 ]
        Henri Yandell made changes -
        Component/s Dbcp [ 12311109 ]
        Key COM-2298 DBCP-11
        Assignee Jakarta Commons Developers Mailing List [ commons-dev@jakarta.apache.org ]
        Project Commons [ 12310458 ] Commons Dbcp [ 12310469 ]
        Affects Version/s 1.2 Final [ 12311661 ]
        Henri Yandell made changes -
        Field Original Value New Value
        issue.field.bugzillaimportkey 36077 12342450
        Alexander Rupsch created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Alexander Rupsch
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development