APEX Export Utility No Longer Works With 11g JDBC/ JDK 1.5 or Higher
(Doc ID 1091868.1)
Last updated on AUGUST 25, 2019
Applies to:
Oracle Application Express (APEX) - Version 3.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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)
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=<ORACLE_HOME>
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |