Splunk DB Connect: Why am I receive an Oracle connection error "error occurred at recursive SQL level 1 ORA-01882: timezone region not found"?

[nuaraujo]

Hello all,

I am using Splunk DB connect v3.0.1, and I am trying to connect to an Oracle database.

I am using jdk1.8.0_121, as required, and in my JVM options(server.vmopts) I have

-Duser.timezone="UTC" -Ddw.server.applicationConnectors[0].port=9998

When I go to Data Lab -> SQL Explorer, I am able to choose the Oracle connection, I can choose the Schema, and I can see the list of tables. However, when i click in one of the table names( select * from SCHEMA.TABLE_NAME) I always get the following error:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

Can someone help me to solve this issue?

Thanks in advance.

[jcoates_splunk · Accepted solution]

does this help? https://community.oracle.com/thread/3826927

[nuaraujo]

Thanks jcoates.

You post redirected me to the real problem. My DB version is 11.2.0.3.0 , and I was using ojdbc7.jar. I changed the driver to ojdbc6.jar, and it worked without issues.

Thank you for your help.