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.
1> Make sure you have the latest JDBC adapter fix levels installed. Moreover check if the current oracle version that you are using is supported by the JDBC adapter version (you can find it in system requirements guide).
2> Restart the IS to check if issue resolves
3> Still issue, try giving the setting in other properties of JDBC adapter connection: includeSynonyms=true
We tried all propositions but it dosn’t work, so now we upgrade the version of jdbc adapter from 6.5 to 9.0, we use the ojdbc7 and we installed the fixe 9.0.8 but we still have the same problems, the version of our ORACLE 11g database is 9.0.8.0,
hi, @MR as173d : i still have the same problems, even after installing lates fixes, i was looking for the script that i should run to migrate the adapter services?
@Holger von Thomsen : the DB admin confirm that the version of the database is 9.0.8, can you tell me please where i can found the script that i should run to migrate version,?
Regards,
Nezha,
As you have tried many suggestions, want to check few other things not related to adapter…
Can you check which data centre, your integration server is running and Oracle server is running? Ideally it should be same.
Login to the Unix box of integration server and do a ping to Oracle server to verify the latency. See how much time IS takes to communicate with Oracle.
If both servers are in same data centre and you noticed ping taking less than 10 ms, with your DBA help, run some SQL queries connecting to the Oracle server (server), and run the same query using SQL developer (client). If you notice quicker response from them, then you would have to create ticket with SAG.
i execute the wm.adapter.wmjdbc.admin:migrate_65_To_90 service and it execute successfully, but we still have the same problems, the ping also work fine and i execute the same requests from both ans i notice that its quicker than designer, so we have to create ticket with SAG,
I am also getting same error while creating JDBC Order Notifications.But error was popping up only very first time creating the new adapter notification once error was occurred am able to create the notification.
Error deatils:
[ART.114.243] Adapter Runtime (Metadata): Failed to run notificationLookupValues 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
Share more details about your environment, go through the same thread, follow the suggestions given, if still issue persists, please write back with complete details.