restarting the proxyserver didn't solve the problem
here the error log from the proxyxserver:
Tue Jun 18 13:00:49 2002 debug, Connection from 131.174.88.30, port 59563
Tue Jun 18 13:00:49 2002 debug, Child clone:
DBI::ProxyServer=HASH(0x83698cc)
Tue Jun 18 13:00:49 2002 debug, New child starting
(DBI::ProxyServer=HASH(0x83698cc)).
Tue Jun 18 13:00:49 2002 debug, Accepting client from 131.174.88.30, port
59563
Tue Jun 18 13:00:49 2002 debug, Client logs in: Application
DBI:Oracle:host=mymachine.cmbi.kun.nl;sid=oralin;port=1521, version 0.2003,
user scott
Tue Jun 18 13:00:49 2002 debug, Connecting to
DBI:Oracle:host=mymachine.cmbi.kun.nl;sid=oralin;port=1521 as scott
Tue Jun 18 13:00:49 2002 debug, Accepting client
Tue Jun 18 13:00:49 2002 debug, Client executes method CallMethod
Tue Jun 18 13:00:49 2002 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x8392fd4),STORE,AutoCommit,0
Tue Jun 18 13:00:49 2002 debug, CallMethod: <= 1
Tue Jun 18 13:00:49 2002 debug, Client executes method CallMethod
Use of uninitialized value in join or string at
/usr/lib/perl5/site_perl/5.6.1/i586-linux/DBI/ProxyServer.pm line 210.
Tue Jun 18 13:00:49 2002 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x8392fd4),prepare,INSERT INTO
SEQ_CONTIG_MANIPULATIONS (ID,PERFORM_DATE,REMARKS) VALUES
(998,'01-may-01','no remarks'),,ARRAY(0x83be1ac)
Use of uninitialized value in join or string at
/usr/lib/perl5/site_perl/5.6.1/i586-linux/DBI/ProxyServer.pm line 218.
Use of uninitialized value in join or string at
/usr/lib/perl5/site_perl/5.6.1/i586-linux/DBI/ProxyServer.pm line 218.
Tue Jun 18 13:00:49 2002 debug, CallMethod: <=
DBI::ProxyServer::st=HASH(0x83971b4),0,0,,,1
Tue Jun 18 13:00:49 2002 debug, Client executes method DestroyHandle
Tue Jun 18 13:00:49 2002 debug, Client executes method CallMethod
Tue Jun 18 13:00:49 2002 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x8392fd4),func,commit
Tue Jun 18 13:00:49 2002 err, DBI::ProxyServer::db=HASH(0x8392fd4)->func()
invalid redirect method name 'commit' at
/usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332.
Tue Jun 18 13:00:49 2002 debug, Client executes method DestroyHandle
Tue Jun 18 13:00:49 2002 debug, Child terminating.
Antoine Janssen
> You will need to stop and re-start the proxyserver daemon after upgrading,
I
> just got caught out by that.
>
> Can you produce a simple script which shows the DBI::ProxyServer error
> message?
>
> --
> David Adams
> Computing Services
> Southampton University
>
>
> ----- Original Message -----
> From: "Antoine Janssen" <[EMAIL PROTECTED]>
> To: "Tim Bunce" <[EMAIL PROTECTED]>; "David Adams"
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, June 17, 2002 1:35 PM
> Subject: Re: commit doesn't work with dbi::proxyserver
>
>
> > Upgrading does not solve the problem.
> >
> > Im now using
> > DBI version : 1.28
> > DBI::ProxyServer version : 0.2005
> > on both the machine that holds the db (and the proxyserver) and the
> machine
> > that runs the script
> >
> > the error message:
> >
> > DBD::Proxy::db commit failed: Server returned error: Failed to execute
> > method CallMethod: DBI::ProxyServer::db=HASH(0x8388ad4)->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
> > > >
> > > >
> >
> >
>
