|
| 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).
 | | | |
| |
|
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
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|