Hibernate 5.2.12 hibernate.properties configuration for Transaction Management

Hibernate ORM
1

Hi,

We are upgrading hibernate framework from 3.x to 5.2.12. We have configured many properties like connection string, pool size , cache provider class etc. in hibernate.properties file.

Specifically for Transaction related properties, for 3.x version we were having following properties

hibernate.transaction.factory_class=org.hibernate.transaction.JTATransactionFactory
hibernate.transaction.manager_lookup_class=<>
hibernate.current_session_context_class=jta
hibernate.connection.release_mode=after_transaction

What changes are expected for Hibernate 5.2.12 in these configurations?
Referring to Migration guide I have done following changes and currently it looks like

hibernate.transaction.coordinator_class=jta
hibernate.transaction.jta.platform=<>
jta.UserTransaction=java:comp/UserTransaction
hibernate.current_session_context_class=jta
hibernate.connection.release_mode=after_transaction

When I start the server I get following exception stack trace :-

INFO | jvm 1 | 2020/02/21 15:24:49 | 15:24:49.394 [localhost-startStop-1] ERROR org.springframework.web.context.ContextLoader - Context initialization failed
INFO | jvm 1 | 2020/02/21 15:24:49 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘transferFileService’ defined in ServletContext resource [/WEB-INF/twng-config/transferfile/spring/TransferFile.xml]: Invocation of init method failed; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1756) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:586) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:508) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:848) ~[spring-beans-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:865) ~[spring-context-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:548) ~[spring-context-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:400) ~[spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291) [spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:24:49 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103) [spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]

…
Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query
jvm 1 | at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1496) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]

It does fire few queries and then fails with this exception
I have even tried with increasing connection pool size (initial/max) from 2/10 to 5/20

Do you suggest any changes in these configurations?

2

If I fix the code for which above exception(TransactionRequiredException) was thrown,
system is not able to get the connection. Below is a stack trace:

org.springframework.transaction.interceptor.TransactionInterceptor - Application exception overridden by commit exception
INFO | jvm 1 | 2020/02/21 15:49:57 | com.twng.framework.exception.TwngException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.dao.ReportDAOImpl.fetchReportDestinations(ReportDAOImpl.java:745) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.sun.proxy.$Proxy848.fetchReportDestinations(Unknown Source) ~[?:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.framework.interceptor.EODStopCheckInterceptor.invoke(EODStopCheckInterceptor.java:70) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.sun.proxy.$Proxy869.fetchReportDestinations(Unknown Source) ~[?:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:206) ~[spring-aop-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.sun.proxy.$Proxy869.fetchReportDestinations(Unknown Source) ~[?:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.service.ReportServiceJasperServerImpl.getFolderTreeNode(ReportServiceJasperServerImpl.java:210) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.service.ReportServiceJasperServerImpl.initialize(ReportServiceJasperServerImpl.java:186) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1881) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1824) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1752) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:586) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:508) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring-beans-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) [classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204) [classes/:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:848) [spring-beans-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:865) [spring-context-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:548) [spring-context-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:400) [spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:291) [spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103) [spring-web-5.1.0.RELEASE.jar:5.1.0.RELEASE]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) [catalina.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:629) [catalina.jar:8.5.32-dev]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839) [catalina.jar:8.5.32-dev]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | at java.lang.Thread.run(Thread.java:745) [?:1.8.0_91]
INFO | jvm 1 | 2020/02/21 15:49:57 | Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.dao.ReportDAOImpl.fetchReportDestinations(ReportDAOImpl.java:742) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | … 64 more
INFO | jvm 1 | 2020/02/21 15:49:57 | Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQuery(Loader.java:938) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:384) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.dao.ReportDAOImpl.fetchReportDestinations(ReportDAOImpl.java:742) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | … 64 more
INFO | jvm 1 | 2020/02/21 15:49:57 | Caused by: java.sql.SQLException
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:74) ~[tranql-connector-1.1.jar:1.1]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQuery(Loader.java:938) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:384) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at com.twng.reports.dao.ReportDAOImpl.fetchReportDestinations(ReportDAOImpl.java:742) ~[classes/:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | … 64 more
INFO | jvm 1 | 2020/02/21 15:49:57 | Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 5000 [ms] ) for pool org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor@e8247d4
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:86) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:86) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87) ~[geronimo-connector-2.1.1.jar:?]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:69) ~[tranql-connector-1.1.jar:1.1]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1985) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1915) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQuery(Loader.java:938) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2692) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.doList(Loader.java:2675) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.Loader.list(Loader.java:2502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:384) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]
INFO | jvm 1 | 2020/02/21 15:49:57 | at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414) ~[hibernate-core-5.2.12.Final.jar:5.2.12.Final]