Nov 05

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

Scribbled on Monday, November 5th, 2007

  • Tomcat 6 Preconfigured

i) I suppose you have downloaded the zipped file, so now unzip/extract it to any drive/folder.

You can use 7zip (recommended)/winrar/winzip to extract the Tomcat Preconfigured zip file.

tomcatextzip.jpg

ii) Now download ojdbc14.jar file from here and the sample JAVA program from here.

NOTE: you may need to sign-up an account in esnips.com to download the above provided files. Sign-up is absolutely free and this site rocks.

iii) Save ojdbc14.jar in the lib directory/folder inside apache-tomcat-6.0.10 directory as shown in figure.

ojdbc14jardir.jpg

iv) Save dbAccess.java file any convenient location you can remember in your driver, here is mine location:

dbaccessloc.jpg

v) Lastly install Notepad++ to code JAVA programs.


Enjoyed this post? Subscribe to Full Feeds or by Email and receive free daily updates on this Blog.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

  1. 4 Responses to “A concise guide to setup Oracle database connection with Java/JSP”

  2. 1

    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

  3. 2

    Am glad you liked the walkthrough :)

    By visio159 on Wed 19th Dec, 2007

  4. 3

    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

  1. 1 Trackback(s)

  2. May 15, 2008: A concise guide to setup Oracle database connection with Java/JSP « A Bittersweet Life | blog

Post a Comment

November 2007
M T W T F S S
« Aug   Dec »
 1234
567891011
12131415161718
19202122232425
2627282930