Hi Frank and Bjaki,
Thank you for your quick responses, I really appreciate it.
I believe my problem is as you suggested, I have no classes12.zip at the right directory.
My situation is a little awful. As a student, I am assigned a servlet directory to make my servlets work. However, I have no right to set up the server directly, for example, restart it.
That is the reason I put the unzipped class12.zip in my servlet directory in unix.
I hope I can manage it by myself so I do not have to talk with the people who set up the
tomcat, who is not quite familiar with
JDBC and Orcale.
It is really strange, after I put seemly unzipped class12.zip in my servlet directory, I have no problem to connect the oracle in the main method of my servlet, but I have the problem when i put it in the doGet(). Could you please explain waht is going on? I am confused.
Based on Bjarki's solution, I excute command in my UNIX account as
export CLASSPATH=$CLASSPATH:/home/chris/classes12.zip
based on my directory path. Then I rename the oracle directory previously in my servlet directory. I found it did not work.
Sorry for my unix 101 question, do you think I am on the right track to the solution?
In addition, I eventually can connect to oracle by write a stand alone DBServer program, in which main method, I open a socket and connect to the Oracle using the same codes in the servlet, then I contact this socket in doGet() in my servlet program, and I can work it out. BUT, this is an AWFUL solution and I need more coding and have the worse overall design. And it makes me more confused with the servlet, what is going behind it?
Too many questions, sorry about it.
Chris