Hoang
Hoang

Reputation: 1047

Caching data with Tomcat server

I have problem about Tomcat Server and MySQL server.

Sometime data can not get form Mysql server . All though database have many data.
When I shutdown Tomcat server and the Startup tomcat server . Everything become a normally. I think maybe reason is Caching of Tomcat server but I am not sure.

If you know that please explain for me.

Thanks

Upvotes: 0

Views: 471

Answers (1)

Fathah Rehman P
Fathah Rehman P

Reputation: 8741

Tomcat may be creating connection pool to your database. And may be your application not closing connection to database after use. If this is the case then after some database operation you cant connect to your database from your application. Check your application is closing connection to database. Restarting tomcat will close connection to database from your application. Restarting tomcat is not the solution. Make sure your application is closing connection to database after use

Upvotes: 1

Related Questions