Re: JAVA_XA errors when starting up a connection pool

From: aasthana <member_at_dbforums.com>
Date: 9 Apr 2002 06:58:55 GMT
Message-ID: <3cb2912f$1@usenetgateway.com>

I am also getting java.sql.SQLException: ORA-06550: error when i try to do a Two phase commit using Oracle's XA driver. The error i get is

ORA-06550: line 1, column 7: PL/SQL: Statement ignored

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:-
        168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at
        oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at
        oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at
        oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.ja-
        va:822 ) at oracle.jdbc.driver.OracleStatement.executeNonQuery(-
        OracleStatement.ja
va:1446)at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleSta-
        tement.jav
a:1371)at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl-
       eStateme nt.java:1900) at oracle.jdbc.driver.OraclePreparedState-
       ment.executeUpdate(OraclePrepar edStatement.java:363) at oracle.-
       jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
       ement.java:407) at oracle.jdbc.xa.client.OracleXAResource.start(-
       OracleXAResource.java:17

1)at weblogic.jdbc.jta.VendorXAResource.start(VendorXAResource.java:41)

I am using the following driver oracle.jdbc.xa.client.OracleXADataSource with Supports Local Transaction enabled. The application is an EJB with Bean managed Transaction trying to co-ordinate a 2-phase transaction across Oracle and MQSeries. Pls let me know if you have any thoughts or ideas about this

--
Posted via dBforums
http://dbforums.com

Received on Tue Apr 09 2002 - 01:58:55 CDT