Getting Data In

JdbcUrl for firebird parsed wrong?

graether
Path Finder

Hi,

It seems that I can connect to a firebird database, but run into issue JDBC-446
http://tracker.firebirdsql.org/browse/JDBC-446.
The solution according to the firebird release notes
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/3.0.0/release_notes.html#c...
is to use a jdbcURL in the db_connections.conf:

jdbc:firebirdsql:host/3050:D:/aQrate_Data/DB/MYQLOG?encoding=UTF8, "SYSDBA", "masterkey"

Now somehow it seems that some parser maybe in splunk set the encoding to UTF8, "SYSDBA", "masterkey"
because the message is now:

No valid encoding definition for Firebird encoding UTF8, "SYSDBA", "masterkey" and/or Java charset null

Is there a workaround to set the encodings somewhere else in a splunk db connect apps config file?

Thanks -Gerd

0 Karma

graether
Path Finder

Hi Shyngys,
if I remember correctly I got the connection to work, by ignoring the issue and clicked "Save anyway" in Splunk. I also figured out that the issue might related to missing JDBC Compatibility Test Suite (CTS): „the separator string, always null because catalogs are not supported by database server (see JDBC CTS for details).“, siehe https://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.4/docs/org/firebirdsql...

0 Karma

Shyngys_Bolatbe
Engager

now I have such a mistake java.lang.NullPointerException: null value in entry: db_catalog_separator=null
can I still extract the tables with this error or not if Yes how to do it?

0 Karma

graether
Path Finder

just try it after "save anyway". I was able to extract tables.

0 Karma

Shyngys_Bolatbe
Engager

did you succeed with the firebird connection?

0 Karma
Get Updates on the Splunk Community!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...