Ok, this is my problem:
Im loading around 900,000 records from a file to my database.
So, i commit after it has processed 10,000 with something like this:
if (count % 10000) == 0
(Where the variable count is the number of lines loaded.)
And now i have this code that process each line:
$stderr.puts "err: " + $!.to_s
Here is the problem:
For example, if the programm is loading the 12,000 line and this
executeQuery method produces an error, the lines 10,000 to 12,000 DONT
load to the database. Because i commit after 10,000 lines, so those
2,000 lines havent got commit. So, what i want is that when the
executeQuery produces an error, ok, dont load that line, but i want to
commit the rest of lines that were loaded before.
I putted the “@dbh.commit” in the rescue block, but doesnt work. What
can i do? Where should i put a @dbh.commit in my code?
Hope i explained my case clear,
Thanks in advance