Re: return connection after OraclOCIConnectionPool.getProxyConnection?

From: ASD <devnull5475_at_yahoo.com>
Date: 24 Sep 2006 14:03:48 -0700
Message-ID: <1159131828.443719.41590_at_h48g2000cwc.googlegroups.com>


After much experimentation, we resolved this issue.

  1. As explained in JDBC 10.2 documentation, it's not necessary to explicitly return connections to pool so other users can access them. OracleOCIConnectionPool handles sharing transparently, behind the scenes.
  2. Our problem was caused by LONG columns. When SELECT statement included LONG data, connections were not put back.
Received on Sun Sep 24 2006 - 23:03:48 CEST

Original text of this message