*
The moose likes Websphere and the fly likes websphere application developer studio Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "websphere application developer studio" Watch "websphere application developer studio" New topic
Author

websphere application developer studio

bullman bullman
Greenhorn

Joined: May 29, 2003
Posts: 1
Problems connecting to the database through jsp in the websphere studio(5.0)
The console shows the following error
[Servlet Error]-[oracle.jdbc.driver.OracleDriver]: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at com.ibm.ws.classloader.CompoundClassLoader.
The browser displays
Error 500: oracle.jdbc.driver.OracleDriver
Following is the code
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" %>
<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="IBM WebSphere Studio">
<TITLE>testJSP.jsp</TITLE>
</HEAD>
<BODY>
<%@ page import="java.io.*, java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc racle:thin:@3.34.221.80:1583 LAT", "OHRCONNECT", "OHRCONNECT");
Statement statement = conn.createStatement(); %>
//Resultset resultSet=statement.executeQuery("select * from PX_GE_DSI_ERROR_CODES");
<P> The results are:
</P>
<UL>
<% //while (resultSet.next()) { %>
<LI><%//= resultSet.getString(1) %></LI>
<%// } %>
</UL>
<%
out.println("test");
%>

</BODY>
</HTML>
--------------------------
I have put the classes12.zip in the lib folder inside webcontent/webinf/lib
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30369
    
150

Is classes12.zip in the build path for your project?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Dirk Schreckmann
Sheriff

Joined: Dec 10, 2001
Posts: 7023
bullman bullman,
Welcome to JavaRanch!
We ain't got many rules 'round these parts, but we do got one. Please change your display name to comply with The JavaRanch Naming Policy.
Thanks Pardner! Hope to see you 'round the Ranch!


[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]
Dirk Schreckmann
Sheriff

Joined: Dec 10, 2001
Posts: 7023
I'm moving this to The IBM/Websphere Forum...
Scott Duncan
Ranch Hand

Joined: Nov 01, 2002
Posts: 363
classes12.zip should be in you server's classpath if you are accessing from a Web app. Go to server perspective, make sure the server configuration window is open, under the Servers folder, double click on the appropriate server. When the editor comes up, click on paths and set the classpath appropriately. To set up connection pooling, click the Data Source tab.
Making sure the zip file is in the build path will only work for a java project where the build path is considered the "run-time" path as well.


No more rhymes! I mean it!<br /> <br />Does anybody want a peanut?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: websphere application developer studio