topic tOracleConnection - JDBC Parameters & Shared DB Connection in Talend Studio

tOracleConnection - JDBC Parameters & Shared DB Connection

Anonymous — Wed, 16 Jan 2019 17:30:15 GMT

Hi Team

I need to make a connection (and then share this one with the other jobs) to an oracle db that requires a value in v$session.program

I tried to set up my component (tOracleConnection) as follows:

But it valorizes the v$session.program field only if I remove the check on "Use or register a shared DB Connection"

Please help me out with your answer

Thanks in Advance

Simone

Re: tOracleConnection - JDBC Parameters & Shared DB Connection

akumar2301 — Wed, 16 Jan 2019 21:42:27 GMT

which Talend version you are using ?

Re: tOracleConnection - JDBC Parameters & Shared DB Connection

Anonymous — Wed, 16 Jan 2019 21:51:15 GMT

I'm using 6.3.1 but I tried the same thing on the last version and I got the same result.

Thanks

Re: tOracleConnection - JDBC Parameters & Shared DB Connection

akumar2301 — Wed, 16 Jan 2019 22:22:39 GMT

You are right .It looks like a component issue.I checked the routines.system.SharedDBConnection class code , it does not consider JDBC advance properties while getting JDBC connection .

Others , please verify if it is expected behaviors .