djerraballi
djerraballi
/ gist:6ad64b649abb198b5ebe
Created
July 18, 2015 23:35
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT 'model.User' AS NUCLEUS_TYPE,A0.firstName,A0.id,A0.lastName FROM `User` A0 WHERE A0.id IN(290) | |
| SELECT 'model.UserEmail' AS NUCLEUS_TYPE,A0.email,A0.`primary`,A0.userId FROM UserEmail A0 WHERE EXISTS (SELECT 'model.User' AS NUCLEUS_TYPE,A0_SUB.id AS DN_APPID FROM `User` A0_SUB WHERE A0_SUB.id IN(290) AND A0.userId = A0_SUB.id) |
djerraballi
/ gist:9ecb8e7727e3dac51769
Last active
August 29, 2015 14:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2015-05-13 06:59:34 [work-14748] WARN com.google.common.cache.LocalCache - Exception thrown during refresh | |
| java.util.concurrent.ExecutionException: javax.jdo.JDODataStoreException: Timeout after 30000ms of waiting for a connection. | |
| NestedThrowables: | |
| Caused by: java.sql.SQLTimeoutException: Timeout after 30000ms of waiting for a connection. | |
| at com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:224) ~[HikariCP-java6-2.3.5.jar:na] | |
| at com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:179) ~[HikariCP-java6-2.3.5.jar:na] | |
| at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:93) ~[HikariCP-java6-2.3.5.jar:na] | |
| at org.datanucleus.store.rdbms.ConnectionProviderPriorityList.getConnection(ConnectionProviderPriorityList.java:57) ~[datanucleus-rdbms-4.0.7.jar:na] | |
| at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:402) ~[datanucleus-rdbms-4.0.7.jar:na] | |
| at org.datanucleus.store.rdbms.SQLContr |
djerraballi
/ gist:46b46ff89f5635af1c3e
Last active
August 29, 2015 14:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| private static final Integer IDLE_TIMEOUT_DEFAULT = 240000; | |
| private static final Boolean PREP_STMT_CACHE_DEFAULT = true; | |
| private static final Integer PREP_STMT_CACHE_SIZE_DEFAULT = 250; | |
| private static final Integer PREP_STMT_CACHE_SQL_LIMIT_DEFAULT = 2048; | |
| private static final Integer MAX_POOL_SIZE = 15; | |
| private static final Integer MIN_IDLE_POOL = 5; | |
| private static final Integer LEAK_DETECTION_THRESHOLD = 30000; | |
| final HikariConfig hikariConfig = new HikariConfig(); | |
| hikariConfig.setJdbcUrl(getDBConnectionUrl()); |
djerraballi
/ gist:fafa48a0fa0fea18b31a
Last active
August 29, 2015 14:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2015-04-18 18:53:38.203 [work-4] INFO c.y.m.d.dao.BasePersistentDao - getByField - START: 1429383218203 | |
| 2015-04-18 18:53:38.204 [work-4] DEBUG DataNucleus.Persistence - ExecutionContext "org.datanucleus.ExecutionContextImpl@1419f960" opened for datastore "org.datanucleus.store.rdbms.RDBMSStoreManager@3471887a" with txn="org.datanucleus.TransactionImpl@11983c8b" | |
| 2015-04-18 18:53:38.204 [work-4] INFO c.y.m.d.dao.BasePersistentDao - getByField - PMP: 1429383218204 | |
| 2015-04-18 18:53:38.204 [work-4] DEBUG DataNucleus.Query - Query "SELECT FROM <candidateClass> WHERE :param1.contains(code) FetchPlan [default]" of language "JDOQL" has been run before so reusing existing generic compilation | |
| 2015-04-18 18:53:38.204 [work-4] DEBUG DataNucleus.Query - JDOQL Query : Compiling "SELECT FROM <candidateClass> WHERE :param1.contains(code)" for datastore | |
| 2015-04-18 18:53:38.204 [work-4] DEBUG DataNucleus.Query - Parameter ParameterExpression{param1} is being resolved as a literal, so the query is no longer precompilable | |
| 2015- |