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]
