Problems with XA Connection, ITS and Oracle
Aoife Kavanagh
I'm trying to write distributed transactions using Visibroker 4.1 for
Java with the Oracle thin driver and JDBC2. We're getting our
transaction support from that supplied by the vbejb.jar file that comes
with IAS4.1 without actually using EJB itself. Unfortunately, I seem to
go from one problem to the next.
To test that I had registered my InpriseDataSource and my
OracleXADataSource etc correctly with JNDI I had a test application
which consists of a Java CORBA client and server. The client can
successfully invoke on the server (without starting a transaction), and
the server just gets a connection to the DB. That works fine.
I then introduced ITS in to the picture. My client now begins a
transaction before invoking on the server. When the server object now
calls getConnection on the data source I always get back an exception
saying that the identifier JAVA_XA.XA_START must be declared. The full
stack trace is below.
I'm relatively new to transactions, databases and ITS so if anyone can
help that would be great.
Thanks,
Aoife
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, Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java,
Compiled Code)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java,
Compil
ed Code)
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:18
07)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen
t.java:332)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java
:376)
at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:102)
at
com.inprise.visitransact.jdbc2.InpriseXAConnectionPool.associateWithTransaction
(InpriseXAConnectionPool.java:149)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.doWorkforNewElement(Generi
cConnectionPool.java:195)
at
com.inprise.visitransact.jdbc2.GenericPool.getPooledObject(GenericPool.java:397
)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.getPooledConnection(Generi
cConnectionPool.java:25)
at
com.inprise.visitransact.jdbc2.InpriseDataSource.getConnection(InpriseDataSourc
e.java:204)
at aoife.JDBCUtility.getConnection(JDBCUtility.java:68)
at
aoife.persistencetests.oneclientoneserver.gridImpl.height(gridImpl.java:52)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:72)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:55)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2164)
at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:101)
at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInterce
ptorManager.java:56)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java
:392)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapte
r.java:527)
at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java
:100)
at
com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java,
Compiled Cod
e)
oracle.jdbc.xa.OracleXAException
at
oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:467)
at
oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:122)
at
com.inprise.visitransact.jdbc2.InpriseXAConnectionPool.associateWithTransaction
(InpriseXAConnectionPool.java:149)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.doWorkforNewElement(Generi
cConnectionPool.java:195)
at
com.inprise.visitransact.jdbc2.GenericPool.getPooledObject(GenericPool.java:397
)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.getPooledConnection(Generi
cConnectionPool.java:25)
at
com.inprise.visitransact.jdbc2.InpriseDataSource.getConnection(InpriseDataSourc
e.java:204)
at aoife.JDBCUtility.getConnection(JDBCUtility.java:68)
at
aoife.persistencetests.oneclientoneserver.gridImpl.height(gridImpl.java:52)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:72)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:55)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2164)
at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:101)
at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInterce
ptorManager.java:56)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java
:392)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapte
r.java:527)
at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java
:100)
at
com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java,
Compiled Cod
e)
java.sql.SQLException: Error doing res.start()null
at
com.inprise.visitransact.jdbc2.InpriseXAConnectionPool.associateWithTransaction
(InpriseXAConnectionPool.java:169)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.doWorkforNewElement(Generi
cConnectionPool.java:195)
at
com.inprise.visitransact.jdbc2.GenericPool.getPooledObject(GenericPool.java:397
)
at
com.inprise.visitransact.jdbc2.GenericConnectionPool.getPooledConnection(Generi
cConnectionPool.java:25)
at
com.inprise.visitransact.jdbc2.InpriseDataSource.getConnection(InpriseDataSourc
e.java:204)
at aoife.JDBCUtility.getConnection(JDBCUtility.java:68)
at
aoife.persistencetests.oneclientoneserver.gridImpl.height(gridImpl.java:52)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:72)
at aoife.poaoraclenotxn.gridPOA._invoke(gridPOA.java:55)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2164)
at
com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:101)
at
com.inprise.vbroker.poa.ServerInterceptorManager$ARWrapper.invoke(ServerInterce
ptorManager.java:56)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.doRequest(GiopProtocolAdapter.java
:392)
at
com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapte
r.java:527)
at
com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java
:100)
at
com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java,
Compiled Cod
e)