Ok so we had a requirement to check if the oci driver would work with ADF. So here are the steps I followed to get it working quite simple I think. Will post here if there are any problems with using the driver but with a quick scan test everything looks ok. 1) Installed the oracle client on our weblogic box. 2) Replaced the ojdbcdms.jar reference in the weblogic classpath with the exact version that comes with the client (VERY important) 3) changed my connection string to jdbc:oracle:oci:@127.0.0.1:1521:SID. Things that will be investigated : Client side caching, speed tests, amount of connections Notes: UnsatisfiedLinkError - ocijdbc11.dll not found Change your path on your system to have your client library location as the first in the list - ie for me I installed my client to C:\Oracle\11.2.0\client64 so that dir must be the first entry in my path. java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I You are using the incorrect...
The Incident Archive: A blog to store my knowledge on the errors that I fix on a daily basis