 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / July 2005[JDBC] Connection pooling
Hi! Here are a few things I don't understand about connection pooling. The DBCP API seems to be what I need, but I've read some articles about using Tomcat to manage connection pooling rather than doing it by hand. What I don't understand is that I need a servlet and my app isn't a webapp at all. So what's the advantage to use Tomcat rather than a simple PoolingDataSource ? Is it only the ability to set dead connection detection (connections we have forget to return to pool) ? If it is really more interesting, I absolutely don't understand how to call the servlet from by app and how to get a ResultSet from it. Could someone help me please. TIA  SignatureArnaud Hi, of course you should only use a tomcat when your app is a webapp. You cant use the tomcat connection pooling with normal apps. Regards Michael > Hi! > [quoted text clipped - 16 lines] > > TIA Thanks for the answer, it happened to drive me crazy ! -- Arnaud > Hi, > [quoted text clipped - 4 lines] > > Michael Michael, Not entirely correct. DBCP is a separate component that can be used in _any_ Java application. However, for standalone use, I like c3p0, from http://c3p0.sf.net/ Regards, -Mark SignatureMark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com > > Hi, I was under the impression (from reading not from experience) that Oracle has connection pooling built in to their driver. ojdbc14.jar > Michael, > [quoted text clipped - 10 lines] > MySQL AB, Software Development Manager - Connectivity > www.mysql.com ditto on c3p0. i've been using it for some time now and haven't had any problems. i do see people post issues from time to time to the mailing list, but steve's responses are usually extremely fast, and his attention to the product is impressive. i decided to try it before dbcp after reading a number of warnings on various groups about dbcp. i've found c3p0 to be quite easy to use, as well. >> > Hi, > [quoted text clipped - 16 lines] >> MySQL AB, Software Development Manager - Connectivity >> www.mysql.com Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.