Multithread / direct connect

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Jean-Luc Pascal
Posts: 2
Joined: Wed 08 Nov 2006 13:32

Multithread / direct connect

Post by Jean-Luc Pascal » Wed 08 Nov 2006 16:41

Hello,
I use ODAC 5.70 / Oracle 10.1.0.5 G with C++ Builder 6.0. I have a multithreaded application which fails from time to time on simple select statements (they return 10 rows). The error I receive is always "out of memory".
In my application I use a different TOraSession and TOraQuery for each thread.
With the previous old BDE from Borland everything were fine. Could it be that the "Direct Connect" option raises this problem ? Should I do something specific to my multithreaded application ?
Thanks a lot

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 10 Nov 2006 12:29

Possibly this problem is caused by memory leaks in your program. To detect memory leaks you can use a third party memory manager such as FastMM4 or special tools (AQTime, MemProof).

Jean-Luc Pascal
Posts: 2
Joined: Wed 08 Nov 2006 13:32

Post by Jean-Luc Pascal » Fri 10 Nov 2006 13:11

I'm afraid I have no memory leak. The same application works fine with the borland BDE. Here I get an exception when executing a Select statement, in the exception message I have "Out of memory". If I had memory leaks then my app would consumes more and more memory and I will able to see it in the TaskManager application. A memory leak would not throw an exception.
In the meanwhile I've tried not to use the direct connect option, so now I use the Oracle client but I still have this "out of memory" for different Sql statements which have been tested and do not fetch a huge amount of rows.
What is strange is that only Select statements fails, never an Insert or Update.
In the list of exception error messages that can be returned for a Select, do you have this "out of memory" message ?
Best Regards

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 13 Nov 2006 14:53

The list of ODAC error messages doesn't contain the "Out of memory" message. We cannot reproduce this problem. Please send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

Post Reply