topic tOracleInput error getSessionTimeZone() in Talend Studio

tOracleInput error getSessionTimeZone()

AlessandroCic — Fri, 24 Mar 2017 16:54:08 GMT

Hi forum
I have a curious problem with the component tOracleInput.
If in my job I use it in a simply mode tOracleInput->tLogRow or tFileOutputExcel it works!

If I add some other component like this (example)

I have the error:
"The method setSessionTimeZone(String) is undefined for the type OracleConnection"

I can also see the error in this part of auto-generated code:

I'm using Talend 6.2.1
How can I to resolve this problem?
Regards
Alessandro

Re: tOracleInput error getSessionTimeZone()

Anonymous — Mon, 27 Mar 2017 08:25:53 GMT

Hi Alessandro,
Are you using the same oracle drivers for your source oracle DB and target DB?
Best regards
Sabrina

Re: tOracleInput error getSessionTimeZone()

AlessandroCic — Mon, 27 Mar 2017 08:44:36 GMT

Hi
No, they are two different Oracle DB
The source is an Oracle 10

The destination is to Oracle 8 Db

Best regards
Alessandro

Re: tOracleInput error getSessionTimeZone()

Anonymous — Mon, 27 Mar 2017 08:57:50 GMT

Hi,
We suppose that the problem is due to the use of many oracle drivers in the same job.
Best regards
Sabrina

Re: tOracleInput error getSessionTimeZone()

AlessandroCic — Mon, 27 Mar 2017 10:15:25 GMT

Ok, I understand.
I will try to separate the job.
At first time I extract the data from Oracle 10 in a different structure (eg. Excel).
Then I re-import them into Oracel 8.
Regards
Alessandro

Re: tOracleInput error getSessionTimeZone()

vapukov — Mon, 27 Mar 2017 10:56:46 GMT

just as advice - use csv as simplest (fastest) format as well as not limited as Excel