[jdjlist] RE: JDBC Applet Help

Andrew Rendle Tue, 18 Feb 2003 01:51:19 -0800

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]

[jdjlist] RE: JDBC Applet Help

Reply via email to