I doubt this problem has anything to do with JSDK; perhaps u would like
to run as an application to see if the problem still exists. I know
I do have problem
using Oracle OCI driver ver 8.0.4.0.6 with JDK1.2; it works if ran
under JDK or JRE
1.1.x.
Florence Tan wrote:
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 driverDriverManager.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.
