Changeset 346:f72ec7d320af

Timestamp:

09/18/11 23:57:06 (5 months ago)

Author:

xeraph

Branch:

default

Convert:

svn:7c3792e6-d75b-4784-96a6-b298f655ee64/trunk@2780

Message:

fixed mysql wait_timeout problem

Location:

kraken-dom/src/main

Files:

• java/org/krakenapps/dom/script/DomScript.java (modified) (1 diff)
• resources/OSGI-INF/kraken-jpa/config (modified) (1 diff)

kraken-dom/src/main/java/org/krakenapps/dom/script/DomScript.java

@@ -42 +42 @@
                         props.put("hibernate.connection.username", user);
                         props.put("hibernate.connection.password", password);
-                        props.put("hibernate.connection.is-connection-validation-required", "true");
-                        props.put("hibernate.connection.autoReconnect", "true");
-                        props.put("hibernate.connection.autoReconnectForPools", "true");
 
                         jpa.registerEntityManagerFactory(FACTORY_NAME, props, bc.getBundle().getBundleId());

kraken-dom/src/main/resources/OSGI-INF/kraken-jpa/config

@@ -8 +8 @@
 hibernate.show_sql = false
 hibernate.hbm2ddl.auto = update
+hibernate.connection.autoReconnect = true
+hibernate.connection.autoReconnectForPools = true
+hibernate.connection.is-connection-validation-required = true
+hibernate.connection.validationQuery = SELECT 1
+hibernate.connection.testOnBorrow = true
+hibernate.connection.testWhileIdle = true
+hibernate.connection.timeBetweenEvictionRunsMillis = 10000
+hibernate.connection.minEvictableIdleTimeMillis = 60000