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()IYou are using the incorrect version of the ojdbc driver make sure you
are using the one that came with the client and it is the first driver
Shortcut to test :
Rename this file to ojdbc6dms.back
[your middleware install location]oracle_common\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar
Copy your ojdbc6dms.jar from your client (or download from Oracle) to the above location. Restart weblogic.