I'm using DBI version 1.20 with DBI::ProxyServer version 0.2004
here's the sample code:
$dbh =
DBI->connect("dbi:Proxy:hostname=$host_name;port=$port;dsn=DBI:Oracle:host=$
host_name;sid=$sid;port=$local_port",$user,$passwd,RaiseError=>1,
PrintError=>1, AutoCommit=>0}) or die $DBI::errs;
#$dbh->{AutoCommit} = 0;
my $sql = "INSERT INTO SEQ_CONTIG_MANIPULATIONS (ID,PERFORM_DATE,REMARKS)
VALUES
(2,'01-may-01','blah')";
$dbh->do($sql);
$dbh->commit;
$dbh->disconnect;
and here the error:
DBD::Proxy::db commit failed: Server returned error: Failed to execute
method CallMethod: DBI::ProxyServer::db=HASH(0x8388adc)->func() invalid
redirect method name 'commit' at
/usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332.
> Or perhaps you need to upgrade.
>
> Tim.
>
> On Thu, Jun 13, 2002 at 01:22:39PM +0100, David Adams wrote:
> > $dbh->commit works fine for me using proxyserver to access an Oracle
> > database. Perhaps if you included a code listing and a few more details
> > someone will spot the cause of your problem.
> >
> > --
> > David Adams
> > Computing Services
> > Southampton University
> >
> >
> > ----- Original Message -----
> > From: "Antoine Janssen" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, June 11, 2002 3:43 PM
> > Subject: commit doesn't work with dbi::proxyserver
> >
> >
> > hi,
> >
> > i'm trying to commit some changes with $dbh->commit(); while using
> > dbi::proxyserver but get the following error message
> >
> > DBI::ProxyServer::db=HASH(0x8389228)->func() invalid redirect method
name
> > 'commit' at /usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332.
> >
> > is it a bug in dbi::proxyserver? what goes wrong??
> >
> > if i disable transactions ($dbh->{AutoCommit} = 1) and don't use
> > $dbh->commit() everything works fine.
> >
> > Antoine Janssen
> >
> >
