CODEWITHSUNDEEP
javaoracle-databasedatabase-connection
optional
optional

Reputation: 3350

Difference bwtween oracle.jdbc.xa.OracleXADataSource and oracle.jdbc.xa.client.OracleXADataSource

What is difference b/w oracle.jdbc.xa.OracleXADataSource and oracle.jdbc.xa.client.OracleXADataSource ,I know both are XA-Complient but why two version exist?

I have gone through the docs Here ,and It says

For optimization purposes, we implemented 2 versions of OracleXADataSource: one for client, and one for server when used in Java Stored Procedures and in EJB

. what does the line when used in Java Stored Procedures and in EJB mean here ?

Upvotes: 0

Views: 1941

Answers (1)

Marat
Marat

Reputation: 237

The thing is that you can code Stored procedures in Oracle database not only with PL/SQL. You can write Java code inside Oracle database. But JavaDoc also says about EJB and it is unclear point. It seems oracle.jdbc.xa.OracleXADataSource should be used in OC4J environment and inside Oracle database Stored procedures written in Java. In all other cases (other application servers and simple Java programs you should use oracle.jdbc.xa.client.OracleXADataSource.

There is another point in JavaDoc:

Package oracle.jdbc.xa.client Description

These should be used outside the Oracle RDBMS.

Upvotes: 3

Related Questions