Two Laptop Bag
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

websphere application developer studio

bullman bullman

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
The browser displays
Error 500: oracle.jdbc.driver.OracleDriver
Following is the code
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ 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">
<%@ page import="*, java.sql.*"%>
Connection conn = DriverManager.getConnection("jdbc racle:thin:@ LAT", "OHRCONNECT", "OHRCONNECT");
Statement statement = conn.createStatement(); %>
//Resultset resultSet=statement.executeQuery("select * from PX_GE_DSI_ERROR_CODES");
<P> The results are:
<% //while ( { %>
<LI><%//= resultSet.getString(1) %></LI>
<%// } %>

I have put the in the lib folder inside webcontent/webinf/lib
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

Is in the build path for your project?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Dirk Schreckmann

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

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

Joined: Nov 01, 2002
Posts: 364 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:
subject: websphere application developer studio
It's not a secret anymore!