mysql> SHOW VARIABLES LIKE 'wait_timeout'; +---------------+-------+ |
Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 |
+---------------+-------+ 1 row in set (0.00 sec) mysql> SHOW VARIABLES LIKE
'connect_timeout'; +-----------------+-------+ | Variable_name | Value |
+-----------------+-------+ | connect_timeout | 30 |
+-----------------+-------+
-------- GENERAL SETTINGS
----------------------------------------------------
*Datasource Classname:*
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource Vendor-specific
classname that implements the DataSource and/or XADataSource APIs
-------- POOL SETTINGS
-------------------------------------------------------
*Initial and Minimum Pool Size:* 8 Connections Minimum and initial number of
connections maintained in the pool *Maximum Pool Size:* 320 Connections
Maximum number of connections that can be created to satisfy client requests
*Pool Resize Quantity:* 2 Connections Number of connections to be removed
when pool idle timeout expires *Idle Timeout:* 300 Seconds Maximum time that
connection can remain idle in the pool *Max Wait Time:* 30000 Milliseconds
Amount of time caller waits before connection timeout is sent
-------- JDBC CONNECTION POOL ADVANCED ATTRIBUTES
----------------------------
*Pooling:* (true) Enabled When set to false, disables connection pooling for
the pool
.... Connection Validation
*Connection Validation:* (true) Required Validate connections, allow server
to reconnect in case of failure *Validation Method:* custom-validation
*Validation Class Name:*
org.glassfish.api.jdbc.validation.MySQLConnectionValidation If
custom-validation is selected, specify validation classname.
-------- JDBC CONNECTION POOL PROPERTIES
-------------------------------------
AutoReconnectForPools=true AutoReconnect=true testWhileIdle=true
[#|2012-09-02T23:15:16.209+0200|INFO|glassfish3.1.2|org.hibernate.event.internal
.DefaultLoadEventListener|_ThreadID=94;_ThreadName=Thread-2;|HHH000327: Error
performing load command : org.hibernate.exception.JDBCConnectionException:
The last packet successfully received from the server was67763 seconds
ago.The last packet sent successfully to the server was 67763 seconds ago,
which is longer than the server configured value of 'wait_timeout'. You
should consider either expiring and/or testing connection validity before use
in your application, increasing the server configured values for client
timeouts, or using the Connector/J connection property 'autoReconnect=true'
to avoid this problem.|#] hibernate-core-4.1.6.Final.jar jdk1.7.0_05 How can
I solve this issue?
--
[Message sent by forum member 'pappz']
View Post: http://forums.java.net/node/889945