DB Connect 2 and Firebird SQL

[dominiquevocat]

We wish to connect db connect 2 to a Firebird SQL Server

so far i tried

[firebird]
#see https://stackoverflow.com/questions/3424206/firebird-connection-with-java
displayName = Firebird SQL
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = org.firebirdsql.jdbc.FBDriver
supportedVersions = 4.0
jdbcUrlFormat = jdbc:firebirdsql://<host>:<port>/<database>?encoding=NONE&charSet=ISO-8859-1
jdbcUrlSSLFormat = jdbc:firebirdsql://<host>:<port>/<database>?encoding=NONE&charSet=ISO-8859-1
port = 3050
database = master

I do have some success but i do get

java.lang.NullPointerException: null value in entry: db_catalog_separator=null

Anyone did this before successfully

[hartley]

No we had to pay Splunk PS to create a specific version of DB Connect for us, which means we are now restricted to Splunk 3.1.1

[Shyngys_Bolatbe]

did you succeed with the firebird connection?

[hartley]

We did eventually but we had to pay Splunk PS to edit the source code and create a specific version just for us so we are now stuck on DB Connect 3.1.1 with no support. If we want to upgrade DB Connect, I suspect we will need to pay again to get the code updated.

[hartley]

I have just revisited this and get same error message. I then tried to use Data Lab - SQL Explorer and get 'Invalid database connection' when I select DB. I then ran Open In Search - and I got results back. So for me now looks clearly like a bug in DB Connect as running

| dbxquery query="select count(*) from LOG;" connection="TEST" - works from the Search Bar - but the DB Connect UI throws errors all the time when trying to use it

[dominiquevocat]

Yeah works but is no 100% clean. Still i can work on the usecase for now. Thanks!

[hartley]

I wonder if caused by this and the splunk code can not handle a null getting returned?

https://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.8/docs/org/firebirdsql...

I now need to see if I can hand craft a set of configs that work, would have preferred GUI