I have a Talend job (TOS v3.1.2) which retrieves data from a bunch of sybase database tables, does some minimal fomatting and writes them to an XML file. At times i get the following exception when this job runs:
java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc3.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
I know the sometimes the query takes more than a hour to retrieve results, but any idea on what may be causing this exception or is there a way to prevent it ?
Thanks for the help.
-Prasad
