Hi, Please don't mention names in messages ;) There are a ton of people on this list who are at least as qualified as I am to answer any question...
>I have coded my own Oracle connection pool which which sets up a pool of >physical db connections. A servlet or a thread can request a connection >and when thru, drops it for recycling. The tme-out of a thread will also >make it available to another thread. OK. Personally, I like to use something that exists already rather than code my own / re-invent the wheel. But if you like and trust your implementation, good for you ;) >How would this interact with Tomcat's pooling ??? It wouldn't. Tomcat doesn't provide its own connection pooling implementation, only support for you to tell the server what connection pooling implementation you wish to use. The commons-dbcp package and the Oracle connection cache, and many others, can be used with tomcat. If your implementation complies with the JDBC interfaces, you should be able to configure tomcat to use your connection pooling implementation. In addition, you can define side-by-side pools, e.g. one connection pool using DBCP, one Oracle. Run the app using DBCP once, then run it again using Oracle, for example. This is a good test as to which one is better for your specific app. >What significant advantages does Tomcat pooling has (other than one >doesn't need tp code it) ??? That it's 3rd party and you can complain loudly on the lists if you find a bug in it ;) You can get support for it, whereas for example with your custom implementation, if there's a bug no one will be able to help you... Yoav Shapira Millennium ChemInformatics
This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you.
-- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
