How to ignore "Unique index or primary key violation"?

[Johannes Schneider]

Hi guys,

I have a table with a unique index (id + time stamp). In this table I am storing a lot of values I receive from another service.

I am storing the data using a prepared statement in batches of about 400 entries.

Unfortunately this service might provide me with duplicate data. Now I just want to ignore those duplicate data (since it already exists within the db).

Of course I run into a  lot of "Unique index or primary key violation". That exceptions fails my complete transaction. But I just want the two or three problematic entries ignored...

I could add each of the entries within its own transaction. But I fear the performance penalty...

Any ideas how that could be solved?

[Steve McLeod]

I think you need to use the MERGE command instead of the INSERT command. Docs for MERGE are here:

http://www.h2database.com/html/grammar.html#merge

[Johannes Schneider]

Great. Thanks for that hint.