Page 1 of 1

Oracle sessions and delphi threads

Posted: Wed 29 Jan 2014 07:33
by amoroder
Hello,

I am writing a windows service that should do different jobs in threads. All the threads have to connect to the same oracle database and schema.
Is it possible to work with only one session or do I have to create a session for every thread ?

Thanks
Andreas

Re: Oracle sessions and delphi threads

Posted: Wed 29 Jan 2014 08:34
by AlexP
Hello,

Full thread-safety is really guaranteed in the OCI mode, we recommend to use a separate connection for each thread in the Direct mode

Re: Oracle sessions and delphi threads

Posted: Sun 02 Feb 2014 12:31
by jfudickar
What does it mean : full thread safety?
My experience show that it's not possible to have to sql statements executed at the same time.

Regards
Jens

Re: Oracle sessions and delphi threads

Posted: Wed 07 May 2014 12:41
by AlexP
You can find samples of work with threads in ODAC in the demos: ..\Devart\ODAC for RAD Studio XE\Demos\OdacDemo\Threads\