Visio159

A concise guide to setup Oracle database connection with Java/JSP

November 5, 2007 – 5:37 am

Updated on: 03 August, 2008 at 1:16 AM IST

It was one part of our project. The whole thing was a mess to deal with. I couldn’t find out a single guide that was simple and concise enough to get me working with project. So here is the whole guide to setup the connection and troubleshooting the problems.

a) The softwares I used:

1) Java 1.6

2) Oracle 9i

3) Tomcat 6 preconfigured

4) Notepad++ (Though i could have used netbeans or eclipse to code but that would take away the basics from me)

b) Installing the above softwares:

• Java 1.6 installation was just click and install type, no customization screens to select.

• Oracle 9i - Go with default settings, and when presented with Database screen select “DNS”(without quotes) as your database, as the program provided here are using the same name.

Here are screenies to help you out:

NOTE: Please disable your firewall before installing Oracle 9i, the installation may fail to install some components in case. And for that interval of time just shut down your internet connection to be on safer side.

i)

ii)