What version of Connector/J are you using?
I am using follwing jar file for connecting the database.
mysql-connector-java-5.0.7.bin.jar
1. Is this after some (idle) time while the webapp is running?
Approximately 2 or 3 hours Idle time.
2. What kind of exceptions are you getting?
When I am trying to connect MySQL through command prompt ,
I am getting following Error .
'can't connect to local MYSQL Server through socket '/var/lib/mysql/mysql.sock' (2).
3. Was there any MySQL server reboot in the meantime?
No , I have only one MySQL Server.
4. Are you using some kind of connection pooling in the webapp?
Yes I am Using the connection pooling in my JAVA Web application.
Actually I am using JDBC template to connecting the MySQL.
By Default , JDBC temple have connection pooling.
I used below settings for My connection pooling.
<property name="maxActive" value="20">
<property name="maxIdle" value="10">
<property name="maxWait" value="-1">
5. How does the connection string look like in the webapp?
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/testdb?
createDatabaseIfNotExist=true&useUnicode=yes&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
database.user=test
database.password=test
Please provide the solution as soon as Possible.