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!

The Payment Operations Wake-Up Call: Why Financial Institutions Can't Afford ...

The same scenario plays out across financial institutions daily. A payment system fails at 11:30 AM on a busy ...

Make Your Case: A Ready-to-Send Letter for Getting Approval to Attend .conf25

Hello Splunkers, Want to attend .conf25 in Boston this year but not sure how to convince your manager? We've ...

Community Spotlight: A Splunk Expert's Journey

In the world of data analytics, some journeys leave a lasting impact not only on the individual but on the ...