topic Re: Specifying a programName to Oracle JDBC connections using tOracleInput in Talend Studio

Specifying a programName to Oracle JDBC connections using tOracleInput

Anonymous — Sat, 16 Nov 2024 13:42:29 GMT

Hi,
I 'm currently trying to set the programName parameter to an Oracle JDBC connection using the tOracleInput component.
The goal is to let an Oracle database identify my program when it connects to it.
Is there any way to achieve this using a talend component ?
I know that this can be done with a tMSSqlInput component by setting the "Additional JDBC parameters" (in Advanced Settings).
I'm using TOS 2.4.2 under Windows SP2. The generation code is Java for my batch.
Thanks,

Re: Specifying a programName to Oracle JDBC connections using tOracleInput

Anonymous — Mon, 02 Nov 2009 06:19:35 GMT

Hello
I don't understand you well, what do you point'programName' here? The job name? project name?
Best regards
shong

Re: Specifying a programName to Oracle JDBC connections using tOracleInput

Anonymous — Mon, 02 Nov 2009 07:21:17 GMT

Hi Shong,
What i'm trying to do is to tag my JDBC connection to let my database know which program is querying it (by setting a custom parameter to it).
I've found an article that explains how to do it using Java ( http://www.magpiebrain.com/blog/2006/05/09/specifying-a-program-name-in-oracle-jdbc-connections/) but I wondered if there was an easy way to do it using talend components.
Thanks,