Using non XA MS SQL Server driver

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.