Connecting Talend Studio to Firebird DB

[RMotta2408]

Hello everyone,

I'm trying to create a Metadata connection to Firebird DB. It keeps giving me the following error:

I can connect to this database using other tools like FlameRobin and DBeaver, without any problems. I'm able to create/drop/insert/update/delete tables with no problems at all.

But not with Talend Studio.

If, instead of trying to create a Metadata connection, I try to connect to it using the tFirebirdConnection or tFirebirdInpit  components, I get the following error:

Exception in component tDBConnection_1 (Firebird_Connection)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544421. connection rejected by remote interface
Reason: connection rejected by remote interface

Can anyone please help me with this problem?

Thank you so much,
Rui

[RMotta2408 · Accepted solution]

Hello everybody,

So, a little update. 

I used the tLibraryLoad component before connecting to the database (tFirebaseConnection) and I used it to load Jaybird v5. The component asks for version 2 (or 2.1) as the default version.

The Job looks like this and it works:

But still, there is this warning message:

WARNING: WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE

Does anyone know how to address this?

Thanks,
Rui

[Xiaodi_Shi]

Hello @RMotta2408 

Here is a related topic about connecting to firebird.

https://community.qlik.com/t5/Design-and-Development/Connect-to-Firebird-4/m-p/2330339

Hope it helps for your warning issue.

Best regards

Sabrina

[RMotta2408]

Hello Sabrina,

Thanks for the reply. 

I followed the solution provided in the link you sent me and I now get the following message, even though the Job runs ok.

SEVERE: Can't register plugin (skipping): java.lang.IllegalArgumentException: Duplicate JDBC URL pattern detected: URL jdbc:firebirdsql:local:, plugin LOCAL, other plugin NATIVE; see debug level for stacktrace

Just to be on the same page, what I did was add the lines below to the firebird.conf file:

AuthServer = Legacy_Auth

AuthClient = Legacy_Auth

UserManager = Legacy_UserManager

WireCrypt = Disabled

Rui

[dvojnik1]

We have upgraded to firebird 5 from 2.5. adding to firebird.conf:

AuthServer = Legacy_Auth
AuthClient = Legacy_Auth
UserManager = Legacy_UserManager
WireCrypt = Disabled

helps when connecting with talend, but Dbeaver or other apps that use new driver stop working. 

Doing this:https://help.talend.com/en-US/studio-user-guide/8.0-R2024-05/upgrading-database-jdbc-driver-by-custo...

does not work since module is not changed to jaybird-4.0.0.java8.jar instead it stayed jaybird-full-2.1.1.jar

[Xiaodi_Shi · Accepted solution]

Hello,

Regarding of this documentation on talend help center, the official support FireBird DB version is 2.1(old 2.1 driver is still in use).

https://help.talend.com/en-US/studio-user-guide/8.0-R2024-07/supported-systems-databases-and-busines...

Please try to use the generic JDBC (which doesn't have still official support for Firebird 5, but you can setup the jar you need)

https://firebirdsql.org/en/jdbc-driver/#jaybird5

https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#connecting-to-fir...

Hope it will help.

Best regards

Sabrina

[dvojnik1]

Works like a charm!

Much appreciated, thank you very much!

[Xiaodi_Shi]

Hello,

Feel free to let me know if there is any further help we can give.

Best regards

Sabrina