the example you show here is not a servlet, meant to be run at shell to test the db
connection and simple sql.
-----Original Message-----
From: Groenescheij, Michel [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 14, 1999 5:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Oracle JSDK question
Hi,
We have some Oracle specialists working here and he says
it does not support it.
> -----Original Message-----
> From: Florence Tan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 14, 1999 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: Oracle JSDK question
>
>
> 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.
>
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Hi all,
> <p>I would like to know if Oracle JDBC (Thin) Driver release 8.0.5.0.0
> support JSDK2.0?
> <p>We have installed the above JDBC Driver in Solaris 2.5.1
> and I tried
> to run the sample program (Employee.java) as below :
> <p><font color="#CC0000">/*</font>
> <br><font color="#CC0000"> * This sample shows how to
> list all the
> names from the EMP table</font>
> <br><font color="#CC0000"> *</font>
> <br><font color="#CC0000"> * It uses the JDBC THIN
> driver. See
> the same program in the</font>
> <br><font color="#CC0000"> * oci7 or oci8 samples
> directories to see
> how to use the other drivers.</font>
> <br><font color="#CC0000"> */</font><font color="#CC0000"></font>
> <p><font color="#CC0000">// You need to import the java.sql package to
> use JDBC</font>
> <br><font color="#CC0000">import java.sql.*;</font>
> <br><font color="#CC0000">import java.math.*;</font>
> <br><font color="#CC0000"></font> <font color="#CC0000"></font>
> <p><font color="#CC0000">class TestDb</font>
> <br><font color="#CC0000">{</font>
> <br><font color="#CC0000"> public static void main
> (String args [])</font>
> <br><font
> color="#CC0000"> throws
> SQLException</font>
> <br><font color="#CC0000"> {</font>
> <br><font color="#CC0000"> // Load the
> Oracle JDBC driver</font>
> <br><font color="#CC0000"> </font>
> <br><font color="#CC0000">
> DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());</font><font
> color="#CC0000"></font>
> <p><font color="#CC0000"> // Connect to the
> database</font>
> <br><font color="#CC0000"> // You must put
> a database
> name after the @ sign in the connection URL.</font>
> <br><font color="#CC0000"> // You can use either the
> fully specified SQL*net syntax or a short cut</font>
> <br><font color="#CC0000"> // syntax as
> <host>:<port>:<sid>.
> The example uses the short cut syntax.</font>
> <br><font color="#CC0000"> Connection conn
> = DriverManager.getConnection
> ("jdbc:oracle:thin:@myhost:1521:orcl","scott","tiger");</font>
> <font color="#CC0000"></font>
> <p><font color="#CC0000"> // Create a
> Statement</font>
> <br><font color="#CC0000"> Statement stmt =
> conn.createStatement
> ();</font><font color="#CC0000"></font>
> <p><font color="#CC0000"> // Select the ENAME column
> from the EMP table</font>
> <br><font color="#CC0000"> ResultSet rset =
> stmt.executeQuery
> ("select ename from emp");</font><font color="#CC0000"></font>
> <p><font color="#CC0000"> // Iterate
> through the result
> and print the employee names</font>
> <br><font color="#CC0000"> while (rset.next
> ())</font>
> <br><font color="#CC0000">
> System.out.println
> (rset.getString (1));</font>
> <br><font color="#CC0000"> }</font>
> <br><font color="#CC0000">}</font>
> <br>
> <p>There is no error during compilation but however when I run it as a
> servlet using Jrun. It gives me this error :
> <p><font color="#3333FF">500 Internal Server
> Error</font><font color="#3333FF"></font>
> <p><font color="#3333FF">Employee:</font><font color="#3333FF"></font>
> <p><font color="#3333FF">Could not load servlet</font>
> <br>
> <p>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 ????
> <p>Thanks for the help !
> <p>Regards,
> <br>Florence.
> <br> </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
___________________________________________________________________________
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
