BaseModelUADDisplayTest#testOrder fails in Oracle 19 and DB2 11.1

• Type: Bug
• Status: Selected for Development
• Resolution: Unresolved
• Affects Version/s: 7.3.X, Master
• Fix Version/s: None
• Component/s: User Management > Personal Data
• Labels:
  • 7.4-known-issues
  • 7.4-must
  • backend_test
  • liferay-ga1-dxp-7413
  • liferay-ga10-ce-743
  • liferay-ga11-ce-743
  • liferay-ga12-ce-743
  • liferay-ga13-ce-743-known-issue
  • liferay-ga14-ce-743-known-issues
  • liferay-ga15-ce-743-known-issues
  • liferay-ga16-ce-743-known-issues
  • liferay-ga17-ce-743-known-issues
  • liferay-ga18-ce-743-known-issues
  • liferay-ga19-ce-743-known-issues
  • liferay-ga2-ce-741
  • liferay-ga20-ce-743-known-issues
  • liferay-ga21-ce-743-known-issues
  • liferay-ga22-ce-743-known-issues
  • liferay-ga23-ce-743-known-issues
  • liferay-ga24-ce-743-known-issues
  • liferay-ga25-ce-743-known-issues
  • liferay-ga26-ce-743-known-issues
  • liferay-ga27-ce-743-known-issues
  • liferay-ga28-ce-743-known-issues
  • liferay-ga29-ce-743-known-issues
  • liferay-ga30-ce-743-known-issues
  • liferay-ga31-ce-743-known-issues
  • liferay-ga32-ce-743-known-issues
  • liferay-ga33-ce-743-known-issues
  • liferay-ga34-ce-743-known-issues
  • liferay-ga35-ce-743-known-issues
  • liferay-ga36-ce-743-known-issues
  • liferay-ga4-ce-743
  • liferay-ga5-ce-743
  • liferay-ga6-ce-743
  • liferay-ga7-ce-743
  • liferay-ga8-ce-743
  • liferay-ga9-ce-743
  • liferay-u1-dxp-7413
  • liferay-u2-dxp-7413
• Fix Priority: 4
• QA Test Name:
  • com.liferay.account.retriever.test.AccountUserRetrieverWhenSearchingAccountRoleUsersTest
  • com.liferay.user.associated.data.test.BaseModelUADDisplayTest
• QA Test Score: 10

