File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes a question on connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "a question on connection pooling" Watch "a question on connection pooling" New topic

a question on connection pooling

Chuan Ren
Ranch Hand

Joined: Aug 04, 2003
Posts: 42

I am looking at using Jakarta Common DBCP to manage my database connection. However, I am a bit confused on how to use this. I understand I could setup a data source in Tomcat to achieve the parameter setting.

However, I am looking at doing something which is independent of the application server. How can I setup those parameters for DBCP? Any advice or example is much appreciated.

Thank you.
Tad Dicks
Ranch Hand

Joined: Nov 16, 2004
Posts: 264
I'm not sure I fully understand your question.

Do you want to setup the datasource inside your application? Instead of having it setup inside the server.xml? If you use struts you can set up the DataSources inside your struts-config.xml, or you could use something like ibatis or hibernate to manage your database access. Or lastly you can configure access inside of your own servlets (or even jsps if you want to get really messy).

Are you trying to avoid something like:

in your server.xml?

I agree. Here's the link:
subject: a question on connection pooling
It's not a secret anymore!