Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

2pc between two oracle database servers.

0 views
Skip to first unread message

Bob McMillan

unread,
Nov 22, 2001, 1:54:50 AM11/22/01
to
Here is the scenerio:

Use the 2PC sample that BEA provides \examples\jta\oracle.

I changed the sample so that the checking account table is on another oracle
server on the network.

I set up my OracleXAPool2 to point to the other dataserver ( still using the
thin driver ).

I get the following error from the WLS console:

TX: [EJB
examples.jta.oracle.CheckingAccountBean.findByPrimaryKey(java.lang.String)],
setEntityContext called
TX: [EJB
examples.jta.oracle.CheckingAccountBean.findByPrimaryKey(java.lang.String)],
ejbFindByPrimaryKey (ID: 2)
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)

Has anyone seen this before ( I looked @ Oracles support site and didn;t
really help ) and if so what is the workaround...

Thanks in advance..

0 new messages