A concise guide to setup Oracle database connection with Java/JSP
Scribbled on Monday, November 5th, 2007 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:
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)
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
4 Responses to “A concise guide to setup Oracle database connection with Java/JSP”
Hi
Thats a very cool guide / walk-through
{I play a lotta games}
i have the following setup:
Oracle 9i
Resin 3.0.17 Web server
JDK 1.5
i think i can edit the dbAccess.java to work on the same…
thnx CIAO
shabbir
By shabbir on Tue 18th Dec, 2007
Am glad you liked the walkthrough
By visio159 on Wed 19th Dec, 2007
Hi please if you were work on linux please let me know.
I have Suse 10 and Oracle 10g installed and I want to do this on Suse with jakarta tomcat
By Luis on Fri 11th Apr, 2008