One Star Nam
One Star

Specifying a programName to Oracle JDBC connections using tOracleInput

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,
2 REPLIES
Community Manager

Re: Specifying a programName to Oracle JDBC connections using tOracleInput

Hello
I don't understand you well, what do you point'programName' here? The job name? project name?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star Nam
One Star

Re: Specifying a programName to Oracle JDBC connections using tOracleInput

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,