This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Author

a question on connection pooling

Chuan Ren
Ranch Hand

Joined: Aug 04, 2003
Posts: 42
Hi!

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?


-Tad
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: a question on connection pooling
 
jQuery in Action, 3rd edition