Problems with OracleInput, NullPointerException and getSessionTimeZone

[cox]

Hi Everyone!
I'm having an error when trying to run my Job, that says NullPointerException in tOracleInput_1.



If I go to the code where the error seems to be generating (line 20056), it looks like the getSessionTimeZone it's the problem in here.


The first thing that I did was to look if there was a null value inside the tOracleInput_1 table, but it wasn't.


Talend Version: 5.6.3 (Java)
OS: Windows 7

I hope that you can really give a hand with this!
Thanks.

[cox]

Hey guys, I think I solved it.
tOracleInput was trying to load the table first than anything so tOracleConnection_2 wasn't started yet. Changing tOracleInput to tOracleConnection_1 solved this problem.
The error message was totally different to the real problem, so I hope that if anyone has this problem this post could be helpfull.

Thanks!

[Anonymous]

Whow what a dangerous design! Why your tOracleInput_1 does not use its own connection? It simply does not make sense here to use a separate connection for it - not as far as I can see in your design. 
But your description of your problem and your own analysis was pretty good.

[cox]

jlolling wrote:
Whow what a dangerous design! Why your tOracleInput_1 does not use its own connection? It simply does not make sense here to use a separate connection for it - not as far as I can see in your design. 
But your description of your problem and your own analysis was pretty good.

I took this old design and added new components, that's why turned into a dangerous design.
This job is actually looking for files in differents folders and then reads every row which then goes to the database.

After all this problem, I've changed the connections of tOracleRow_1 and tOracleInput_1 to they own connections.

Thanks Jlolling!