"PLS-00201: identifier 'JAVA_XA.XA_START_NEW' must be declared" error occurs when using a XA data source with Oracle Thin or OCI Version 8.1.7 or 9i

Technote (FAQ)
Problem
When using an Oracle® XA data source, you receive errors if the Oracle databases are not configured with the Oracle Java™ virtual machine (Oracle JVM™).
Solution
Using the Oracle XA class, oracle.jdbc.xa.client.OracleXADataSource, for a two-phase commit, produces the following error:

PLS-00201: identifier 'JAVA_XA.XA_START_NEW' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


If the Oracle instance is not created with Oracle JServer (for Oracle 8i) or the Oracle JVM (Oracle 9i), the above error occurs.

To fix the problem, reconfigure the Oracle instance to include the Oracle JVM option, using the Oracle Database Configuration Assistant (on Windows® platforms) or dbassist (on UNIX® platforms). To manually configure the Oracle JVM, follow the Note 156477.1 "JVM Installation on 8.1.7" from Oracle Metalink.

The following steps guide you through the Oracle Database Configuration Assistant to check if the Oracle server 9i, with the Oracle JVM, is configured with your database:

Launch the Oracle Database Configuration Assistant.



Click Next.



Check the radio button Configure database options in a database, then click Next.



Select the database from the Available Database(s) list, then click Next.



Click Standard database features... to see this window. If Oracle JVM is not installed, it is not greyed out (for example: It will be available for you to select and then proceed with the database modification).












    Document Information

    Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Java 2 Connectivity (J2C)
    Operating system(s): Multi-Platform
    Software version: 3.5.4, 3.5.5, 3.5.6, 3.5.7, 3.5, 4.0, 5.0
    Software edition: Edition Independent
    Reference #: 1046276
    IBM Group: Software Group
    Modified date: 2004-07-13