All Apps and Add-ons

Splunk DB Connect 2: How to resolve error "The driver class net.sourceforge.jtds.jdbc.Driver is not found" to connect to Microsoft SQL?

robertlabrie
Path Finder

Splunk 6.1.2 running on Windows 2012 R1 x64. I've been using DBConnect 1 to connect to MS SQL, works fine, decided to try DBConnect 2 on a different forwarder. Says "The driver class net.sourceforge.jtds.jdbc.Driver is not found". This is new, didn't need a thing called jtds before, but ok, I go get the driver, I rummage around a little, I try putting the JRE in bin\lib and bin\lib\ext, no joy. The docs for jtds say "Being a type 4 driver, jTDS does not need any special installation. Just drop the jar file into your application's classpath and you're done." So I figured I was "done" but I guess I'm not. Anyone know how to make this work?

Thanks,
Rob

0 Karma
1 Solution

bwang_splunk
Splunk Employee
Splunk Employee

The jar files should be placed under splunk_app_db_connect/bin/lib.

View solution in original post

desax
Engager

The jar files should be placed under splunk_app_db_connect/drivers, and you should to reload the drivers page on GUI toinstall it

0 Karma

bwang_splunk
Splunk Employee
Splunk Employee

The jar files should be placed under splunk_app_db_connect/bin/lib.

behzad_341
New Member

I think it doesn't work because I did but still the problem and error exists

0 Karma

desax
Engager

The jar files should be placed under splunk_app_db_connect/drivers, and you should to reload the drivers page on GUI toinstall it

0 Karma

masterpiece
Engager

I have rpcserver-all.jar and sqljdbc4.jar in your said location, is something missing.

0 Karma

behzad_341
New Member

I did the same but the error message still exists: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:jtds:sqlserver...

0 Karma

neelu123
Explorer

Hi Team,
I have exactly the same issue instead of jtds , am using jdbc jar i.e. sqljdbc4.jar, I have place the jar inside splunk_app_db_connect/bin/lib path but while validating connection getting the below error.

java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:sqlserver://BDOW12VSQLADMIN:1433;databaseName=Splunktest

Can someone help me to resolve the issue, is there any thing I am missing while configuring.?

Regards,
Neelu

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...