How many connections does ADF BC make?
356442Dec 30 2004 — edited Mar 29 2009I'm having a little trouble with ADF BC in JDeveloper 9.0.5.2...
I'm rewriting an application to use BC but it seems BC really likes the database. A little bit to much
I've set the following settings in my configuration for the application module:
Application Pool: Max Pool Size = 100
Connection Pool: Max Pool Size = 100
We have a little test that tries to do as much as possible on the database through the persistence layer (BC).
However when i run that test ADF BC seems to go on making database connections (up and above 100 connections). That shouldn't be happening should it????
Eventually i'm getting ORA-00020: maximum number of processes (150) exceeded.
In my humble opinion that shouldn't happen because we have specified a max of 100 !!!
Am i doing something wrong?
I understand that an application module can keep it's connection when going back to the pool (Configuration.releaseApplicationModule) but as the Application pool has a maximum of 100 there still shouldn't be more than 100 connections!
Thanks to anyone who can help me...
Regards,
Robert