datainsert is throwing an error due to a preexisting primary key. How can I make it keep going on error?
1 view (last 30 days)
In using datainsert, I am inserting about 50k rows into my database (mySQL,JDBC). My problem is that I keep on getting thrown error messages when there is a repeat primary key, interrupting and stopping my insertion.
I would like it to behave such that IF it tries to insert and fails, it simply moves on in the insertion. I see a few solutions:
- be informed of a feature of datainsert I was unaware of that get it to behave like this
- use a dynamicSQL query instead, since these continue even if an error is thrown
- perhaps fastinsert does not behave like this
- import all primary keys from the table, do the setdiff function and THEN datainsert. This is computer intensive as my database is too big for this to be a reasonable option.