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>
<module name="com.oracle"/>
<module name="org.jboss.remoting-jmx" slot="main"/>
</global-modules>
Published March 24, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.