Hi All, I have been googling connection pooling, and most of the info I am finding is regarding making a connection for a web app. I have a stand alone java app, so not using Apache, tomcat, etc. Are there any non web-app connection pool packages ? Also, is using the DataSource object just something for web apps? Thanks, Kim
Well, you only really need connection pooling from multiuser applications, and a web application is probably the most common example of that. Can't think why a desktop application would necessarily need pooling.
You might look at c3p0. [ March 19, 2007: Message edited by: Paul Sturrock ]
Oh, thanks, that makes sense. I guess I was thinking I needed pooling because my app is multi-threaded, but each thread has its own object which makes its own database connection, so I guess you are right, I wouldn't need pooling in this case.