Announcement

Collapse
No announcement yet.

Suppress warning?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Suppress warning?

    How do I suppress a specific warning in Mirth v1.1?

    I don't want this warning to get logged in logs\mirth.log file:
    ============
    WARN [4_destination_1.dispatcher.2] org.mule.providers.jdbc.JdbcMessageDispatcher: Row count for write should be 1 and not 0
    ============

    Thanks in advance!

  • #2
    Re: Suppress warning?

    Add this line to the end of log4j.properties:

    Code:
    log4j.logger.org.mule.providers.jdbc.JdbcMessageDispatcher=ERROR
    However the greater issue is your SQL syntax. Can you post your Update SQL statement?

    Thanks
    -Chris
    Chris Lang

    Comment


    • #3
      Re: Suppress warning?

      Ideally when you have a SQL update statement it should update one row (whichever was pulled in the SELECT) and change it so that the next polling will skip the row.

      -Chris
      Chris Lang

      Comment


      • #4
        Re: Suppress warning?

        Chris,

        Thank you very much for the quick reply!

        This is in the context of the "Workaround to call stored procedure from Mirth". I 'm using a "fake" SQL to "trick" Mirth which expects only an Insert / Update / Delete.

        Since I'm handling the insert or update inside the stored proc, the SQL Statement
        INSERT IGNORE INTO PATIENT (Account) SELECT 'Fake Insert' WHERE 1 = 0
        in the "Destinations" window does a "dummy" insert. That's where I get the above WARN and want to ignore it.

        Thanks!

        Comment


        • #5
          Re: Suppress warning?

          I add this line to the end of stored procs after I've done the inserts, updates or deletes:

          SELECT 1 as result;

          that is enough to set the records affected value to 1. Mirth seems to be happy with this.

          Comment

          Working...
          X