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>
Date: 24 Sep 2006 14:03:48 -0700
Message-ID: <1159131828.443719.41590_at_h48g2000cwc.googlegroups.com>
After much experimentation, we resolved this issue.
- 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.
- Our problem was caused by LONG columns. When SELECT statement included LONG data, connections were not put back.