Hi,
I wonder how come a product being made to be used as a non-graphic,
and non-interactive java library can *not* run within a servlet
environment (JSDK).
Otherwise I don't know of any JDBC Drivers with specific support for
Java Servlet Development Kit - any version, but this does not stop
Java-web app. developers to use them together to make an application.
Check also if your specialists can tell what exactly mean the
following terms:
"Java 2", "JDK2.0", "JSDK2.0", "JDBC2.0", "JSDK2.1", "JDK1.2", "JSDK1.1".
People not working frequently with servlets and Java can easealy be
confused by all these acronyms and versions..
Bye,
Cezar.
On Mon, 14 Jun 1999, Groenescheij, Michel wrote:
> 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
