Hello List,
I'm wrote some code that
accesses a Oracle database (Personal Edition) running on Windows98
machine. I was successful in running it with appletviewer, but am not
being able to run it on I.E.5. Could you pl. go though the following
code and tell me what I'm doing wrong, or what additional steps I need to
take to be able to run the applet on I.E.
import java.applet.Applet;
import
java.awt.Graphics;
import java.util.Vector;
import
java.sql.*;
public class OutputApplet extends Applet
implements Runnable {
private Thread
worker;
private Vector
queryResults;
private String message =
"Initializing";
public synchronized void
start() {
// Every time "start" is called we create a worker
thread to
// re-evaluate the database query.
if (worker
== null) {
message = "Connecting to
database";
worker = new Thread(this);
worker.start();
}
}
/**
* The "run" method is called from the
worker thread. Notice that
* because
this method is doing potentially slow databases
accesses
* we avoid making it a synchronized
method.
*/
public void run()
{
String url =""> String query =
"select COF_NAME, PRICE from COFFEES";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception ex) {
setError("Can't find
Database driver class: " + ex);
return;
}
try {
Vector results = new Vector();
Connection con
= DriverManager.getConnection(url, "scott",
"tiger");
Statement stmt =
con.createStatement();
ResultSet rs =
stmt.executeQuery(query);
while (rs.next())
{
String s = rs.getString("COF_NAME");
float
f = rs.getFloat("PRICE");
String text = s +
" " +
f;
results.addElement(text);
}
stmt.close();
con.close();
setResults(results);
} catch(SQLException ex)
{
setError("SQLException: " +
ex);
}
}
/**
* The "paint" method is called by AWT when
it wants us to
* display our current state on
the screen.
*/
public synchronized void
paint(Graphics g) {
// If there are no results available, display
the current message.
if (queryResults == null)
{
g.drawString(message, 5,
50);
return;
}
// Display the
results.
g.drawString("Prices of coffee per pound: ", 5,
10);
int y = 30;
java.util.Enumeration enum =
queryResults.elements();
while (enum.hasMoreElements())
{
String text =
(String)enum.nextElement();
g.drawString(text,
5, y);
y = y +
15;
}
}
/**
* This private method is used to record an
error message for
* later
display.
*/
private synchronized void
setError(String mess) {
queryResults =
null;
message = mess;
worker =
null;
// And ask AWT to repaint this
applet.
repaint();
}
/**
* This private method is used to record
the results of a query, for
* later
display.
*/
private synchronized void
setResults(Vector results) {
queryResults =
results;
worker = null;
// And ask AWT to repaint this
applet.
repaint();
}
}
This is my HTML code:
<HTML>
<HEAD>
<TITLE>
Query Output </TITLE>
</HEAD>
<BODY>
Output from query
select NAME, PRICE from
COFFEES
<APPLET CODE="OutputApplet.class"
codebase=""
archive="C:/Oracle/Ora81/jdbc/lib/classes111.zip" WIDTH=550
HEIGHT=300>
</APPLET>
</BODY>
</HTML>
The error I'm getting when running on I.E 5
is : can't find Datavbase driver class: java.lang.ClassNotFoundException:
oracle.jdbc.driver.OracleDriver.
thanks in anticipation,
yours truly,
Rohit.
---
You are currently
subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe
send a blank email to [EMAIL PROTECTED]
