• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

closing the database connection

 
trupti nigam
Ranch Hand
Posts: 627
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

In my code, I have made sure that I am closing all the open dataBase connections like below:

finally{
if(con!=null){
dao.close(null,conn);
}
}

where conn is the connection object. and null is for preparedStatement.

In the dao close() method if connection is not null, con.close() (java method) is called.
While debugging the application , I found out that the connection is not getting close.

my question is : does the connection is closed by calling connection.close method (provied by jdk) or it just marks it for garbage collection.

How can I make sure that the connection is getting closed? (is it by passing exclusively null for connection object?)

Thanks,
Trupti
[ April 19, 2005: Message edited by: trupti nigam ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Trupti,
If you are using a connection pool, close() returns the connection to the pool. If you are not using a connection pool, close() closes the connection.

close() does not null out the reference to the connection object in your code. If you try to use the connection, you will get a StaleConnectionException. However, having this reference does not affect the connection resources.

Why aren't you closing the PreparedStatement too?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic