Regarding accessing oracle

Posted on 2006-05-09
Last Modified: 2010-04-01
I want to develop a website using JSP. I want to access Oracle from my JSP pages. Want to know what are the ways to do it and  which one will be the best.  Also i want know which are freeware in it.

Question by:pigeon5566

    Author Comment

    Also i need some good tutorial links for it accessing oracle from JSP pages
    LVL 29

    Accepted Solution

    Use JSTL. It's by far the easiest way if you are not an expert. See here for an oracle specific example
    LVL 3

    Expert Comment


    in my opinion use the connection pooling described in:


    Author Comment

    i am planning to use tomcat only. Can i use jstl in that one.  Is it used only for oracle db.
    LVL 3

    Expert Comment

    jstl has no relation with DBs, oracle , etc.
    it is an easy way of writing JSPs.
    LVL 29

    Expert Comment

    >>Can i use jstl in that one

    Yes, very easily.

    >>Is it used only for oracle db.

    No, the sql library is only one of the 5 libraries of JSTL (core, xml, format, sql and function)

    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

    Suggested Solutions

    Title # Comments Views Activity
    Problem with Pie chart in Jsp 20 157
    JSP Popup page 2 83
    how to exclude a file using regex 5 113
    maven j2ee examles 2 41
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    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

    19 Experts available now in Live!

    Get 1:1 Help Now