Suppress warning?

[nshaik]

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!

[chrisl]

Re: Suppress warning?

Add this line to the end of log4j.properties:

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

[chrisl]

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

[nshaik]

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!

[kennyp]

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.