JDBC adapter

[Former Member]

Hello,

I am using JDBC recevier adapter and getting followng exception.

java.sql.SQLException: [SQL0666] Estimated query processing time 13766 exceeds limit 8000.

My questions is how do I setQueryTimeout in communication channel.

Thank you,

Balaji

[prateek · Accepted solution]

I dont think this would be possible in communication channel.

Instead, u could modify the settings at the JDBC end. There u could modify the attributes of the query

e.g CHGQRYA

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/cl/chgqrya.htm

Regards,

Prateek