Shenanigans

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

Scribbled on Monday, November 5th, 2007

Setting up “CLASSPATH” variable:

This is the last part of setting Environment Variables
i) Goto Tomcat lib directory, it will be like “D:tomcat-6.0.10-preconfiguredapache-tomcat-6.0.10lib”Note down the path to a text file

Append these three files names: ojdbc14.jar, servlet-api.jar, jsp-api.jar, el-api.jar

Like this:

“.;D:tomcat-6.0.10-preconfiguredapache-tomcat-6.0.10libojdbc14.jar;

D:tomcat-6.0.10-preconfiguredapache-tomcat-6.0.10libjsp-api.jar;

D:tomcat-6.0.10-preconfiguredapache-tomcat-6.0.10libservlet-api.jar;

D:tomcat-6.0.10-preconfiguredapache-tomcat-6.0.10libel-api.jar;”

NOTE: There should not be any line break while saving in text file.

And save it to a text file, say b.txt.

NOTE: semicolon(;) is used to separate two paths, and period(.) is used for setting the default directory.

ii) Click on “new” button in opened Environment Variables panel and setup “CLASSPATH” variable using copied path from the text file, then click OK.

ii) You will see screen like this

::::::::::::::::::::::::PERIOD::::::::::::::::::::::::::::

You have done it. Now next step is to test the java program and troubleshooting oracle error.

Please refer to this blog post to know how to compile  and run JAVA program.

Till then watch this cool video by The Cardigans and the track is My Favourite Game:

Guess i could get that car with the chick as a hostage

httpv://www.youtube.com/watch?v=43qitcbdpvk

No related posts.

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