wykzimme
asked on
Sun One ClassNotFoundException: oracle.jdbc.driver.OracleDriver
I am trying to set up the Oracle jdbc on Sun One Web Server Enterprise Edition 6.1 but do not seem to be having any luck. It seems that OCI and thin fails.
I have installed the Oracle client in the folder c:\oracle\ora92. I have selected the following items to install in the Oracle client: Oracle 9i Client 9.2.0.1.0, Common files, JDBC/OCI, JDBC/Thin, and Internet Directory Client. (I then downloaded ojdbc14.jar and placed it in jdbc\lib folder.)
I am seeing the following error: ClassNotFoundException: oracle.jdbc.driver.OracleD river
From the following web page:
<code>
<%@page language="java"
import="java.sql.*,
oracle.jdbc.driver.*,
oracle.sql.*
"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
Hello World
</title>
</head>
<body>
<%
//connections to ops2
DriverManager.registerDriv er(new oracle.jdbc.driver.OracleD river());
Connection conn = DriverManager.getConnectio n("jdbc:or acle:oci8: @wydot-ops 2","userna me","passw ord");
Statement stmt = conn.createStatement();
ResultSet rset = null;
rset = stmt.executeQuery("SELECT AGENCY_NUMID,AGENCY_NAME FROM flightsch.state_agencies ORDER BY agency_name");
while(rset.next())
{
String ag_name = rset.getString("agency_nam e");
%>
<%= ag_name%>
<%
} //end of while loop
rset.close();
stmt.close();
conn.close();
%>
</body>
</html>
</code>
I have made the following entries into the Sun One Administration pages:
Java Tab
JVM path Settings
Classpath suffix = c:\oracle\ora92\jdbc\lib
Ignore Env Class Path = on
Native Lib Path Prefix = c:\j2sdk1.4.2_02\lib
Native Lib Path Suffix =
JDBC Connection Pools
Pool = jdbc-oracle-pool
DataSource Classname = oracle.jdbc.pool.Oracle.Da taSource
URL = wydot-ops2
User = username
Password = password
(Rest of items = defaults)
I have installed the Oracle client in the folder c:\oracle\ora92. I have selected the following items to install in the Oracle client: Oracle 9i Client 9.2.0.1.0, Common files, JDBC/OCI, JDBC/Thin, and Internet Directory Client. (I then downloaded ojdbc14.jar and placed it in jdbc\lib folder.)
I am seeing the following error: ClassNotFoundException: oracle.jdbc.driver.OracleD
From the following web page:
<code>
<%@page language="java"
import="java.sql.*,
oracle.jdbc.driver.*,
oracle.sql.*
"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
Hello World
</title>
</head>
<body>
<%
//connections to ops2
DriverManager.registerDriv
Connection conn = DriverManager.getConnectio
Statement stmt = conn.createStatement();
ResultSet rset = null;
rset = stmt.executeQuery("SELECT AGENCY_NUMID,AGENCY_NAME FROM flightsch.state_agencies ORDER BY agency_name");
while(rset.next())
{
String ag_name = rset.getString("agency_nam
%>
<%= ag_name%>
<%
} //end of while loop
rset.close();
stmt.close();
conn.close();
%>
</body>
</html>
</code>
I have made the following entries into the Sun One Administration pages:
Java Tab
JVM path Settings
Classpath suffix = c:\oracle\ora92\jdbc\lib
Ignore Env Class Path = on
Native Lib Path Prefix = c:\j2sdk1.4.2_02\lib
Native Lib Path Suffix =
JDBC Connection Pools
Pool = jdbc-oracle-pool
DataSource Classname = oracle.jdbc.pool.Oracle.Da
URL = wydot-ops2
User = username
Password = password
(Rest of items = defaults)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
how about thin?
ASKER