Tibco SQLException -

Tibco SQLException -

i encountering error 1 time again , 1 time again in tibco code.somebody please tell how solve error using tibco 5.7.3.

jdbc error reported: (sqlstate = hy000) - java.sql.sqlexception: [tibcosoftwareinc][sqlserver jdbc driver]object has been closed."

when jdbc query activity configured query in subset mode, resultset object kept in engine subsequent iterations. typically resultset object closed , cleared engine if there no more info left. however, maintain in mind default connection idletimeout set 5 minutes. means after 5 minutes of no activity connection released. if wait longer idletimeout value retrieve subsequent subsets incur exception since connection has been closed , hence resultset no longer available.

resolution: set engine.dbconnection.idletimeout higher value in businessworks engine tra file, say, 20 minutes connection can remain idle without getting released next iterations example: engine.dbconnection.idletimeout=20. more details on setting please see list of available custom engine properties.

tibco