Re: cannot find org.postgres.Driver

Hi everybody

I'm trying to write an applet to acces postgres but when I load the applet in a web browser doesn't seems to work. In the JVM console I obtain an error that says something like this

Cannot find "/home/applets/org/postgresql/Driver"

the code I use to load the postgres driver is as follows

Class.forName("org.postgresql.Driver");
Connection db = DriverManager.getConnection("jdbc:postgresql:arl",user,password);

where arl is the database name

for you anwser thanks

---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al mes.

Felipe,

from the http://jdbc.postgresql.org/doc.htm site

So our url? It's one of the following:

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

where database is the database to connect to, host the server to connect
to, and port the port number.

If left out, host defaults to localhost (not 127.0.0.1 see applets!) and
port to 5432 (configurable at build time).

Dave

On Tue, 2004-05-25 at 18:44, Felipe wrote:
> Hi everybody
>
> I'm trying to write an applet to acces postgres but when I load the
> applet in a web browser doesn't seems to work. In the JVM console I
> obtain an error that says something like this
>
> Cannot find "/home/applets/org/postgresql/Driver"
>
> the code I use to load the postgres driver is as follows
>
> Class.forName("org.postgresql.Driver");
> Connection db =
> DriverManager.getConnection("jdbc:postgresql:arl",user,password);
>
> where arl is the database name
>
> for you anwser thanks
>
>
>
> ______________________________________________________________________
> Do You Yahoo!?
> Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por
> $100 al mes.
> !DSPAM:40b3cd80232576939882854!
--
Dave Cramer
519 939 0336
ICQ # 14675561

Felipe wrote:

> Cannot find "/home/applets/org/postgresql/Driver"
>

Did you extract the jdbc classes or are you using the postgresql.jar file?
If you use the jar, did you mention it in the archive property of your
applet/object/embed tag?

Your html page and your directory structure would help.

Greetings,

Uli

I'm using the file pg73jdbc3.jar which is included in my classpath

well, my directory structure is:

/home/Documents/dbConnection/classes/dbconnection
here are all classes

and html file is in
/home/Documents/dbConnection/classes/

my source code is as follows

package dbconnection;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import javax.swing.*;
import java.sql.*;

public class Conectame1 extends JApplet {

//Construct the applet
public Conectame() {
}

//Initialize the applet
public void init() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}

//Component initialization
private void jbInit() throws Exception, ClassNotFoundException, SQLException{
conexion esta = new conexion();
jLabel1.setText("database name: "+esta.db.getDatabaseProductName());
this.setSize(new Dimension(400,300));
this.getContentPane().add(jLabel1, BorderLayout.CENTER);
}
}

class conexion {
Connection db;
DatabaseMetaData dbmd;
public conexion() throws ClassNotFoundException, SQLException
{
Class.forName("org.postgresql.Driver");
db = DriverManager.getConnection("jdbc:postgresql:arl","pipo","jamara16");
dbmd = db.getMetaData();
}
public static void main(String[] args) throws SQLException, ClassNotFoundException
{
conexion conexion1 = new conexion();
}
}

my html code is as follows
html>
head>
title>
HTML Test Page
/title>
/head>
body>
dbconnection.Conectame will appear below in a Java enabled browser.<br>
applet
codebase = "."
code = "dbconnection.Conectame.class"
name = "TestApplet"
width = "400"
height = "300"
hspace = "0"
vspace = "0"
align = "middle"
>
/applet>
/body>
/html>
(I erased the '<' for my mail manager)
thanks for your answer

---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al mes.

Felipe wrote:

> I'm using the file pg73jdbc3.jar which is included in my classpath
>

And here's the problem. Your browser uses the Java Plugin and that has a
different classpath. You can set it on your machine, but you can't set
it on everyone's machine who's going to visit your page.
You need to include the jar file in your applet tag. I am not sure if it
is possible with a plain <applet> tag, but you can try to add
codebase="pg73jdbc3.jar".
That might fail, but with JDK 1.2 applets you shouldn't use that tag
anyway. Unfortunately it depends on the browser if you need to use an
<object> or an <embed> tag, but the whole matter is best discussed here:
http://java.sun.com/j2se/1.4.2/docs/guide/plugin/developer_guide/contents.html
where you can find a solution for both major browser families out there.

Greetings,

Uli