Re: Re: Too Many Oracle Sessions when running my WOApp
Re: Re: Too Many Oracle Sessions when running my WOApp
- Subject: Re: Re: Too Many Oracle Sessions when running my WOApp
- From: Peter <email@hidden>
- Date: Thu, 16 Nov 2006 19:32:34 -0500
Hi Chuck,
We do have a few old raw rows for SQL, but they have been in the code
for awhile.
I will look to see about the editing context. It is possible
something crept into our code base when we were working on our Page
Wrapper - this a likely source since most pages are wrapped, and if we
are creating an additional context in there, refreshing the page,
would show it. It also may be in some modifications to the subclass
of EOEditingContext that we use. I will report back to the list if I
uncover anything interesting as I look through our repository.
Thanks for the tips.
Pete.
On 11/16/06, Chuck Hill <email@hidden> wrote:
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