I would upgrade, commit did not work for DBD::Proxy in DBI-1.20.
There is a patch, it would be better to upgrade to the latest DBI.
On 13-Jun-2002 Antoine Janssen (12move) wrote:
> 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
>> >
>> >
>
>
----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 13-Jun-2002
Time: 15:44:22
----------------------------------
