Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

DB Pool Connections

Posted on 2006-06-02
6
Medium Priority
?
278 Views
Last Modified: 2010-04-01
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
0
Comment
Question by:princehyderabad
  • 3
  • 3
6 Comments
 
LVL 29

Accepted Solution

by:
bloodredsun earned 400 total points
ID: 16819855
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
 

Author Comment

by:princehyderabad
ID: 16906206
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
 

Author Comment

by:princehyderabad
ID: 16906251
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 29

Assisted Solution

by:bloodredsun
bloodredsun earned 400 total points
ID: 16907249
It's not the same as Tomcat but it's all here http://www.caucho.com/resin-3.0/db/index.xtp
0
 

Author Comment

by:princehyderabad
ID: 16908010

.."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
 
LVL 29

Expert Comment

by:bloodredsun
ID: 16909650
Either resin-web.xml or resin.conf.

Just read the tutorial, it's all there.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Choosing the right mix of apps is very much necessary for CPAs for making the most of the latest technology through which they can boost their growth.
The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month14 days, 18 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question