hi community,We use the webMethods Integration Suite with version 9.7.
We encounter difficulties when we use JDBC adapters with Oracle 11G. We use the odjbc6 driver.
We have trouble using the adapters in the Designer, but the problem seems to be related to the connection between the IS and the database.
Please note that when using JDBC Adapters with other databases vendor, everything works fine.
The database we target contains a LOT of tables.
When we create an adapter (of any kind), not only is the adapter creation long to execute, but also when we try to save we encounter designer UI errors. For a given adapter, we can’t add any expression for a select statement, and the expressions we add are always empty - detection of the fields doesn’t work. Also, when we want to select the table, it takes a long time to load all the available tables.
We encounter errors on the IS log such as this one :
[ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ADA.1.319] Cannot get the list of table columns. "
(22025/1424) ORA-01424: missing or illegal character following the escape character
"
ORA-01424: missing or illegal character following the escape character
Caused by: com.wm.adk.error.AdapterException: [ADA.1.319] Cannot get the list of table columns. "
(22025/1424) ORA-01424: missing or illegal character following the escape character
"
ORA-01424: missing or illegal character following the escape character
We don’t know what kind of errors it is; we don’t know if the problem comes from the JDBC Adapter toolkit or the compatibility with our Oracle DB…
Did you experienced any kind of similar errors ? Any help would be appreciated.
Kind regards,
Nezha