Support Article

java.lang.ClassNotFoundException unable to load ORA cursor type

SA-34806

Summary



Error occurs when the application runs, user has validated that the driver class and module setup.
The test connections were successful. This spawns other errors downstream like java.lang.RuntimeException: Unable to dynamically load oracle cursor type!


Error Messages

  • java.lang.ClassNotFoundException: oracle.jdbc.OracleConnection
  • java.lang.RuntimeException: Unable to dynamically load oracle cursor type!


Steps to Reproduce



1. Deploy application.
2. Observe that application does not work correctly (cannot login and landing page is rendered wrong).


Root Cause



Bug in JBOSS prevented the Global Module for oracle from being generated.

Resolution



Perform the following local-change:

Make the Oracle JDBC driver a global module.

Add lines similar the following to the domain subsystem element. The remote library name depends on the version of Red Hat JBoss app server.

This example is correct for Red Hat JBoss 6.x and above:


<global-modules>
<module name="com.oracle"/>
<module name="org.jboss.remoting-jmx" slot="main"/>
</global-modules>

Published March 9, 2017 - Updated March 24, 2017


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.