- Apps and Add-ons
- :
- All Apps and Add-ons
- :
- Splunk DB Connect : Why am I getting this error co...
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Splunk DB Connect : Why am I getting this error connecting to Oracle DB?
Hello,
I am trying to connect Splunk to an Oracle database using DB Connect version 3.1.3.
When setting up the connection, I get the following error when trying to save:
Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the main URL sections.
I have followed the instructions to setup the Oracle driver in the documentation, and have the ojdbc7.jar file from Oracle in my drivers directory.
I've tried manually editing the JDBC string using the suggestion found here; https://answers.splunk.com/answers/528512/splunk-db-connect-how-to-connect-to-oracle-db.html?utm_sou... in the second comment.
Anyone else run into this problem and find a solution?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I had the same problem in Splunk 7.3.4.2 and DB-Connect 3.2.0
I tried to made a new Oracle-DB-Connection and got mySQL error message. When I removed mySQL driver from DB-Connect I got the correct error message from Oracle jdbc driver.
As suggested here it seems to be a bug in the mySQL jdbc driver, so I updated this driver from version 8.0.11 to 8.0.19 and this seems to solve the issue.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The "mysql" part of the exception leads to me believe that you might be choosing the wrong type of DB when creating the connection.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I noticed that as well, but I am selecting Oracle Service from the database connection type and I have the Oracle drivers installed according to the DB connect app.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try with 3.1.2? With 3.1.3 I traced a lot of unresolved issues.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Working on this today, I was able to get some different errors regarding TNS listeners not working using DB Connect 3.1.2.
When I removed the jtds.jar file from the drivers folder in db connect I was finally seeing those errors.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you need 3.1.2, send me an email and I'll share a private link with you.
andrea.corvini@gmail.com
With the last message you mean you have different errors with 3.1.2?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a link to download the previous version? I can't seem to find the link on Splunkbase.
Introducing the 2024 SplunkTrust!
Introducing the 2024 Splunk MVPs!
Splunk Custom Visualizations App End of Life
