I have a newbie question. A search of the ML going back to late 2007 didn't yield any help.
I have a simple table that I am doing batch inserts into via the Dataset#insert_multiple method. The table has a unique key, so obviously if I try to insert a duplicate it throws an exception: "NativeException: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:<snip> I'm inserting in batches of 2000 for performance reasons. I am assuming that if I have a duplicate anywhere in my batch of 2000, any rows *after* it will not get inserted due to the exception. I suppose it is also possible that other successfully inserted rows in that batch might get rolled back too. How do you recommend I detect this issue and retry the insert minus the duplicate row? cr --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
