Join the Customer Advisory Board

WebSphere & Liberty CAB

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.  IBM WAS Data Source Test Connection Successful with Warning

    Posted 02/09/22 06:42 AM
      |   view attached
    Hi Everyone,

    Hope you all are doing good. I have a question regarding the IBM WAS data source test connection, it was successful but there are 2 warnings (please check the attached image). Has anyone run into the same problem and how can we solve the issue?
    Thank you

    ------------------------------
    Davin Ardian
    ------------------------------


  • 2.  RE: IBM WAS Data Source Test Connection Successful with Warning

    Posted 02/09/22 07:54 AM
    Hello Davin,

    It seems you are using JDBC3.0 driver and those properties are supported from JDBC4.0. So I think the warning can be supressed by using newer jdbc driver for SQL Server which is compliant with JDBC4.0.

    https://docs.microsoft.com/en-us/sql/connect/jdbc/using-kerberos-integrated-authentication-to-connect-to-sql-server?view=sql-server-ver15
    ---
    Beginning in Microsoft JDBC Driver 4.0 for SQL Server, an application can use the authenticationScheme connection property
    ---

    https://docs.microsoft.com/en-us/sql/connect/jdbc/jdbc-driver-support-for-high-availability-disaster-recovery?view=sql-server-ver15
    ----
    The following connection properties were added in Microsoft JDBC Driver 4.0 for SQL Server:
    applicationIntent
    ----

    Hope this helps.
    regards, Yoshiki

    ------------------------------
    Yoshiki Yamada
    IBM Japan
    ------------------------------



  • 3.  RE: IBM WAS Data Source Test Connection Successful with Warning

    Posted 02/10/22 08:37 PM
    Hi Yoshiki,

    thank you for the advice

    ------------------------------
    Davin Ardian
    ------------------------------