DB Pool Connections

hi experts,

I'm looking for JSP pages where I need lot of DB. I dont wanna use DB:name/user/pass for each page. Rather I wanna have this DB initial at one page and call where ever DB function required. My DB is My-SQL. Any good link to start with.

Thx,
PH
princehyderabadAsked:
Who is Participating?
 
bloodredsunCommented:
Use a DataSource to get your DB connection from a pool.

http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html
0
 
princehyderabadAuthor Commented:
I was trying to config as per the URL above. But I dont see where should I edit my server.xml
NOTE: I'm using shared web hosting. I only have <web-inf> folder.
0
 
princehyderabadAuthor Commented:
Okay I enquired my hosting company is not using tomcat they using 'Resin'

anyone know with 'Resin' how the connection Pooling is done ??? do we need server.xml or just having in web.xml is fine.

0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
bloodredsunCommented:
It's not the same as Tomcat but it's all here http://www.caucho.com/resin-3.0/db/index.xtp
0
 
princehyderabadAuthor Commented:

.."Configure the JNDI DataSource in Tomcat by adding a declaration for your resource to $CATALINA_HOME/conf/server.xml.".......

what is the equalivalent of above line in "RESIN"
0
 
bloodredsunCommented:
Either resin-web.xml or resin.conf.

Just read the tutorial, it's all there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.