• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: JNDI Datasource vs JDBC (Tomcat deployment)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: JNDI Datasource vs JDBC (Tomcat deployment)


  • Subject: Re: JNDI Datasource vs JDBC (Tomcat deployment)
  • From: Andrew Lindesay <email@hidden>
  • Date: Wed, 12 Nov 2008 21:28:34 +1300

Hello Tonny;

I think there was some talk here weeks ago (and something I had wondered about a while back) about using an object store coordinator pool. I think Mike brought it up -- Mike?

cheers.

Can't quite see how that will work with webobjects (in it's out of the box state), in WO you a multiple threads (when concurrent request handling is enabled) which uses a a synchronized data store. That combined WO's request handler locking strategies makes WO single threaded in practice.

The servlet container philosophy is more along the lines that no thread should wait for data access, hence the connection pool. Making servlet containers truly multithreaded.

Even if EOF could use a connection pool, i don't think it would change anything the EO object store it self is synchronized (by NSLock), so only one connection would ever used at any given time.
...
Does anyone know what the advantages/disadvantages are for using a JNDI Datasource with a Jakarta Commons Database Connection Pool (DBCP) compared to letting WebObjects (or more specifically Project Wonder if it makes a difference in the way a JDBC connection or pooling is handled) handle the database connection? The application will only ever be deployed in a Tomcat container.
Any use cases where the one would be a strong favourite over the other?

___ Andrew Lindesay www.lindesay.co.nz

_______________________________________________
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


  • Follow-Ups:
    • Re: JNDI Datasource vs JDBC (Tomcat deployment)
      • From: Mike Schrag <email@hidden>
References: 
 >JNDI Datasource vs JDBC (Tomcat deployment) (From: Peter Newnam <email@hidden>)
 >Re: JNDI Datasource vs JDBC (Tomcat deployment) (From: "Tonny Staunsbrink" <email@hidden>)

  • Prev by Date: Re: Frontbase CLOB newline problem
  • Next by Date: Re: <SOLVED>Frontbase CLOB newline problem
  • Previous by thread: Re: JNDI Datasource vs JDBC (Tomcat deployment)
  • Next by thread: Re: JNDI Datasource vs JDBC (Tomcat deployment)
  • Index(es):
    • Date
    • Thread