This may be off-topic, but it may be helpful to you anyway. There are a couple of odd things about your code. I don't know the specifics of what you're trying to do, but the reason that the prepare() and execute() statements are separated is so that you don't have to do a connect() each time you want to do something in the database. Your program will run a lot faster like this:
$dbh = DBI->connect( 'Blah', 'Blah', 'Blah', 'Blah' ); # $dbh->LongReadLen( 65535 ); # since you're not fetching any data, th +is line doesn't do anything useful $stmt = $dbh->prepare( "UPDATE Images SET Name = ?" ); for(@JpgList){ $stmt->execute( $_ ); rename("$_","Processed/$_"); } $stmt->finish; $dbh->disconnect;
It's possible that changing this will fix the problem. DBI could be blocking on any of those commands. You should probably include some of the error checking mentioned in the DBI documentation, and make sure you're using strict and warnings.
--
Love justice; desire mercy.

In reply to Re: DBI won't let go! by strider corinth
in thread DBI won't let go! by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.