"java.lang.ClassNotFoundException: oracle.jdbc.pooling.Factory"

Question

I am having a problem with ucp.jar

If I use ucp.jar for oracle 12.1.0.1, it works.

If I use version for oracle 12.1.0.2, I get the following exception:

java.lang.ClassNotFoundException: oracle.jdbc.pooling.Factory

Is there anyone who can help me?

Thanks Mauro

Answer 1

Jdbc (ojdbc7.jar) and UCP (ucp.jar) banks should always be from the same version (12.1.0.2). You cannot update it without updating another. This version dependency was introduced in 12c. This was not the case before.

Answer 2

There is a dependency on the ojdbc7.jar / ojdbc6.jar file. You need to download / update either depending on the version of java you are using.

Answer 3

Adding the following maven dependencies solved the problem for me

  <dependency> <groupId>com.oracle.jdbc</groupId> <artifactId>ojdbc7</artifactId> <version>12.1.0.2</version> </dependency> <dependency> <groupId>com.oracle.jdbc</groupId> <artifactId>ucp</artifactId> <version>12.1.0.2</version> </dependency>