Bug #75317 Add documentation about using Connector/J with Weblogic
Submitted: 27 Dec 2014 11:46 Modified: 29 Dec 2014 8:42
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
Category:Connector / J Documentation Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: weblogic, xa

[27 Dec 2014 11:46] Daniël van Eeden
There is documentation about using Connector/J with Tomcat, JBoss, Spring and Glassfish on http://dev.mysql.com/doc/connector-j/en/index.html but there is no documentation about using Connector/J with Oracle Weblogic.

How to repeat:
Try to find documentation about using Weblogic with MySQL

Suggested fix:
Add documentation.

How to replace the Connector/J which ships with Weblogic 11g (10.3.6). This is needed as the conn/j which comes with 10.3.6 uses 'SET OPTION' which is fixed in newer releases and is removed in MySQL 5.6. As the jar file contains a version number the newer version should be added and prepended to the classpath.

Also creating XA an non-XA datasources could be added here.

And maybe a version matrix and a link to the premier support matrices and product certification pages (if available).
[29 Dec 2014 8:12] Daniël van Eeden
On https://docs.oracle.com/cd/E13155_01/wlp/docs103/db/mySQL.html there is this warning:
The MySQL JDBC driver is not fully XA compatible, therefore WebLogic Portal does not support 
using the com.mysql.jdbc.jdbc2.optional.MysqlXADataSource. Data sources that require XA and 
those that are XA capable should use the com.mysql.jdbc.Driver with the global-transactions-protocol 
LoggingLastResource instead."

Is this still true for Weblogic 12c and MySQL 5.6 with the latest Connector/J?

This seems to contradict the statements on http://dev.mysql.com/doc/connector-j/en/connector-j-versions.html
"Connector/J 5.0 provides support for all the functionality offered by Connector/J 3.1 and includes distributed transaction (XA) support."

Also there is no known limitation in XA support for Connector/J:
[29 Dec 2014 8:42] Daniël van Eeden
The Weblogic 12c seems to suggest that you should use a weblogic branded datadirect driver instead of Connector/J...