a question on connection pooling

[Chuan Ren]

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]

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:

<Context path="" docBase="ROOT" debug="0">
           <Resource name="jdbc/CecomDB" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/CecomDB">

in your server.xml?


-Tad