The error we are getting:
Exception: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:netezza://10.121.10.232:5480/AMBER_DB
2016-10-05T10:43:10-0400 [ERROR] [rh_connections.py], line 225: exception java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:netezza://10.121.10.232:5480/AMBER_DB
The Netezza stanza in the connection_type.conf
[Netezza]
displayName = Netezza
serviceClass = com.splunk.dbx2.postgres.PostgresJDBC
jdbcUrlFormat = jdbc:netezza://:/
jdbcDriverClass = org.netezza.Driver
The driver is in the
/home/splunk/etc/apps/splunk_app_db_connect/bin/lib/nzjdbc.jar
Successfullly tested the jdbc using java command.
Any insight anyone can offer is greatly appreciated.
Thanks,
-WD
I fixed the problem as follows:
I upgraded from jre7 to jre8 (you're probably already correctly on jre8), got the same error message in the original question here except with sqlserver, tried reloading drivers, still got the same message. Then I looked in /home/splunk/etc/apps/splunk_app_db_connect/bin/lib and the only driver was rpcserver-all.jar. I downloaded sqljdbc42.jar from Microsoft (https://www.microsoft.com/en-us/download/details.aspx?id=11774, again, this was for my case using sqlserver), and then reloaded drivers, and restarted the RPC server again, and that fixed the error! (I'm getting a separate error now, but fixed the error message that this question refers to)
we have the similar issue with Splunk 6.5.1 and Splunk DB Connect v.2.4.0. We can connect and make queries to Netezza but occasionally we get the same issue. To solve it we have to run the "reload" button in the Settings-Drivers tab.
Our config in db_connection_type.conf is slightly different:
[netezza]
displayName = IBM Netezza
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:netezza://:/
jdbcDriverClass = org.netezza.Driver
database = testDB
port = 5480
testQuery = SELECT 1 AS test
our driver file is "nzjdbc3.jar".
We're seeing the same issue. When in the UI, the validation fails when loading the driver. The same workaround of going to the Settings and Reloading the drivers temporarily allowing the connection to be completed or a query setup.
any idea on how to call this "Reload" maybe via REST API? We could the automate the workaround via alert+script! We already have an alert to warn us of this error...
that looks like Java won't load the driver, could be incompatible, or it could be a permissions thing
I am having the same issue. Wouild really appreciate any help...
java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:netezza://ip:port/database
No insight but I have the same problem, different JDBC driver. I seem to be able to make JDBC work in other tools, but I have failed to get one added into Splunk (6.5.1) yet.
-Todd