topic Re: Connection reuse in tJava in Talend Studio

Connection reuse in tJava

TRF — Sat, 16 Nov 2024 09:35:29 GMT

Hi,
Does anyone know if it is possible to reuse a db connection (issued from tOracleConnection, tSalesforceConnection or other) in a tJava family component, and, if yes, how?
Thank you.

Re: Connection reuse in tJava

cterenzi — Fri, 23 Jun 2017 22:58:39 GMT

It should be possible. If you highlight your connection component and switch to code view, you can find where the connection object is created and configured. It is put on the globalMap for use elsewhere, so if you examine the code of another database component that references the connection, you'll see how the connection retrieved and can mimic the code.

java.sql.Connection conn_tPostgresqlCommit_1 = (java.sql.Connection) globalMap.get("conn_tPostgresqlConnection_2");
if (conn_tPostgresqlCommit_1 != null && !conn_tPostgresqlCommit_1.isClosed()) { ...

Re: Connection reuse in tJava

TRF — Fri, 23 Jun 2017 23:13:42 GMT

Thank you very much @cterenzi, I'll try as soon as possible and let you know.

Re: Connection reuse in tJava

Anonymous — Sat, 24 Jun 2017 00:48:23 GMT

It appears I am a bit late to the party here, but I wrote a mini tutorial on this a while ago.....
https://www.rilhia.com/quicktips/quick-tip-dynamically-change-db-connection

Re: Connection reuse in tJava

TRF — Sat, 24 Jun 2017 11:49:45 GMT

Thank you @rhall. Two trails better than one. I'll check that of course and let you know.