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.
begin:vcard n:Tan;Florence tel;fax:(60)82-232008 tel;work:(60)82-234008 x-mozilla-html:FALSE org:SiliconNet Technology Sdn. Bhd.;Development version:2.1 email;internet:[EMAIL PROTECTED] adr;quoted-printable:;;Lot 352, Loron 12, Jalan Rubber,=0D=0A93400 Kuching, =0D=0ASarawak, Malaysia;;;; note;quoted-printable:Success is not measured by the position one has reached in life, rather by =0D=0Athe obstacles overcome while trying to succeed. -Booker T. Washington fn:Florence Tan end:vcard
S/MIME Cryptographic Signature