tOracleInput error getSessionTimeZone()

[AlessandroCic]

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

[Anonymous]

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

[AlessandroCic]

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

The destination is to Oracle 8 Db


Best regards
Alessandro

[Anonymous]

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

[AlessandroCic]

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

[vapukov]

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