WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Reason for this error: failed for data source Driver type 4 not enabled for XA connections

    Posted 09/08/17 11:01 AM

    I have recently started getting this this error on my local install of Websphere 8.0.0.12:   

    The test connection operation failed for data source

    failed for data source Driver type 4 not enabled for XA connections

    This error was not happening before the database was upgraded, so the driver should be enabled.  Also it is not happening for other users using the same data source.  Any possible explanations for this?

     



  • 2.  RE: Reason for this error: failed for data source Driver type 4 not enabled for XA connections

    Posted 09/18/17 09:55 AM

    What exactly is the exception?  Did you try with the latest JDBC driver? 



  • 3.  RE: Reason for this error: failed for data source Driver type 4 not enabled for XA connections

    Posted 09/19/17 05:29 AM

    Did you check the scope of the configured driver on your local WebSphere installation? Maybe an environment variable is still set to use the old version of the driver?

     

    i.e. {ORACLE_JDBC_DRIVER_PATH}/ojdbc.jar

    needs to be changed to:

    {ORACLE_JDBC_DRIVER_PATH}/ojdbc6.jar

     

    Check for your own version of the driver (5,6,7,8)