Re: EOF Connection Pooling?
Re: EOF Connection Pooling?
- Subject: Re: EOF Connection Pooling?
- From: Dov Rosenberg <email@hidden>
- Date: Wed, 23 Nov 2005 08:26:21 -0500
- Thread-topic: EOF Connection Pooling?
Title: Re: EOF Connection Pooling?
Thanks – I will check it out. Does this mean that EOF will use multiple db connections? How do the other connections get used? Is it based on load? Round robin? Are there any synchronization issues?
Dov
On 11/23/05 3:36 AM, "David Teran" <email@hidden> wrote:
HI Dov,
JavaERJDBCAdaptor has connection pooling capability. Its based on code from Lenny Marks and integrated into Wonder. It does -not- use a tomcat related datasource but the code should help you to use another pool. Check it out.
regards, David
Am 22.11.2005 um 16:15 schrieb Dov Rosenberg:
Is there any way to convince EOF to use a database connection pool? I noticed that there appears to be some JNDI lookup for a datasource but I could not get it to use a Tomcat connection pool. It looks like there needs to be something set up in the EOModel but could not come up with the correct combination of chicken blood and ritual sacrifice to get it to work properly.
My primary motivation is that our apps are deployed as servlets which makes it harder to run multiple instances of an app in the same container like JavaMonitor enables when you run as a regular WO application. The only way we can get multiple db connections seems to start multiple instances on different machines or run multiple servlet containers on the same box.
I saw some references to EOF and multiple connection stacks that looked promising but very complex. Has anyone done this, if so are there any rules that we should follow.
We have 2 apps. One is a regular WO app deployed as a servlet the other is a little different. It uses a sharededitingcontext for performance caching. We may be changing that in the future, but I am a little concerned with dealing with multiple EOF stacks while using a SharedEditingContext
--
Dov Rosenberg
Conviveon/Inquira
Knowledge Management Experts
http://www.conviveon.com
http://www.inquira.com
_______________________________________________
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
_______________________________________________
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