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
Multithread / direct connect
-
Jean-Luc Pascal
- Posts: 2
- Joined: Wed 08 Nov 2006 13:32
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
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