I’ve recently installed the wM IS SP2 in our test environment and I encounter slow performances on flows using JDBC connections. Those flows were working fine in wM IS SP1.
It appears that the connection establishment is long (40 seconds for a pool of 10 connections towards an Oracle 8.1.7. database).
Does anyone has the same problem and know how to fix it ?
The solution is to move the classes12.zip file containing Oracle JDBC drivers from the IntegrationServer\lib\jars directory to the IntegrationServer\jvm\lib\ext directory.
Don’t know why it works better but it works !
We will need to know which JDBC connection that you are using, IS connection pool or the JDBC Adapter?