Re: EOF Connection Pooling?
Re: EOF Connection Pooling?
- Subject: Re: EOF Connection Pooling?
- From: Chuck Hill <email@hidden>
- Date: Thu, 24 Nov 2005 17:51:16 -0800
On Nov 23, 2005, at 5:26 AM, Dov Rosenberg wrote:
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?
I'm pretty sure that it only will if there are multiple EOF stacks or
if you are doing some funky fetches within fetches. With multiple
EOF stacks you will get the same synchronization issues as running
multiple instances.
Chuck
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:
40cluster9.com
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:
40global-village.net
This email sent to email@hidden
--
Coming in 2006 - an introduction to web applications using WebObjects
and Xcode http://www.global-village.net/wointro
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