Using non XA MS SQL Server driver

May 28, 2015

Reading time ~1 minute

If you want to use the non-XA MS Sql Driver (weblogic.jdbc.sqlserver.SQLServerDriver), you must be sure that it actually does not use XA. If not, you will get error message. The way to verify this is to go into the System MBean Browser, find your JDBCSystemResource. From EM console, you go to your domain. Then right click and select System MBean Browser.

And then look into the JDBC Driver Properties. To find it you must click:

JDBCResource (and value)
JDBCDriverParams (and value)

If UseXaDatasourceInterface is not false, you should set it to false.

You must then Lock & Edit,and Activate changes. WLS will then write to the appropriate JDBC configuration file.

Jon Petter is Department Manager for Middleware at SYSCO. Building an organization of skilled Oracle Middleware experts, with a focus on Oracle SOA Suite, Weblogic, Oracle Service Bus, BPM Suite, BAM, Oracle Event Processing. He has worked with Oracle products since 1997, and has worked with some of the larger SOA customers in Norway. Board member of the Oracle User Group Norway (OUGN), and Oracle ACE Associate.

Customizing service calls with multiple levels of security in OSB 12c

This will be a part two of my previous post which you can read [here](… Continue reading