DB Pool Connections

Posted on 2006-06-02
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.

Question by:princehyderabad
    LVL 29

    Accepted Solution

    Use a DataSource to get your DB connection from a pool.

    Author Comment

    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.

    Author Comment

    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.

    LVL 29

    Assisted Solution

    It's not the same as Tomcat but it's all here

    Author Comment


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

    Expert Comment

    Either resin-web.xml or resin.conf.

    Just read the tutorial, it's all there.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Outlook Free & Paid Tools
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now