Re: Too Many Oracle Sessions when running my WOApp
Re: Too Many Oracle Sessions when running my WOApp
- Subject: Re: Too Many Oracle Sessions when running my WOApp
- From: Chuck Hill <email@hidden>
- Date: Thu, 16 Nov 2006 13:42:45 -0800
How are you creating editing contexts? It sounds like you are
creating a new EOF stack (and hence new DB connection) for each one.
Also, do you have any code that connects directly to the database
bypassing EOF?
Chuck
On Nov 16, 2006, at 1:08 PM, Peter wrote:
Hi,
I am have a strange situation that seems to have started over a month
ago. Whenever I go to a new page in my application, I am getting a
new database session. This occurs even when I "refresh" the page.
Eventually, I am having over 100 sessions when I am the only one
connected.
If I stop the application, the database sessions disappear and
everything settles back down to baseline. If I do not stop the WO
application, eventually other developers cannot even start a new
instance of the application and even logging into the UNIX server
where the database is located is problematic due to resources being
temporarily unavailable.
I am running my app from Xcode, using an Oracle (10g) database on Mac
OS X Server.
Has anyone ever experienced this? Any direction or hints would be
appreciated. I can do the leg work, I just need a few pointers on
which areas I should be looking into.
Thanks
Pete.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden