topic Re: Connecting Talend Studio to Firebird DB in Talend Studio

Connecting Talend Studio to Firebird DB

RMotta2408 — Thu, 25 Jan 2024 15:54:45 GMT

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

Re: Connecting Talend Studio to Firebird DB

RMotta2408 — Fri, 26 Jan 2024 18:53:46 GMT

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

Re: Connecting Talend Studio to Firebird DB

Xiaodi_Shi — Mon, 29 Jan 2024 02:20:44 GMT

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

Re: Connecting Talend Studio to Firebird DB

RMotta2408 — Mon, 29 Jan 2024 11:56:29 GMT

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

Re: Connecting Talend Studio to Firebird DB

dvojnik1 — Tue, 27 Aug 2024 10:46:12 GMT

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-customizing-mvn-uri

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

Re: Connecting Talend Studio to Firebird DB

Xiaodi_Shi — Wed, 28 Aug 2024 02:29:32 GMT

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-business-applications-talend-components

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-firebird

Hope it will help.

Best regards

Sabrina

Re: Connecting Talend Studio to Firebird DB

dvojnik1 — Wed, 28 Aug 2024 11:22:51 GMT

Works like a charm!

Much appreciated, thank you very much!

Re: Connecting Talend Studio to Firebird DB

Xiaodi_Shi — Thu, 29 Aug 2024 01:18:34 GMT

Hello,

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

Best regards

Sabrina