All geek questions in one place

What is the difference between oracle.jdbc.xa.client.OracleXADataSource and oracle.jdbc.pool.OracleDataSource

I am trying to understand the difference between XA and Non XA JDBC datasource. Also how to find out what type and version of JDBC dtriver is used. I am currently in 10.3 weblogic and am trying to run several theta to kill long queries using setQueryTimeout, which does not seem to be reliable with OracleXADataSource, since it only works for the first time and not always. Sorry for this basic question, but I'm new to setting up a Weblogic data source

thanks

+6
source share
2 answers

XA jdbc drivers are used to implement two-phase commit, that is, two remote resources are part of the same transaction. Java specifies the implementation of this through the JTA. A good indicator is, for example, http://www.javaworld.com/javaworld/jw-07-2000/jw-0714-transaction.html ; if you google for the "xa jdbc driver", you will find a lot of information.

You should not use the XA driver if it is not necessary. I remember reading that there are problems with them.

+9
source

To identify the JDBC driver your WLS uses, go to <domain_dir>/config/jdbc and open the sub data file, check the driver-name value in the file.

To determine the driver version , check from which .jar the driver is loaded (start WLS with -verbose:class ) - the flag name will contain the version number. Alternatively, you can use java -jar my-jdbc-file.jar , which will print the driver version. OJDBC drivers are usually stored in a file called ojdbc6.jar or ojdbc7.jar , etc.

0
source

Source: https://habr.com/ru/post/923581/

More articles:


All Articles