MySQL Forums
Forum List  »  Perl

Commit Delay
Posted by: David Hofmann
Date: September 12, 2011 01:01PM

I recently change over to MySQL from Postgresql.

One of the perl programs I have parse some values from a form submission, does the appropriate update or insert statements, does a commit then redirects the person to a different perl script. The script they are direct to does a query of the database for information including what they just submitted and displays it to a web page.

I'm seeing situation where data that should have be committed isn't being displayed as if it wasn't committed, but I can walk away come back a few minutes later and reload the webpage and it shows that it's there.

Here the commit I'm calling before exiting the program:

# Commit It all
or $ErrorSystem->PrintError(dbierror => $DBI::errstr, error => 'COMMIT', errorloc => 'COMMIT 3 Info Proc');

Is there any reason why when I call commit it would continue through the program without having finished the commit?

Options: ReplyQuote

Written By
Commit Delay
September 12, 2011 01:01PM
September 14, 2011 07:45PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.