Kbase P123002: Optional feature not implemented when using webMethods connected to a Progress database via JDBC.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/9/2008 |
|
Status: Unverified
SYMPTOM(s):
Optional feature not implemented when using webMethods connected to a Progress database via JDBC.
Failure message displays on the screen
[DataDirect][ODBC OPENEDGE driver]Optional feature not implemented.
FACT(s) (Environment):
SQL code is being run from webMethods
The same SQL code can be run successfully from SQL Explorer
OpenEdge 10.0B
All Supported Operating Systems
CHANGE:
Upgraded webMethods JDBC Adapter from 6.03 to 6.50
CAUSE:
The new webMethods JDBC Adapter sends a parameter called Query Timeout to the JDBC driver, but the JDBC driver does not support that feature.
Changing the Query Timeout parameter to -1, which means unlimited, doesn't resolve the problem as it still sends the parameter.
FIX:
Revert back to a pre-6.5 version of the JDBC Adapter that doesn't send the Query Timeout parameter.