Menu

#51 Add more visible info while doing sql batch jobs

open-accepted
5
2005-07-04
2005-07-01
thirau
No

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).

Discussion

  • Markus A. Kobold

    • status: open --> open-accepted
     
  • thirau

    thirau - 2005-07-05

    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.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.