The included program is NOT a servlet. It will run fine as an application.
I don't know if there are compatibility issues between Oracle JDBC 8.0.5.0.0
and JSDK 2.0, but that isn't really the right question. If your JDBC driver
works with your database, then you are okay. If the JSDK 2.0 works with
your web server, then you are okay. Then it is a matter of simply creating
a servlet that does all of the correct JDBC stuff to get to your database
and return a proper HTML document.
Tom Lageson
[EMAIL PROTECTED]
> ----------
> From: Florence Tan[SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology.
> Sent: Monday, June 14, 1999 4:07 AM
> To: [EMAIL PROTECTED]
> Subject: Oracle JSDK question
>
> <<File: florence.vcf>>
> Hi all,
>
> I would like to know if Oracle JDBC (Thin) Driver release 8.0.5.0.0
> support JSDK2.0?
>
> We have installed the above JDBC Driver in Solaris 2.5.1 and I tried to
> run the sample program (Employee.java) as below :
>
> /*
> * This sample shows how to list all the names from the EMP table
> *
> * It uses the JDBC THIN driver. See the same program in the
> * oci7 or oci8 samples directories to see how to use the other drivers.
> */
>
> // You need to import the java.sql package to use JDBC
> import java.sql.*;
> import java.math.*;
>
>
> class TestDb
> {
> public static void main (String args [])
> throws SQLException
> {
> // Load the Oracle JDBC driver
>
> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
>
> // Connect to the database
> // You must put a database name after the @ sign in the connection
> URL.
> // You can use either the fully specified SQL*net syntax or a short
> cut
> // syntax as <host>:<port>:<sid>. The example uses the short cut
> syntax.
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@myhost:1521:orcl","scott","tiger");
>
> // Create a Statement
> Statement stmt = conn.createStatement ();
>
> // Select the ENAME column from the EMP table
> ResultSet rset = stmt.executeQuery ("select ename from emp");
>
> // Iterate through the result and print the employee names
> while (rset.next ())
> System.out.println (rset.getString (1));
> }
> }
>
>
> There is no error during compilation but however when I run it as a
> servlet using Jrun. It gives me this error :
>
> 500 Internal Server Error
>
> Employee:
>
> Could not load servlet
>
>
> I can't figure out what is the problem ? Is it that this sample should
> not run as a servlet or is it that there are some setting that I missed
> out or ????
>
> Thanks for the help !
>
> Regards,
> Florence.
>
>
___________________________________________________________________________
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
