SQLFeatureNotSupportedException: null
920 views
Skip to first unread message
Will Williams
May 21, 2018, 1:49:21 PM5/21/18
to HikariCP
All,
Conditions:
Java 8
Spring 4
Spring Boot 2.0.2
HikariCP-3.1.0
DB2 (db2jcc4-10.1.jar
Properties
## Spring Datasource
spring.datasource.url=jdbc:db2://<hostname>:<port>/<database>
spring.datasource.username=<username>
spring.datasource.password=<password>
spring.datasource.driver-class-name=com.ibm.db2.jcc.DB2Driver
spring.datasource.initialize=true
spring.dataSourceClassName=com.ibm.db2.jcc.DB2SimpleDataSource
# Allows Hibernate to generate SQL optimized for a particular DBMS
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.DB2Dialect
spring.jpa.properties.hibernate.id.new_generator_mappings = false
spring.jpa.properties.hibernate.format_sql = true
spring.jpa.show-sql=true
# Spring Hikari properties
spring.datasource.hikari.schema=<schema>
#60 sec
spring.datasource.hikari.connection-timeout=60000
Simple JPA application I initially built using JPARepository interfaces and ran into the exception. I then added datasoiurce and entitymanager implementatiion with the same outcome. I found in the bug fix notes that this exception is thrown when setmetworktimeout was set. But this was resolved. So I'm not sure what I'm missing. I've used this same project setup on different projects. But this is the first time I've experienced this issue.
Here is the exception:
1.findAll()...
2018-05-21 11:11:26.029 DEBUG 19152 --- [ restartedMain] org.hibernate.SQL :
select
clients0_."id" as id1_24_,
clients0_."address" as address5_24_,
clients0_.city as city8_24_,
clients0_.client_name as client_n9_24_,
clients0_."state" as state14_24_,
from
clients clients0_
order by
clients0_."id"
Hibernate:
select
clients0_."id" as id1_24_,
clients0_."address" as address5_24_,
clients0_.city as city8_24_,
clients0_.client_name as client_n9_24_,
clients0_."state" as state14_24_,
from
clients clients0_
order by
clients0_."id"
2018-05-21 11:11:26.040 WARN 19152 --- [ restartedMain] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: null
2018-05-21 11:11:26.040 ERROR 19152 --- [ restartedMain] o.h.engine.jdbc.spi.SqlExceptionHelper : null
2018-05-21 11:11:26.079 INFO 19152 --- [ restartedMain] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2018-05-21 11:11:26.133 ERROR 19152 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed
Caused by: java.sql.SQLFeatureNotSupportedException: null
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:135) ~[HikariCP-3.1.0.jar:na]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
... 49 common frames omitted
Brett Wooldridge
May 21, 2018, 4:06:55 PM5/21/18
to HikariCP
Hmmmm. You’re sure that you are not picking up another driver version? The pool started, which means it was successful once. Maybe try shortening the maxLifetime to 5 minutes...
Will Williams
May 21, 2018, 4:49:13 PM5/21/18
to HikariCP
Thanks for the reply..... I made the change you suggested and the same results. I stripped everything back to the basics. I checked my classapath and there are no duplicate libraries. My maven pom has only the spring boot starter parent, spring data jpa, starter, start-test, and starter-logging
Here is the console output.. cleaned up...
2018-05-21 14:37:30.086 WARN 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling it.
2018-05-21 14:37:30.086 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : HikariPool-1 - configuration:
2018-05-21 14:37:30.099 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : allowPoolSuspension.............false
2018-05-21 14:37:30.099 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : autoCommit......................false
2018-05-21 14:37:30.100 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : catalog.........................none
2018-05-21 14:37:30.108 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionInitSql...............none
2018-05-21 14:37:30.116 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionTestQuery.............none
2018-05-21 14:37:30.117 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionTimeout...............30000
2018-05-21 14:37:30.118 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSource......................none
2018-05-21 14:37:30.125 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceClassName.............none
2018-05-21 14:37:30.126 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceJNDI..................none
2018-05-21 14:37:30.133 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceProperties............{password=<masked>}
2018-05-21 14:37:30.135 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : driverClassName................."com.ibm.db2.jcc.DB2Driver"
2018-05-21 14:37:30.142 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : healthCheckProperties...........{}
2018-05-21 14:37:30.144 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : healthCheckRegistry.............none
2018-05-21 14:37:30.146 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : idleTimeout.....................0
2018-05-21 14:37:30.151 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : initializationFailFast..........true
2018-05-21 14:37:30.152 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : initializationFailTimeout.......1
2018-05-21 14:37:30.152 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : isolateInternalQueries..........false
2018-05-21 14:37:30.157 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : jdbc4ConnectionTest.............false
2018-05-21 14:37:30.166 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : jdbcUrl.........................jdbc:db2://<hostname>:<port>/<database>
2018-05-21 14:37:30.168 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : leakDetectionThreshold..........0
2018-05-21 14:37:30.180 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : maxLifetime.....................300000
2018-05-21 14:37:30.198 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : maximumPoolSize.................5
2018-05-21 14:37:30.216 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : metricRegistry..................none
2018-05-21 14:37:30.227 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : metricsTrackerFactory...........none
2018-05-21 14:37:30.231 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : minimumIdle.....................5
2018-05-21 14:37:30.232 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : password........................<masked>
2018-05-21 14:37:30.232 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : poolName........................"HikariPool-1"
2018-05-21 14:37:30.239 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : readOnly........................false
2018-05-21 14:37:30.245 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : registerMbeans..................false
2018-05-21 14:37:30.254 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : scheduledExecutor...............none
2018-05-21 14:37:30.265 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : scheduledExecutorService........internal
2018-05-21 14:37:30.268 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : schema.........................."<SCHEMA>"
2018-05-21 14:37:30.269 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : threadFactory...................internal
2018-05-21 14:37:30.282 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : transactionIsolation............default
2018-05-21 14:37:30.296 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : username........................"<USERNAME>"
2018-05-21 14:37:30.301 DEBUG 26964 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : validationTimeout...............5000
2018-05-21 14:37:30.302 INFO 26964 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2018-05-21 14:37:31.381 INFO 26964 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2018-05-21 14:37:31.844 INFO 26964 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Building JPA container EntityManagerFactory for persistence unit 'default'
2018-05-21 14:37:31.890 INFO 26964 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [
name: default
...]
2018-05-21 14:37:32.020 INFO 26964 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate Core {5.2.17.Final}
2018-05-21 14:37:32.026 INFO 26964 --- [ restartedMain] org.hibernate.cfg.Environment : HHH000205: Loaded properties from resource hibernate.properties: {hibernate.connection.username=<username>, hibernate.connection.password=****, hibernate.dialect=org.hibernate.dialect.HSQLDialect, hibernate.connection.url=jdbc:db2://<hostname>:<port>/<database>, hibernate.bytecode.use_reflection_optimizer=false, hibernate.connection.driver_class=com.ibm.db2.jcc.DB2Driver}
2018-05-21 14:37:32.096 INFO 26964 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
2018-05-21 14:37:32.424 WARN 26964 --- [ restartedMain] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata : null
2018-05-21 14:37:32.454 INFO 26964 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.DB2Dialect
2018-05-21 14:37:32.494 INFO 26964 --- [ restartedMain] o.h.e.j.e.i.LobCreatorBuilderImpl : HHH000422: Disabling contextual LOB creation as connection was null
2018-05-21 14:37:35.311 INFO 26964 --- [ restartedMain] o.h.h.i.QueryTranslatorFactoryInitiator : HHH000397: Using ASTQueryTranslatorFactory
2018-05-21 14:37:35.732 INFO 26964 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2018-05-21 14:37:38.374 INFO 26964 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
2018-05-21 14:37:38.451 INFO 26964 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on startup
2018-05-21 14:37:38.466 INFO 26964 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Bean with name 'dataSource' has been autodetected for JMX exposure
2018-05-21 14:37:38.481 INFO 26964 --- [ restartedMain] o.s.j.e.a.AnnotationMBeanExporter : Located MBean 'dataSource': registering with JMX server as MBean [com.zaxxer.hikari:name=dataSource,type=HikariDataSource]
2018-05-21 14:37:38.569 INFO 26964 --- [ restartedMain] c.i.g.persistence.GssEntityApplication : Started GssEntityApplication in 12.745 seconds (JVM running for 13.568)
Brett Wooldridge
May 23, 2018, 7:04:59 AM5/23/18
to HikariCP
If you are using DB2, why does the log show HSQLDialect as the hibernate dialect?
Will Williams
Jun 2, 2018, 1:31:38 PM6/2/18
to HikariCP
I have corrected the issue with the dialect. But now when I query using JpaRepository.findAll(), the query hangs and eventually get OutOfMemory Exception.
Any thoughts?
2018-06-02 10:50:19.653 DEBUG 15072 --- [ restartedMain] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource
2018-06-02 10:50:19.654 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : SpringBootJPAHikariCP - configuration:
2018-06-02 10:50:19.660 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : allowPoolSuspension.............false
2018-06-02 10:50:19.662 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : autoCommit......................true
2018-06-02 10:50:19.662 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : catalog.........................none
2018-06-02 10:50:19.662 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionInitSql...............none
2018-06-02 10:50:19.663 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionTestQuery............."SELECT COUNT(*) FROM SYSCAT.TABLES"
2018-06-02 10:50:19.663 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : connectionTimeout...............30000
2018-06-02 10:50:19.664 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSource......................none
2018-06-02 10:50:19.666 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceClassName.............none
2018-06-02 10:50:19.667 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceJNDI..................none
2018-06-02 10:50:19.673 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : dataSourceProperties............{password=<masked>}
2018-06-02 10:50:19.676 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : driverClassName................."com.ibm.db2.jcc.DB2Driver"
2018-06-02 10:50:19.678 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : healthCheckProperties...........{}
2018-06-02 10:50:19.678 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : healthCheckRegistry.............none
2018-06-02 10:50:19.684 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : idleTimeout.....................30000
2018-06-02 10:50:19.684 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : initializationFailTimeout.......1
2018-06-02 10:50:19.685 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : isolateInternalQueries..........false
2018-06-02 10:50:19.685 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : jdbcUrl.........................jdbc:db2://<host>:<port>/<database>
2018-06-02 10:50:19.686 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : leakDetectionThreshold..........0
2018-06-02 10:50:19.686 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : maxLifetime.....................2000000
2018-06-02 10:50:19.687 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : maximumPoolSize.................20
2018-06-02 10:50:19.696 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : metricRegistry..................none
2018-06-02 10:50:19.697 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : metricsTrackerFactory...........none
2018-06-02 10:50:19.698 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : minimumIdle.....................5
2018-06-02 10:50:19.698 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : password........................<masked>
2018-06-02 10:50:19.698 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : poolName........................"SpringBootJPAHikariCP"
2018-06-02 10:50:19.699 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : readOnly........................false
2018-06-02 10:50:19.699 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : registerMbeans..................false
2018-06-02 10:50:19.700 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : scheduledExecutor...............none
2018-06-02 10:50:19.700 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : schema.........................."<Schema Name"
2018-06-02 10:50:19.700 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : threadFactory...................internal
2018-06-02 10:50:19.701 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : transactionIsolation............default
2018-06-02 10:50:19.701 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : username........................"<Username>"
2018-06-02 10:50:19.701 DEBUG 15072 --- [ restartedMain] com.zaxxer.hikari.HikariConfig : validationTimeout...............5000
2018-06-02 10:50:19.702 INFO 15072 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : SpringBootJPAHikariCP - Starting...
2018-06-02 10:50:20.996 INFO 15072 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : SpringBootJPAHikariCP - Start completed.
2018-06-02 10:50:21.007 DEBUG 15072 --- [ restartedMain] o.s.jdbc.datasource.DataSourceUtils : Returning JDBC Connection to DataSource
2018-06-02 10:50:31.267 DEBUG 15072 --- [ restartedMain] o.s.orm.jpa.JpaTransactionManager : Exposing JPA transaction as JDBC transaction [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@435ae218]
2018-06-02 10:50:31.316 DEBUG 15072 --- [ restartedMain] org.hibernate.SQL :
select
clients0_.id as id1_24_,
clients0_.access_list as access_l2_24_,
clients0_.access_reqs as access_r3_24_,
clients0_.access_time_penalty as access_t4_24_,
clients0_.address as address5_24_,
clients0_.block_list as block_li6_24_,
clients0_.change_flag as change_f7_24_,
clients0_.city as city8_24_,
clients0_.client_name as client_n9_24_,
clients0_.country_id as country10_24_,
clients0_.is_valid as is_vali11_24_,
clients0_.limited_access_list as limited12_24_,
clients0_.limited_access_time_penalty as limited13_24_,
clients0_.state as state14_24_,
clients0_.svcs as svcs15_24_,
clients0_.updated_at as updated16_24_
from
clients clients0_
Hibernate:
select
clients0_.id as id1_24_,
clients0_.access_list as access_l2_24_,
clients0_.access_reqs as access_r3_24_,
clients0_.access_time_penalty as access_t4_24_,
clients0_.address as address5_24_,
clients0_.block_list as block_li6_24_,
clients0_.change_flag as change_f7_24_,
clients0_.city as city8_24_,
clients0_.client_name as client_n9_24_,
clients0_.country_id as country10_24_,
clients0_.is_valid as is_vali11_24_,
clients0_.limited_access_list as limited12_24_,
clients0_.limited_access_time_penalty as limited13_24_,
clients0_.state as state14_24_,
clients0_.svcs as svcs15_24_,
clients0_.updated_at as updated16_24_
from
clients clients0_
2018-06-02 11:18:43.224 DEBUG 15072 --- [ restartedMain] o.s.orm.jpa.JpaTransactionManager : Initiating transaction rollback
2018-06-02 11:19:13.225 WARN 15072 --- [iCP housekeeper] com.zaxxer.hikari.pool.HikariPool : SpringBootJPAHikariCP - Thread starvation or clock leap detected (housekeeper delta=56s627ms812╡s869ns).
2018-06-02 11:26:33.702 WARN 15072 --- [iCP housekeeper] com.zaxxer.hikari.pool.HikariPool : SpringBootJPAHikariCP - Thread starvation or clock leap detected (housekeeper delta=7m20s476ms390╡s360ns).
2018-06-02 11:26:48.007 DEBUG 15072 --- [ restartedMain] o.s.jdbc.datasource.DataSourceUtils : Resetting read-only flag of JDBC Connection [HikariProxyConnection@666086945 wrapping com.ibm.db2.jcc.t4.b@66d2ef5a]
2018-06-02 11:27:25.205 ERROR 15072 --- [ restartedMain] o.s.t.i.TransactionInterceptor : Application exception overridden by rollback exception
java.lang.OutOfMemoryError: GC overhead limit exceeded
at java.util.LinkedHashMap.newNode(LinkedHashMap.java:256) ~[na:1.8.0_144]
at java.util.HashMap.putVal(HashMap.java:641) ~[na:1.8.0_144]
at java.util.HashMap.put(HashMap.java:611) ~[na:1.8.0_144]
at org.hibernate.internal.util.collections.IdentityMap.put(IdentityMap.java:94) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.engine.internal.StatefulPersistenceContext.addCollection(StatefulPersistenceContext.java:854) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.engine.internal.StatefulPersistenceContext.addUninitializedCollection(StatefulPersistenceContext.java:825) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.type.CollectionType.getCollection(CollectionType.java:777) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.type.CollectionType.resolveKey(CollectionType.java:467) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.type.CollectionType.resolve(CollectionType.java:460) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:171) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:128) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1152) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.processResultSet(Loader.java:1011) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:949) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.query.Query.getResultList(Query.java:146) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:307) ~[spring-data-jpa-2.0.7.RELEASE.jar:2.0.7.RELEASE]
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:74) ~[spring-data-jpa-2.0.7.RELEASE.jar:2.0.7.RELEASE]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
Brett Wooldridge
Jun 2, 2018, 1:52:10 PM6/2/18
to HikariCP
My thoughts are, you are clearly out of the realm of HikariCP issues. This is not the appropriate forum for this issue. Please ask on stackoverflow or the Hibernate group. Best of luck,
-Brett
Reply all
Reply to author
Forward
0 new messages