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
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: Read on…






