• Post Reply Bookmark Topic Watch Topic
  • New Topic

connection handling  RSS feed

 
johny sill
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

i develop a swing application,
i create a connection like this
public static Connection getConnection()throws Exception{
Connection conn=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url,userName,password);

}
catch(SQLException sqlex){
sqlex.printStackTrace();
}
}

but this connection is hold in db,not closed
this time i got an error like maximum number of connections exceeded

pls help me,

Thanks,
johny
 
Rob Spoor
Sheriff
Posts: 21092
85
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
After you're done with them, you should call close() on your Connection objects.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!