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