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
Back to discussions
Expand all | Collapse all

How to setup Microsoft SQL JDBC driver traces in WebSphere Application Server?

  • 1.  How to setup Microsoft SQL JDBC driver traces in WebSphere Application Server?

    Posted Wed April 24, 2024 10:49 AM

    I want to troubleshoot some JDBC driver issues that occur in relationship with Microsoft SQL Server JDBC driver. How to set the right trace string in WebSphere Application Server to debug this scenario?



    ------------------------------
    Christian Lopez-Martinez
    ------------------------------


  • 2.  RE: How to setup Microsoft SQL JDBC driver traces in WebSphere Application Server?
    Best Answer

    Posted Wed April 24, 2024 10:50 AM
    Edited by Marcio D'Amico Wed April 24, 2024 10:52 AM

    You can add com.ibm.ws.sqlserver.logwriter=all trace string to the default connection pooling trace string resulting in this string:

    *=info:WAS.j2c=all:RRA=all:Transaction=all:WAS.database=all:com.ibm.ws.sqlserver.logwriter=all

    More information can be find in:

    JDBC trace configuration
    https://www.ibm.com/docs/en/was/9.0.5?topic=problems-jdbc-trace-configuration

    If you want to find out more about internal MS-SQL jdbc driver processing mechanisms you can use com.microsoft.sqlserver.*=all trace string, resulting trace string is:

    *=info:WAS.j2c=all:RRA=all:Transaction=all:WAS.database=all:com.microsoft.sqlserver.*=all

    Both trace strings can be combined to get more detailed information:

    *=info:WAS.j2c=all:RRA=all:Transaction=all:WAS.database=all:com.ibm.ws.sqlserver.logwriter=all:com.microsoft.sqlserver.*=all



    ------------------------------
    Marcio D'Amico
    ------------------------------

    Original Message


Related Content