How to resolve "[tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout"
Article ID: KB0072205
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 7.2.0 and above, 8.3.x and above |
Description
When connecting to DB2 for AS400, the below error could happen:
[tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout
[tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout
Issue/Introduction
How to resolve "[tibcosoftwareinc][DB2 JDBC Driver]Unsupported method: Statement.setQueryTimeout"
Environment
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 7.2.0 and above, 8.3.x and above
OS: All Supported Operating Systems
Resolution
The issue happens because DB2 for AS400 Database doesn't support Statement.setQueryTimeout() method.
Adding "QueryTimeout=-1" to the JDBC URL could resolve this issue.
When setting "QueryTimeout=-1", the query timeout functionality is disabled. The driver silently ignores calls to the Statement.setQueryTimeout() method.
Adding "QueryTimeout=-1" to the JDBC URL could resolve this issue.
When setting "QueryTimeout=-1", the query timeout functionality is disabled. The driver silently ignores calls to the Statement.setQueryTimeout() method.
Additional Information
https://docs.progress.com/zh-CN/bundle/datadirect-connect-jdbc-51/page/QueryTimeout_8.html#QueryTimeout_8
Feedback
Yes
No
Powered by
