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.
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.