Re: Need support for MySQL disconnected automatically
Posted by: Nataraja mani
Date: March 07, 2019 05:23AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need support for MySQL disconnected automatically
March 07, 2019 05:23AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.