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 PROTECTED]> 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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/david.teran% 40cluster9.com

This email sent to [EMAIL PROTECTED]





 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net

This email sent to [EMAIL PROTECTED]

--
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      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to archive@mail-archive.com

Reply via email to