I just thought of another possibility - do you use a connection pool ? If so,
it might be malconfigured .
--- Abhilash Nair <[EMAIL PROTECTED]> wrote:
> Hi Chip:
>
> Thanks for your reply. I do not think the query is
> failing because the query runs and inserts the results
> successfully in the database. The only thing that does
> NOT happen is the closing of the connection and it
> remains inactive thus exceeding the maximum
> connections in the pool specified in the properties
> file (i.e. 100 connections). I will try testing the
> closing of connections in separate try/catch blocks
> and add a log to the catch block and see if it works
> :)
> Thanks and Regards,
> Abhi
>
> --- "WHITESIDE, CHIP" <[EMAIL PROTECTED]>
> wrote:
> >
> > We usually enclose each attempt to close an object
> > with a try/catch:
> >
> > try{
> > //create connection,etc.
> > }catch(SQLException sqlExc){
> > //handle error
> > }finally{
> > try {
> > try {
> > if(rs != null){
> > rs.close();
> > }
> > } catch (Exception e){
> > log("unable to close resultset");
> > }
> > try {
> > if(prepStmt != null){
> > prepStmt.close();
> > }
> > } catch (Exception e){
> > log("unable to close statement");
> > }
> > try {
> > if(con != null){
> > con.close();
> > }
> > } catch (Exception e){
> > log("unable to close connection");
> > }
> > } catch(SQLException e) {;}
> > }
> >
> >
> > > -----Original Message-----
> > > From: Mark E. Zawadzki [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, June 06, 2002 11:06 AM
> > > To: JDJList
> > > Subject: [jdjlist] Re: Closing Connections!!??
> > >
> > >
> > > Are you sure that a SQLException is not being
> > thrown, in some
> > > cases, w/in the
> > > finally ? I see you do an empty catch.
> > > --- Abhilash Nair <[EMAIL PROTECTED]> wrote:
> > > > 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
> > >
> > >
> > > =====
> > > Mark Zawadzki Performance Engineer/DBA/Programmer
> > > extraordinaire'[EMAIL PROTECTED]
> > > [EMAIL PROTECTED]"Programming today is a
> > race between
> > > software engineers striving to build bigger and
> > better
> > > idiot-proof programs, and the universe trying to
> > build bigger
> > > and better idiots. So far, the universe is
> > winningRobert
> > > Cringle (columnist, author, host of "Triumph of
> > the Nerds")
> > >
> > > __________________________________________________
> > > 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
>
>
> =====
> You can reach me on:
> Weekdays: (617)509-5312
> Weekends and evenings: (781)321-2065
> Pager: (781)553-8323
> Thanks and Regards,
> Nair Abhilash R
> (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
=====
Mark Zawadzki Performance Engineer/DBA/Programmer extraordinaire�[EMAIL PROTECTED]
[EMAIL PROTECTED]"Programming today is a race between software engineers
striving to build bigger and better idiot-proof programs, and the universe trying to
build bigger and better idiots. So far, the universe is winningRobert Cringle
(columnist, author, host of "Triumph of the Nerds")
__________________________________________________
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
