APEX Export Utility No Longer Works With 11g JDBC/ JDK 1.5 or Higher (Doc ID 1091868.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 20-Jul-2012

Symptoms

When attempting to run the APEXExport utility in and 11g database ORACLE_HOME, using using the "ojdbc5.jar" and  JDK 1.5 or using the "ojdbc6.jar" and JDK 1.6, errors similar to the following will be shown:   

Exporting Application 100:'Sample Application'
Exception in thread "main" java.lang.IllegalAccessError: tried to access class oracle.jdbc.driver.OracleCallableStatement from class oracle.apex.APEXExport
at oracle.apex.APEXExport.ExportFile(APEXExport.java:161)
at oracle.apex.APEXExport.ExportFiles(APEXExport.java:77)
at oracle.apex.APEXExport.main(APEXExport.java:314)

The environment at the time of this error is:

set ORACLE_HOME=/app/oracle/product/11gdb/db_1
set JAVA_HOME=$ORACLE_HOME/jdk
set PATH=$JAVA_HOME/bin:$PATH
set APEX_HOME=/downloads/apex/ape31/apex
set CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc5.jar:$ORACLE_HOME/apex/utilities/oracle/apex

Changes

The export ran correctly in an 10.2 database, this error occurs after upgrading to an 11g database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms