Session Number Increase

Session Number Increase

Postby ekarasu » Thu 29 Jun 2006 07:22

Hi,
Although we close the connections that are opened within our application, the session number of Oracle increases by time.

While connecting to oracle we use the syntax below

ConnectionString = "Server=X; uid = A; Password =X; Connection Lifetime=0";

Does this occur because of our ConnectionString?

We use Oracle Express 10g.
ekarasu
 
Posts: 15
Joined: Wed 01 Feb 2006 05:56

Postby Alexey » Thu 29 Jun 2006 09:49

Probably it is because of Connection Pooling feature. If you familiar with it please describe here what exactly is the problem.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby ekarasu » Thu 29 Jun 2006 20:39

No, I am not familiar with it.
ekarasu
 
Posts: 15
Joined: Wed 01 Feb 2006 05:56

Postby Alexey » Fri 30 Jun 2006 10:41

Please describe what exactly you need or what is the problem then.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby CrescentFire » Wed 26 Jul 2006 05:55

Hi,
We experience the same problem. Although we close connection in the application, the connection lives till application terminates.
CrescentFire
 
Posts: 1
Joined: Wed 26 Jul 2006 05:48

Postby Alexey » Wed 26 Jul 2006 08:25

It is because of Connection Pooling feature. For more information please read the FAQ of OraDirect .NET help documentation.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle