I�m
not sure but don�t you have to do some work around
security?
-----Original
Message-----
From: rohit
kuttappan [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2003 01:37
To: jdjlist
Subject: [jdjlist] JDBC Applet
Help
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]
