setting & using connection pool in beans for tomcat.

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