Go out to Oracle technet, you can register for free, they have some really
good examples of connecting to the Scott schema using jdbc and they show how
to register the drivers pragmatically.
Also, you can download JDeveloper for free. Download it off of technet and
use test your connection inside the IDE. It allows you select a driver and
test the connection. Perhaps this is too much work, but if you are desperate
I found that starting off with JDeveloper helped in determining how to
connect and with what driver and the code snippets on technet helped a lot
with the syntax.
Ellis
-----Original Message-----
From: Stephen Casey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 11:59 AM
To: [EMAIL PROTECTED]
Subject: JDBC desperation
I am fighting a war here to introduce Java Servlets as an alternative to
CGI/Active Server Pages.
I am desperate to get my java servlet to connect to our Oracle database. My
environment is as follows:
Oracle 8.16 on IBM RS6000 (Unix) (with TCP/IP listner)
Microsoft Win2000 Adv Server running IIS 5 web server
JRun 3.0 Servlet engine
JRE 1.2 (from JRun 3 install)
Visual Cafe 3c IDE
Can you tell me what JDBC driver (OCI/Thin?) I should use in my servlets to
connect to Oracle 8i? I have tried using the 8.16 thin driver. I have placed
both zipped and unzipped paths in my CLASSPATH and PATH environmental
variables.
I have tried both DriveManager.registerDriver and Class.forName.
DriveManager.registerDriver( new oracle.jdbc.driver.OracleDriver()); will
produce the following error:
500 Internal Server Error
javax.servlet.ServletException: oracle/jdbc/driver/OracleDriver
java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
Any ideas or anyplace you can recommend for help?
?'s - Stephen 1-907-263-4315
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
