How to suppress exception logging for groovy DataSet operations?

Question

I have some groovy code like this:

    def dest = destSql.dataSet('destination_table')
    sourceSql.eachRow('select * from source_table'){row ->

        try {
            dest.add(ID: row.id)
        } catch (SQLException) { //A FK constraint will case some inserts to fail 
            dest.add(ID: 1)
        }
    }

I'm running this as a command line script. Everything works fine, but the console outputs the SQLExceptions no matter what. I'd like them to not show up when I handle them, as they only pollute the output. How could I specify this (programmatically, if possible)?

TIA.

Answer 1

Isn't adding something (possibly multiple times) with ID:1 going to fire a fk constraint exception?

It's probably this exception you are seeing, not the one you're catching.

Answer 2

You probably just want to turn down the logging level of groovy sql. Try putting this in your program before you try adding to the dataset:

Sql.LOG.level = java.util.logging.Level.SEVERE