All Apps and Add-ons

How to configure Splunk DB Connect 3.3 to connect to Oracle OCI DB?


Trying to connect to Oracle 18c db, I have followed the instructions in the troubleshooting guide "Connect Splunk DB Connect to Oracle Wallet environments using ojdbc8" without any luck.

I'm getting the following error "[dw-58 - POST /api/connections/status] ERROR io.dropwizard.jersey.errors.LoggingExceptionMapper - Error handling a request: 2a01705792fdb22a java.lang.NullPointerException: null
at com.splunk.dbx.connector.logger.AuditLogger.replace(
at com.splunk.dbx.connector.logger.AuditLogger.error(" regardless of what I put in the connection string which leads me to believe that the message is just disguising the real issue. I have the logs set to "DEBUG" but no information other than the null pointer exception mentioned above. I am able to connect to the DB from the server using sqlplus and show the connection string using tnsping.


Even i am facing the same issue when i am trying to establish a connection between MSSQL database and splunk HF.

can anyone help

0 Karma


I have same problem when using the SQL Driver (

2020-04-19 14:13:12.856 +0000  [dw-57 - POST /api/connections/status] ERROR io.dropwizard.jersey.errors.LoggingExceptionMapper - Error handling a request: 103747235521985d
java.lang.NullPointerException: null
    at com.splunk.dbx.connector.logger.AuditLogger.replace(
    at com.splunk.dbx.connector.logger.AuditLogger.error(
    at com.splunk.dbx.server.api.service.database.impl.DatabaseMetadataServiceImpl.getStatus(
    at com.splunk.dbx.server.api.service.database.impl.DatabaseMetadataServiceImpl.getConnectionStatus(
    at com.splunk.dbx.server.api.resource.ConnectionResource.getConnectionStatusOfEntity(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(
    at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(

I just can't the driver to appear as installed with db_connection_types.conf :

displayName = LensesJdbc
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = io.lenses.jdbc4.LensesDriver
jdbcUrlFormat = jdbc:lsql:kafka:http://<host>:<port>
testQuery = SELECT amount FROM cc_payments LIMIT 1
database = na
0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!