It would be very helpful if you know, that your
batchjob is done. Now i always must make selects to see
how far the job has been done. Better thing would be a
scrollbar (if possible).
I looked at the sourcecode and I found out, that simply
connecting the BatchRunner with a ProgressPanel as
ProgressListener is more confusing, because the progress
shows only the status of the lines being loaded, but with a
low connection and a huge sql scipt the commit takes rather
long with the progresspanel being at 100%.
I added some System.out.println and thats better.
"Script locally loaded" at the end of
BatchRunner.loadStatements()
"Script uploaded...performing commit" in the middle of
DatabaseConnection.executeBatch()
"Batch done." at the end of DatabaseConnection.executeBatch()
Another thing is, that catching Throwables loadStatements()
is very helpful, if any error occurs while parsing the
statements.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=1305869
I looked at the sourcecode and I found out, that simply
connecting the BatchRunner with a ProgressPanel as
ProgressListener is more confusing, because the progress
shows only the status of the lines being loaded, but with a
low connection and a huge sql scipt the commit takes rather
long with the progresspanel being at 100%.
I added some System.out.println and thats better.
"Script locally loaded" at the end of
BatchRunner.loadStatements()
"Script uploaded...performing commit" in the middle of
DatabaseConnection.executeBatch()
"Batch done." at the end of DatabaseConnection.executeBatch()
Another thing is, that catching Throwables loadStatements()
is very helpful, if any error occurs while parsing the
statements.