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..