setting & using connection pool in beans for tomcat. - Mailing list pgsql-jdbc

 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.