Unable to run Applets with appletviewer - Mailing list pgsql-jdbc

From Francisco Villavicencio
Subject Unable to run Applets with appletviewer
Date
Msg-id 3F96961A.4070005@server.epn.edu.ec
Whole thread Raw
Responses Re: Unable to run Applets with appletviewer
List pgsql-jdbc
Dear Sirs:

I was trying to run Sample Code 7 an 8 from JDBC Database Access with
Java from Graham Hamilton, against a Postgres 7.3 database "Test" and I
have the following error message:

java.lang.NoClassDefFoundError: org/postgresql/Diriver

The ful code Iwas using is

/*
 * Copyright 2003 Sun Microsystems, Inc.  ALL RIGHTS RESERVED.
 * Use of this software is authorized pursuant to the terms of the
license found at
 * http://developer.java.sun.com/berkeley_license.html.
 */

/**
 * This is a demonstration JDBC applet.
 * It displays some simple standard output from the Coffee database.
 */

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 = "jdbc:postgresql:test";
    String query = "select * from uno";

    try {
        Class.forName("org.postgresql.Driver");
    } catch(Exception ex) {
        setError("Can't find Database driver class: " + ex);
        return;
    }

    try {
        Vector results = new Vector();
        Connection con = DriverManager.getConnection(url,
                        "postgres", "");
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(query);
        while (rs.next()) {
        String s = rs.getString("a");
        int f = rs.getInt("b");
        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();
    }
}


and the html file

/*
 * Copyright 2003 Sun Microsystems, Inc.  ALL RIGHTS RESERVED.
 * Use of this software is authorized pursuant to the terms of the
license found at
 * http://developer.java.sun.com/berkeley_license.html.
 */

<HTML>
<HEAD>
<TITLE> Query Output </TITLE>
</HEAD>
<BODY>

Output from query
select NAME, PRICE from COFFEES
<APPLET CODE="OutputApplet.class" WIDTH=250 HEIGHT=200>
</APPLET>
</BODY>
</HTML>


After compiling with javac I ran

appletviewer OutputApplet.html

and had the above message.

Can You help me to solve the problem?

Thanks.

Francisco.



pgsql-jdbc by date:

Previous
From: "nitin_mandolkar"
Date:
Subject: Help Me
Next
From: "cacko"
Date:
Subject: jasperEdit and postgres