All Apps and Add-ons

Help with db connect custom jdbc connection

a212830
Champion

Hi,

I'm trying to add a new custom jdbc connection to DB Connect, version 3. When I go into the sql explorer and choose my connection, it says "invalid database connection". I got the jdbc driver class from the vendor, and for serviceClass, I entered "com.splunk.dbx2.DefaultDBX2JDBC", based upon another Splunk Answers entry. Is that entry valid? Anything else that I can look for? I am able to retrieve data using curl from this host.

0 Karma

sloshburch
Splunk Employee
Splunk Employee

I got that a lot when setting up a non-custom Postgress connection. It turned out the FTP of the driver/jar didn't go so well and was actually corrupted! Once we reuploaded we were in the clear.

Are you sure you put the driver in place as per the docs? Maybe toss a bit more details out here for us to mull over? Also, make sure the java install meets the requirements. There's been some shenanigans around this with Oracle changing terms on java.

0 Karma
Get Updates on the Splunk Community!

Extending Splunk AI Assistant for SPL to Splunk Enterprise customers!

Howdy Splunk Community! It’s an exciting day here at Splunk – Splunk AI Assistant for SPL version 1.3.0 is now ...

Developer Spotlight with Qmulos

Qmulos: Building a Next-Level Cybersecurity Business through Splunk Apps Qmulos started as a scrappy startup ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...