Navigation

    Best APM Solution for Oracle WebLogic Server & FMW Product Family
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Download

    SOLVED Back-end System JDBC statement execute ignore-list

    General Support & Troubleshooting
    statement execute jdbc ignore-list
    3
    5
    1183
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      dsh last edited by dsh

      Hi,

      I was wondering whether it is possible to configure specific SQL statement ignore patterns (exceptions) for backend notifications?
      We have our JDBC statement execute threshold set to 30s. Some of the statements run on the datasource take longer than 30s occasionally (i.e. AD group to application role mapping). We’d still like to retain the ability to catch long running statements on the same datasource for the server, so setting the pool exception doesn’t seem a viable option.

      We were thinking the server-specific exception list can be configured with a %like patter for our SQL procedure call:
      %JOB.PAK_JOB_USER_GRANTS_AD.SYNC_USER_ROLES%
      in order to ignore notification about this specific query, but it doesn’t look like such option exists?

      mustafa.sensoy-wlsdmteam wlsdmsupport 2 Replies Last reply Reply Quote 0
      • mustafa.sensoy-wlsdmteam
        mustafa.sensoy-wlsdmteam @dsh last edited by

        Hi @dsh,

        As you point, WLSDM supports only the pool (data source) for the exception.
        But, adding a statement exception mechanism could be a nice upgrade, we will consider it.

        Additionally, you can take a look at the WL-OPC product.
        WL-OPC may offer a solution to your requirement by writing a notification delivery rule.

        https://wlsdm.com/download

        Mustafa ŞENSOY
        Principal Software Consultant
        Senior Software Architect

        1 Reply Last reply Reply Quote 0
        • mustafa.sensoy-wlsdmteam
          mustafa.sensoy-wlsdmteam @dsh last edited by

          Hi @dsh,

          As you point, WLSDM supports only the pool (data source) for the exception.
          But, adding a statement exception mechanism could be a nice upgrade, we will consider it.

          Additionally, you can take a look at the WL-OPC product.
          WL-OPC may offer a solution to your requirement by writing a notification delivery rule.

          https://wlsdm.com/download

          Mustafa ŞENSOY
          Principal Software Consultant
          Senior Software Architect

          1 Reply Last reply Reply Quote 0
          • D
            dsh last edited by

            Thank you for the prompt reply and for consideration.
            In the meantime, as you suggest, ww will have a look at WL-OPC.

            1 Reply Last reply Reply Quote 0
            • wlsdmsupport
              WLSDM Support @dsh last edited by

              @dsh said:

              Hi,

              I was wondering whether it is possible to configure specific SQL statement ignore patterns (exceptions) for backend notifications?
              We have our JDBC statement execute threshold set to 30s. Some of the statements run on the datasource take longer than 30s occasionally (i.e. AD group to application role mapping). We’d still like to retain the ability to catch long running statements on the same datasource for the server, so setting the pool exception doesn’t seem a viable option.

              We were thinking the server-specific exception list can be configured with a %like patter for our SQL procedure call:
              %JOB.PAK_JOB_USER_GRANTS_AD.SYNC_USER_ROLES%
              in order to ignore notification about this specific query, but it doesn’t look like such option exists?

              Hi,
              We have implemented this feature in our latest version which is v3.9.1.
              Thank you for the contribution. For your information.
              Regards…

              Screen Capture
              image.png

              WLSDM Community Support Team

              1 Reply Last reply Reply Quote 0
              • D
                dsh last edited by

                Oh, that’s lovely, thank you very much!
                Have installed 3.9.1 in out sandbox environment after receiving the newsletter last week, will give this a shot right away!

                1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post

                WLSDM: Native WebLogic Monitoring & Diagnostics

                Copyright © 2021 WLSDM Community & Support Portal | WLSDM.COM | WLSDM Blog