-
Bug
-
Resolution: Cannot Reproduce
-
Major
-
JDG 7.1.0 DR3
-
None
-
None
During testing database compatibility of JDG 7.1.0.DR3, I got errors when testing JPA cache store in library mode in EAP 6.4 and database Oracle 11g R2.
Link to the job that is failing (and it's stacktrace): https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/JDG/view/FUNC/job/jdg-func-db-compatibility/DATABASE=oracle11gR2,TEST=jpa-eap6,jdk=java18_default,label=%28RHEL5||RHEL6%29&&x86_64&&mem4G/128/console
Relevant part of the stacktrace
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-01882: timezone region not found
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
[java] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1018)
[java] at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:497)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
[java] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:433)
[java] at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:950)
[java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:639)
[java] at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662)
[java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
[java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:560)
[java] at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
[java] at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
[java] at org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:106)
[java] at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:40)
[java] at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:19)
[java] at org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:138)
[java] at
I have tried extensively to figure out the issue, but I wasn't able to reproduce it in DBAllocator with neither JDG 7.1.0.DR3 nor upstream Infinispan. Please note that this is the only combination failing with this issue, other cache stores work with Oracle 11g R2 just fine (jpa in EAP 7, jdbc store etc.), as well as the other databases (even just different Oracle DB) work with these tests.
I've run out of ideas, how to solve it, not sure, what the root cause might be.
