APEX Export Utility No Longer Works With 11g JDBC/ JDK 1.5 or Higher
Last updated on OCTOBER 27, 2016
Applies to:
Oracle Application Express (formerly HTML DB) - Version 3.0.1 and laterInformation 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)
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
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