IntelliJ data source connection with Firebird database

user_7007254 0
Viewed 149

I am unable to make DataSource connection with "Firebird" using IntelliJ IDEA (Java 11). I have successfully connected with Firebird example db using ISQL Tool (Command Line Interface) Success Connection

Even after going through multiple blogs, it's not working, I still need guidance. Please advise.

Data Source IntelliJ

I get following error:

Error

DBMS: Firebird 3.0 (ver. WI-V3.0.10.33601)
Case sensitivity: plain=upper, delimited=exact
Driver: Jaybird JCA/JDBC driver (ver. 4.0.2, JDBC4.3)
Ping: 78 ms (keep-alive query results in error)

WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE.
[42000][335544851] Dynamic SQL Error; SQL error code = -104; Unexpected end of command - line 1, column 8 [SQLState:42000, ISC error code:335544851].
jaybird firebird database-connection intellij-idea
2 Answers

The problem is caused by IntelliJ executing a "keep-alive query" when testing the connection, but the default configuration for the Firebird driver doesn't have a keep-alive query. It seems that IntelliJ executes this query unconditionally, even if it is an empty string. This causes Firebird to return an error, because an empty string is not a valid statement.

To solve this, go to the "Drivers" tab of the "Data Sources and Drivers" screen, select "Firebird" (under "Basic Support"), and on the options tab, enter the "Keep-alive query" select 1 from rdb$database.

As an aside, you can make the warning about the connection character set go away by explicitly configuring a connection character set (property charSet) on the "Advanced" tab.

user_4668620

Database is accessible using IntelliJ IDEA, and I am able to access tables using SQL. Test connection was never successful, but it still connects and works fine. I ignored the test connection and resolved it by using following data source connection string:

jdbc:firebirdsql://localhost:3050/C:/ProgramFiles/Firebird/Firebird_3_0/examples/empbuild/employee.fdb
user_70072540
Related