Hi,
I am connecting to several Oracle databases in parallel with dotConnect for Oracle using multithreading in C#. Each thread makes a separate Oracle connection. The problem is that when I have more than 15 threads (each one having it's own connection) I get error "server did not respond within the specified timeout interval devart threads". The error doesn't arise when I am using 4 threads or making 4 simultaneous connection using dotConnect for Oracle. Please let me know if dotConnect for Oracle has some limitation while using multithreading. If not please help me how can I get rid of this error and make connection in several threads successfully. Thanks very much.
Regards
Mani
timeout while using devart in multithreading
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: timeout while using devart in multithreading
dotConnect for Oracle does not have limitation on opening connection in multithreading. The only limitation dotConnect for Oracleis that dotConnect for Oracle is not thread safe. If you want to use a multithreaded application, you need to create an OracleConnection instance for each thread.manibhatti wrote:Please let me know if dotConnect for Oracle has some limitation while using multithreading.
Probably you have reached some Oracle server limitation. For example this can be the limit of concurrent sessions. You can check it with the following commands:
The maximal number of sessions:
Code: Select all
SELECT name, value
FROM v$parameter
WHERE name = 'sessions'
Code: Select all
SELECT COUNT(*)
FROM v$session