Configuring an XADataSource with Oracle and WLS 7

[wegfn06]

Hi

I was wondering if somebody could help me. I am using Oracle 8.1.7 and Weblogic 7 Beta and have configured and Connnection Pool using the following parameters:

URL: jdbcracle:thinether:1521:cad
Driver: oracle.jdbc.xa.client.OracleXADataSource
Properties: user=mik
password=cad

The connection pool starts up fine and it's associated XADataSource binds to the JNDI successfully. Also in Oracle I have executed:
grant select on DBA_PENDING_TRANSACTIONS to public

However, when I try and deploy an entity bean that references this XADataSource I get the following error:

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

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) --> rest of stack trace

I was wondering if somebody could tell me what the problem could be here. There are no tablespaces or tables called JAVA_XA in the Oracle db for the users system, internal, sys or mik.

Many thanks in advance.

 

[Guest_imported]

Hi I'm encountering the same issues

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

Have you found an answer to this?

 

[wegfn06]

You need to enable XA on the Oracle database server. This is from the BEA docs:

Enable XA on the Database Server

To prepare the database for XA, perform these steps:


Log on to sqlplus as system user, e.g. sqlplus sys/CHANGE_ON_INSTALL@<DATABASE ALIAS NAME>

Execute the sql: grant select on DBA_PENDING_TRANSACTIONS to public
If the above steps are not performed on the database server, normal XA database queries and updates may work fine. However, when the Weblogic Server Transaction Manager performs recovery on a re-boot after a crash, recover for the Oracle resource will fail with XAER_RMERR.


Alternatively you can use the simple oracle.jdbc.driver.OracleDriver that is in the weblogic.jar but make sure you check the box that says emulate two phase commit when creating the connection pool.

Sorted!