Re: Rows returned are out of sync with the request.



Garrett, Philip (MAN-Corporate) wrote:
Stephen Carville wrote:

I'm not quite sure how to describe this problem.

When I make a call to an Oracle 10g database using DBI and SQLRelay
(for connection pooling) I seem to get results from the previous
SELECT.


What happens when you use DBI *without* SQLRelay?

Dunno yet. I have to rewrite this and one other program to use direct
connections. I cannot switch to direct connections across the board
beacause other programs share the code and make aobur 3000+ connections
per hour during the busy part of the day

Philip


--
Stephen Carville <stephen@xxxxxxxxxxxxxx>
Unix and Network Admin
Nationwide Totalflood
6033 W. Century Blvd
Los Angeles, CA 90045
310-342-3602

.



Relevant Pages

  • DBI Module.
    ... We are trying to implement a better "timeout" for the DBI connections, ... the one incorporated in the DBI module only has a granularity of seconds. ...
    (perl.dbi.users)
  • many database connections causes Cant locate Carp/Heavy.pm
    ... I am purposefully attempting to open ~1000 database connections using ... DBI and DBD-Oracle. ... After about 255 connections I am getting ...
    (perl.dbi.users)
  • Measuring wait time for openning a new connection
    ... using DBI) which opens many connections to ... the database. ... Will I see the effect of the connections on the wait events? ...
    (comp.databases.oracle.server)
  • ADO Interop - SQL Server 2000 connections not released
    ... - DB is SQL Server 2000 ... When the ASP page is executed...no matter how many calls to the COM+ ... objects, connections, recordsets, etc. are properly set to nothing upon exit. ... We have tried OLE DB Services=-4 to disable connection pooling and the ...
    (microsoft.public.data.ado)
  • DBCP + Weblogic = Runaway Leaks. Please help
    ... I'm facing a serious issue with connection pooling and I'd appreciate ... My dev environment uses Tomcat ... So instead of defining my datasources in an XML ... INACTIVE connections to my main Oracle DB in 1 node and about 3 in the ...
    (comp.lang.java.databases)