[Dbi-interbase-devel] commit not committing

[Brad G. <br...@fo...>]

Sorry to bug you all, but I'm at my wit's end. For some reason, I can't get anything to commit. I'm trying to do an UPDATE to a table, and I've tried every combination of AutoCommit on/off, using the commit statement, using prepare vs. do, etc. The test program below executes just fine, but when I check the table, it isn't updated. If I then type in 'commit' via isql, the update shows up. If I run the script again without having typed commit manually, it deadlocks.

I've got Interbase SS 6.0.1 running on Linux (RH 7.1), with Perl 5.6.1, and DBD::Interbase 0.28.4.

TIA for any help.

Regards,

Brad <br...@fo...>

--------------- BEGIN db_test.pl ----------------
#!/usr/local/bin/perl

use DBI;

my $state = $ARGV[0];

# connect to database
my $dbh = DBI->connect("dbi:InterBase:database=/opt/interbase/data/portal.gdb;host=sv-toby",'sysdba','masterkey',{AutoCommit => 1}) or die $dbh->errstr;

# make all users available
$dbh->do("UPDATE user_info SET unavailable=$state") or die $dbh->errstr;

# disconnect from database
$dbh->disconnect;
--------------- END db_test.pl ----------------