One of our wM Java service connecting to our lookup database is failing with the error “java.lang.reflect.InvocationTargetException:Link Error: no ocijdbc9 in java.library.path”.
We have this jar file in \IntegrationServer\lib\jars\ojdbc14.jar
as well the jar file is in effective of server classpath.
Any help on this issue will be great for us.
Not sure why your java service is accessing a database resource directly, but the error is related to attempting to connect to Oracle using the OCI protocol when your IS does not have access to the OCI drivers. The WM JDBC Adapter User’s Guide covers configuring IS properly so that the JDBC adapter can use the OCI protocol. This may be helpful to you in having your java service use OCI.
However, you should probably re-think having java service connect to database resources directly.
i think you have missed some of the Required Connection Property fileds that are required when connecting with Oracle OCI drivers,please have a look more on Connection Properties and Installing the JDBC Driver on the Integration Server can get from JDBC Adapters User’s Guide.
Your answer would be on the mark if they were using the JDBC adapter which they apparently are not.
What version of JDBC Adapter are you using…if its JDBC 6.5 as it supports BLOBS/CLOBS you can change the driver type to thin and test it should work…
If you take this statement at face value, they are not using the JDBC adapter.