Re: JAVA_XA errors when starting up a connection pool

From: Anurag Varma <avdbi_at_nospam.hotmail.com>
Date: Thu, 06 Sep 2001 18:33:11 GMT
Message-ID: <HjPl7.1953$tb.317673@news02.optonline.net>

Do you have the Oracle Java Products installed on the server? Run Universal Installer > Installed Products > Check in Oracle8iPersonalEdition > Oracle Java Products

SYS.JAVA_XA is a package installed by the script initxa.sql You can crosscheck if you have this package installed by DESC java_xa on SQL. Anurag

"Chris Baglieri" <cbaglieri_at_sapient.com> wrote in message news:71350d31.0109060958.48309638_at_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

> 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 - 13:33:11 CDT