• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection problem

 
Arvind Purohit
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arvind Purohit wrote:Hi All
I am trying to connect a data base. below i have given the code. I am able to connect to data base but unable to connect 2nd time if difference between 1st time and 2nd time is greater then "wait time out" of mysql data base.
I am using mysql data base. I am getting "Communications link failure" problem
wait_timeout is 10 sec (for convenience) it is 8 hour for my DB
I am giving you code


AND I am testing like


and it is giving exception like


 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know if this is your problem but you are not closing your connection, statement or result set. I see you are also eating the DatabaseInitializationException in getInstance().
 
Arvind Purohit
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tom Reilly wrote:I don't know if this is your problem but you are not closing your connection, statement or result set. I see you are also eating the DatabaseInitializationException in getInstance().

Thanks for your reply...
I am not getting what do you want to say. how do i solve this problem

Thanks
 
Tom Reilly
Rancher
Posts: 618
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to tell JDBC that you are done using its resources. Examples:

Statement.close()
ResultSet.close()
Connection.close()

Take a look at one of the JDBC tutorials out there. I haven't looked at one in years so cannot recommend a good one. Perhaps someone else can.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic