XA Xid Exception - How to turn on the XA support on Oracle server side

From: jason <jasonxu_at_singnet.com.sg>
Date: 30 Oct 2001 03:37:50 -0800
Message-ID: <c2a80329.0110300337.63509e6b@posting.google.com>

Hi, talents

need your help !!!

I am using the example from Oracle Developer Guide to test the XA usage.
but I encounter the problem below. i doubt this is due to the server configuration lack of XA package/support, I am using Oracle 8.1.6 (solaris version), any one knows how to turn on the XA support on server side, pls help, thanks a lot.

ERROR MESSAGE: PLS-00201: identifier 'JAVA_XA.XA_START' must be declared

this messsag is created by following method (copy from Oracle Developer Guide's example),

  Xid xid = createXid(1);
  .....

  static Xid createXid(int bids)
    throws XAException
  {

    byte[] gid = new byte[1]; gid[0]= (byte) 9;
    byte[] bid = new byte[1]; bid[0]= (byte) bids;
    byte[] gtrid = new byte[64];
    byte[] bqual = new byte[64];

    System.arraycopy (gid, 0, gtrid, 0, 1);     System.arraycopy (bid, 0, bqual, 0, 1);     Xid xid = new OracleXid(0x1234, gtrid, bqual);

    logmsg("xid output=" + xid.getGlobalTransactionId() + "\n"

+ xid.getFormatId() + "\n"
+ xid.getBranchQualifier());

    return xid;
  }

log file:

---

Tue Oct 30 15:17:38 SGT 2001 TwoPhaseCommit output:get connection URL1
Tue Oct 30 15:17:40 SGT 2001 TwoPhaseCommit output:get connection URL2
Tue Oct 30 15:17:40 SGT 2001 TwoPhaseCommit output:create new tables
Tue Oct 30 15:17:41 SGT 2001 TwoPhaseCommit output:completed two

tables craetion.

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

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
	at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
	at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
	at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:320)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:364)
	at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:102)
	at TwoPhaseCommit.main(TwoPhaseCommit.java:180)

XA Error is -3
SQL Error is 65535

---

Received on Tue Oct 30 2001 - 05:37:50 CST