I am using thin JDBC with Oracle 8.0.5 and it works fine. The oracle server
is on Solaris 2.6.
Bing
At 09:40 AM 6/14/99 -0400, you wrote:
>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
>
___________________________________________________________________________
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
