Re: Rows returned are out of sync with the request. ... When I make a call to an Oracle 10g database using DBI and SQLRelay... (for connection pooling) ... I cannot switch to direct connections across the board ... (perl.dbi.users)
Re: patches available for DBD::Multi, and benchmarking results ...DBIx::HA is certainly not the panacea and it sucks to be doing high availability as a subclass of DBI, but it's better than doing brute force dereferencing by having a real statement handle as an object reference to a fake statement handle created by DBD::Multi. ... As long as Perl doesn't have excellent thread management, proper connection pooling can't be done in the DBI codebase ... You don't gain much by using ResourcePool for DBI resources. ... Connection pooling is a somewhat different beast than HA, part performance boosting and part resource minimization. ... (perl.dbi.users)
RE: fetchrow_array performance ... I agree - set RasieError.... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ... (perl.dbi.users)
Re: Evaluated "require $database" not found. ...DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ... (perl.dbi.users)
Re: Cant call method "prepare" on an undefined value ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ...Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script.... (perl.dbi.users)
