Re: setting & using connection pool in beans for tomcat.

Simon,

Have you looked at

http://jdbc.postgresql.org/documentation/head/tomcat.html

Dave
On 16-Dec-05, at 5:10 AM, Simon Moses wrote:

> dear sir,
>
> i have set connection pooling in tomcat. now i can use connections
> from that pool in jsp.
>
> but i want all database accessing code in beans not in jsp. how to
> do it?
>
> i want to write a class(CPCon.java) with methods like
> {
> void ConnectionPoolOpen(){}
> Connection getConnection(){}
> void closeConnection(){}
> ....
> }
>
> and call this class in all jsp pages with useBean tag.
>
> if i write like this, is the connection pool is going to be used by
> all jsp pages for all tomcat server clients?
>
> if not how to do this?
>
> i am using tomcat 5.0. j2se1.4 and postgresql 8.0 with
> postgresql-8.0-312.jdbc3.jar driver.
>
> regards,
> Simon Moses.
>
>
>
> **************************
> Visit My Home Page
> http://www.geocities.com/ks_moses
> updated: 28 Sep 2004.
> Simon Moses
> **************************
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com