Try BEA web based news server, under weblogic.developer.interest.jdbc there
is lively discussion of this topic "Errors gettign connections from
connection pool".
----- Original Message -----
From: "Abhilash Nair" <[EMAIL PROTECTED]>
To: "JDJList" <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 10:51 AM
Subject: [jdjlist] Closing Connections!!??
> Hi All:
>
> We are using Oracle Thin Type 4 Driver with Weblogic
> App Server version 5.1 for our JDBC Connections and
> use Prepared Statements. We also have specified the
> maximum connections to be 100 in the weblogic
> properties and in our DAO's we close the
> PreparedStatement, ResultSet and Connection in the
> finally block. But there are STILL instances where the
> connections are not being closed even when the
> following code is executed:
>
> try{
> //create connection,etc.
> }catch(SQLException sqlExc){
> //handle error
> }finally{
> try {
> if(rs != null){
> rs.close();
> }
> if(prepStmt != null){
> prepStmt.close();
> }
> if(con != null){
> con.close();
> }
> } catch(SQLException e) {;}
> }
>
> Problem faced: Exceeding the maximum number of
> connections due to inactive open connections. Has
> anyone faced this problem?
>
> I thought that the finally block is executed no matter
> what and is the best place to close connections to
> ensure a proper clean - up! Can anyone please suggest
> what am I doing wrong here?
>
> Thanks in advance.
> Abhi
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
>
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
