Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

HI,all,I have a problem with DBD::JDBC, it's work with 'select/insert',but failed( stalled ) for 'update/delete'

my $dsn = 'dbi:JDBC:hostname=127.0.0.1:9001;url=jdbc:oracle:thin:@192. +168.153.100:1521:cudb;'; my $dbh = DBI->connect($dsn, undef, undef, { PrintError => 0, RaiseErr +or => 1, jdbc_properties => \%properties }) or die "Failed to connect +: ($DBI::err) $DBI::errstr\n"; #my $sql="select from user where status=1"; #success #my $sql="update user set status=1"; #hang #my $sql="insert into user(status) values(1) "; #success my $sql="delete from user where status=1"; #hang my $sth=$dbh->prepare($sql); $sth->execute;
The select/insert sql exec successful.But update and insert just hang there.
Could you please help me ?
thanks

Replies are listed 'Best First'.
Re: Help with DBD::JDBC
by MidLifeXis (Monsignor) on Nov 29, 2011 at 13:33 UTC

    Is it possible that there is a lock on a row that would be impacted by the delete or update? If you narrow the scope of the impact for a delete or update (say to a single row), does it complete?

    --MidLifeXis

Re: Help with DBD::JDBC
by InfiniteSilence (Curate) on Nov 30, 2011 at 01:55 UTC