Oracle 19.3 error:

 ERROR [com.liferay.user.associated.data.test-executor-thread][JDBCExceptionReporter:234] ORA-00932: inconsistent datatypes: expected - got CLOB
     [exec] 
     [exec] 05:15:19,893 ERROR [com.liferay.user.associated.data.test-executor-thread][BasePersistenceImpl:588] Caught unexpected exception
     [exec] org.hibernate.exception.SQLGrammarException: could not execute query
     [exec] 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
     [exec] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
     [exec] 	at org.hibernate.loader.Loader.doList(Loader.java:2545)
     [exec] 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
     [exec] 	at org.hibernate.loader.Loader.list(Loader.java:2271)
     [exec] 	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
     [exec] 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
     [exec] 	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
     [exec] 	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:140)
     [exec] 	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:126)
     [exec] 	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:499)
     [exec] 	at com.liferay.portal.service.base.LayoutLocalServiceBaseImpl.dynamicQuery(LayoutLocalServiceBaseImpl.java:219)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice$LayoutLocalServiceStagingInvocationHandler._invoke(LayoutLocalServiceStagingAdvice.java:832)
     [exec] 	at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice$LayoutLocalServiceStagingInvocationHandler.invoke(LayoutLocalServiceStagingAdvice.java:688)
     [exec] 	at com.sun.proxy.$Proxy68.dynamicQuery(Unknown Source)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
     [exec] 	at com.sun.proxy.$Proxy732.dynamicQuery(Unknown Source)
     [exec] 	at com.liferay.portal.kernel.service.LayoutLocalServiceWrapper.dynamicQuery(LayoutLocalServiceWrapper.java:554)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
     [exec] 	at com.sun.proxy.$Proxy733.dynamicQuery(Unknown Source)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
     [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
     [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
     [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
     [exec] 	at com.sun.proxy.$Proxy68.dynamicQuery(Unknown Source)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest$TestLayoutUADDisplay.doGetRange(BaseModelUADDisplayTest.java:412)
     [exec] 	at com.liferay.user.associated.data.display.BaseModelUADDisplay.search(BaseModelUADDisplay.java:131)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest._assertOrder(BaseModelUADDisplayTest.java:325)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest._assertOrder(BaseModelUADDisplayTest.java:312)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest.testOrder(BaseModelUADDisplayTest.java:89)
     [exec] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$3.evaluate(TestExecutorRunnable.java:353)
     [exec] 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:237)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:316)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
     [exec] 	at java.lang.Thread.run(Thread.java:745)
     [exec] Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
     [exec] 
     [exec] 	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
     [exec] 	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
     [exec] 	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
     [exec] 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
     [exec] 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
     [exec] 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
     [exec] 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
     [exec] 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
     [exec] 	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
     [exec] 	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
     [exec] 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
     [exec] 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
     [exec] 	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
     [exec] 	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
     [exec] 	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
     [exec] 	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
     [exec] 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
     [exec] 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
     [exec] 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
     [exec] 	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
     [exec] 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
     [exec] 	at org.hibernate.loader.Loader.doList(Loader.java:2542)
     [exec] 	... 66 more

 

BD2 11.1 error:

ERROR [com.liferay.user.associated.data.test-executor-thread][JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-134, SQLSTATE=42907, SQLERRMC=DESCRIP19_13_0_, DRIVER=4.24.92
     [exec] 05:34:01,965 ERROR [com.liferay.user.associated.data.test-executor-thread][JDBCExceptionReporter:234] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-134;42907;DESCRIP19_13_0_, DRIVER=4.24.92
     [exec] 05:34:01,965 ERROR [com.liferay.user.associated.data.test-executor-thread][BasePersistenceImpl:588] Caught unexpected exception
     [exec] org.hibernate.exception.SQLGrammarException: could not execute query
     [exec] 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
     [exec] 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
     [exec] 	at org.hibernate.loader.Loader.doList(Loader.java:2545)
     [exec] 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
     [exec] 	at org.hibernate.loader.Loader.list(Loader.java:2271)
     [exec] 	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
     [exec] 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
     [exec] 	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
     [exec] 	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:140)
     [exec] 	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:126)
     [exec] 	at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:499)
     [exec] 	at com.liferay.portal.service.base.LayoutLocalServiceBaseImpl.dynamicQuery(LayoutLocalServiceBaseImpl.java:219)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice$LayoutLocalServiceStagingInvocationHandler._invoke(LayoutLocalServiceStagingAdvice.java:832)
     [exec] 	at com.liferay.portal.service.impl.LayoutLocalServiceStagingAdvice$LayoutLocalServiceStagingInvocationHandler.invoke(LayoutLocalServiceStagingAdvice.java:688)
     [exec] 	at com.sun.proxy.$Proxy68.dynamicQuery(Unknown Source)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
     [exec] 	at com.sun.proxy.$Proxy750.dynamicQuery(Unknown Source)
     [exec] 	at com.liferay.portal.kernel.service.LayoutLocalServiceWrapper.dynamicQuery(LayoutLocalServiceWrapper.java:554)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
     [exec] 	at com.sun.proxy.$Proxy751.dynamicQuery(Unknown Source)
     [exec] 	at sun.reflect.GeneratedMethodAccessor1433.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
     [exec] 	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
     [exec] 	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
     [exec] 	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
     [exec] 	at com.sun.proxy.$Proxy68.dynamicQuery(Unknown Source)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest$TestLayoutUADDisplay.doGetRange(BaseModelUADDisplayTest.java:412)
     [exec] 	at com.liferay.user.associated.data.display.BaseModelUADDisplay.search(BaseModelUADDisplay.java:131)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest._assertOrder(BaseModelUADDisplayTest.java:325)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest._assertOrder(BaseModelUADDisplayTest.java:312)
     [exec] 	at com.liferay.user.associated.data.test.BaseModelUADDisplayTest.testOrder(BaseModelUADDisplayTest.java:89)
     [exec] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$3.evaluate(TestExecutorRunnable.java:353)
     [exec] 	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$2.evaluate(AbstractTestRule.java:99)
     [exec] 	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable$1.evaluate(TestExecutorRunnable.java:237)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at com.liferay.portal.kernel.test.rule.AbstractTestRule$1.evaluate(AbstractTestRule.java:59)
     [exec] 	at org.junit.rules.RunRules.evaluate(RunRules.java:20)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable._execute(TestExecutorRunnable.java:316)
     [exec] 	at com.liferay.arquillian.extension.junit.bridge.server.TestExecutorRunnable.run(TestExecutorRunnable.java:95)
     [exec] 	at java.lang.Thread.run(Thread.java:745)
     [exec] Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-134, SQLSTATE=42907, SQLERRMC=DESCRIP19_13_0_, DRIVER=4.24.92
     [exec] 	at com.ibm.db2.jcc.am.b6.a(b6.java:810)
     [exec] 	at com.ibm.db2.jcc.am.b6.a(b6.java:66)
     [exec] 	at com.ibm.db2.jcc.am.b6.a(b6.java:140)
     [exec] 	at com.ibm.db2.jcc.am.k3.c(k3.java:2817)
     [exec] 	at com.ibm.db2.jcc.am.k3.d(k3.java:2801)
     [exec] 	at com.ibm.db2.jcc.am.k3.a(k3.java:2227)
     [exec] 	at com.ibm.db2.jcc.am.k4.a(k4.java:8098)
     [exec] 	at com.ibm.db2.jcc.t4.ab.i(ab.java:205)
     [exec] 	at com.ibm.db2.jcc.t4.ab.b(ab.java:96)
     [exec] 	at com.ibm.db2.jcc.t4.p.a(p.java:32)
     [exec] 	at com.ibm.db2.jcc.t4.av.i(av.java:150)
     [exec] 	at com.ibm.db2.jcc.am.k3.al(k3.java:2196)
     [exec] 	at com.ibm.db2.jcc.am.k4.bq(k4.java:3702)
     [exec] 	at com.ibm.db2.jcc.am.k4.bx(k4.java:3839)
     [exec] 	at com.ibm.db2.jcc.am.k4.a(k4.java:613)
     [exec] 	at com.ibm.db2.jcc.am.Connection.prepareStatementX(Connection.java:2528)
     [exec] 	at com.ibm.db2.jcc.am.Connection.prepareStatementX(Connection.java:2479)
     [exec] 	at com.ibm.db2.jcc.am.Connection.prepareStatement(Connection.java:1005)
     [exec] 	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:312)
     [exec] 	at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
     [exec] 	at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
     [exec] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [exec] 	at java.lang.reflect.Method.invoke(Method.java:498)
     [exec] 	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:385)
     [exec] 	at com.sun.proxy.$Proxy9.prepareStatement(Unknown Source)
     [exec] 	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
     [exec] 	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
     [exec] 	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
     [exec] 	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
     [exec] 	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
     [exec] 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
     [exec] 	at org.hibernate.loader.Loader.doList(Loader.java:2542)
     [exec] 	... 66 more