JAVA_XA errors when starting up a connection pool

From: Chris Baglieri <cbaglieri_at_sapient.com>
Date: 6 Sep 2001 10:58:06 -0700
Message-ID: <71350d31.0109060958.48309638@posting.google.com>

I am trying to setup two connection pools / data sources for a given instance of weblogic, each pointing to a different database. I would like to perform transactions spanning both DBs using XA. I am getting the following error when Weblogic starts up and tries to set up the XA connection pool:

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

Here are the details of my XA connection pool i am trying to set up:

Connection Pool
NAME: warehousePool URL: jdbc:oracle:thin:@xxxxxx:1521:xxxxxx DRIVER: oracle.jdbc.xa.client.OracleXADataSource PROPERTIES: user=xxxxx password=xxxxx dll=ocijdbc8 dataSourceName=warehousePool protocol=thin

<JDBCConnectionPool

CapacityIncrement="1"
DeploymentOrder="1000"
DriverName="oracle.jdbc.xa.client.OracleXADataSource" InitialCapacity="5"
JDBCXADebugLevel="0"
LoginDelaySeconds="0"
MaxCapacity="25"
Name="warehousePool"
Properties="user=xxxxx;password=xxxxx;dll=ocijdbc8;dataSourceName=warehousePool;protocol=thin;url="jdbc:oracle:thin:@xxxxx:1521:xxxxx" RefreshMinutes="10" ShrinkPeriodMinutes="5" ShrinkingEnabled="true"

SupportsLocalTransaction="false" 
Targets="DonutStoreServer" 
TestConnectionsOnRelease="false" 
TestConnectionsOnReserve="true" 

TestTableName="dual"/>

TxDataSource
NAME: warehousePool
JNDI NAME: weblogic.jdbc.jts.warehousePool POOL NAME: warehousePool
ENABLE 2 PHASE COMMIT ACTIVE
<JDBCTxDataSource

DeploymentOrder="1000"
EnableTwoPhaseCommit="true"
JNDIName="weblogic.jdbc.jts.warehousePool" Name="warehousePool"
PoolName="warehousePool"
Targets="DonutStoreServer"/>

Where do I find out what I need to install the JAVA_XA package on my Oracle instance? I have a feeling that is the issue. Received on Thu Sep 06 2001 - 12:58:06 CDT