Hello,

I have been reading about setting up connection pooling with tomcat.
What I have read refers to jsp, but all my database access is running through beans. Will connection pooling operate with beans called via jsp?

Could me the JDBC connection pooling mean while have setup check

You can access the following Document to configure your Oracle with Sun One Application Server
http://www.angelfire.com/nj4/najmi/S...cleConfig.html

for MySQL you can refer some of the links

http://p2p.wrox.com/topic.asp?TOPIC_ID=18624

Hello,

Thanks, but this doesnt help me.
Connection poolling is set up in server xml and I understand all I need to about this.

What I am unsure about is whether I have to user JNDI to get it to work.

I do not want to configure web.xml for the database connection, although I know how to do this also.

The way I have designed my pages is to use a java bean to get connections and return resultsets, so all I have to do is pass strings from my jsp to the bean. I like this as it keeps the jsp clean and would prefer to continue with this way of working.
But will connection poolling defined in server.xml work with this methodology?

Everything I read makes reference to JNDI and I am not sure whether pooling is dependant on it.

In short, is dbcp dependant on jndi???

In reply to my own question I need to change the way my bean connects from setting up the connection itself to using JNDI, then my bean will make use of pooling.