I've got this in local/db_connection_types.conf
[local]
[unidata]
displayName = Unidata
serviceClass = com.splunk.dbx2.UniJDBCDriver
jdbcUrlFormat = jdbc:rs-u2://
jdbcDriverClass = com.rs.u2.jdbc.UniJDBCDriver
What should the serviceClass be? Can I just make it up?
When I try to set one up, I get an error that just says com.splunk.dbx2.UniJDBCDriver
with no details
dbx2.log says:
06/11/2015 13:45:08 [WARNING] [health.py] com.splunk.dbx2.UniJDBCDriver
06/11/2015 13:45:08 [ERROR] [init.py] com.splunk.dbx2.UniJDBCDriver
Traceback (most recent call last):
File "/opt/splunk/lib/python2.7/site-packages/splunk/rest/init.py", line 184, in dispatch
methodOutput = method()
File "/opt/splunk/etc/apps/splunk_app_db_connect/bin/dbinfo.py", line 39, in handle_GET
return self.get_catalogs(conn)
File "/opt/splunk/etc/apps/splunk_app_db_connect/bin/health.py", line 206, in wrap_it
return w.logIt (self, f, l, *args, **kwargs)
File "/opt/splunk/etc/apps/splunk_app_db_connect/bin/health.py", line 177, in logIt
if err : raise err
AvroRemoteException: com.splunk.dbx2.UniJDBCDriver
06/11/2015 13:45:08 [DEBUG] [init.py] simpleRequest < server responded status=200 responseTime=0.9807s
06/11/2015 13:45:08 [DEBUG] [health.py] Health logging is ON.
06/11/2015 13:45:08 [DEBUG] [rh_connections.py] com.splunk.dbx2.UniJDBCDriver
06/11/2015 13:45:08 [WARNING] [health.py] com.splunk.dbx2.UniJDBCDriver
06/11/2015 13:45:08 [ERROR] [rh_connections.py] exception com.splunk.dbx2.UniJDBCDriver
Any ideas ?
-- worthy of note:
unijdbc.jar isn't good enough on its own, it needs some .class files in a local dir called asjava - so I'm not sure where to put those on my linux Search Head.
you should use the com.splunk.dbx2.DefaultDBX2JDBC
Unfortunately, you cannot determine that info in DB Connect. In DBVisualizer, once you have created a new driver (under Driver Manager), you should be able to see the driver class info., which you then can use in DB Connect.
I assume you meant the driverClass. I have that, though dbviz looks EXTRAORDINARY! thanks for the tip:)
I need the serviceClass - which is a splunk setting of some sort.
to Splunk support I go 🙂