Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] JDBC driver/applet question

From: Twinsun <id212(at)cam(dot)ac(dot)uk>
To: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] JDBC driver/applet question
Date: 1999-07-16 12:07:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces

Thank you for your reply-- it helped! :-)

I added in applet ARCHIVE and CLASSPATH parameters as follows:
<APPLET CODE='Statistics.class' ARCHIVE='postgresql.jar' ...>
<PARAM NAME='classpath' value='.'>

There are two problems now.

Firstly, it works in Netscape but still doesn't in IE 4.x --  it downloads
posgresql.jar on the local machine and then throws: "No siutable driver"
exception(which differs from the exception which was thrown before).

Secondly, it's a very inappropriate solution -- to force a user to wait
while 130K of postgresql.jar is downloading to a local machine to display a
few charts...

Is there any way I can use the driver without having it on the machine where
the applet is running?

> Applets are weird beasts - which is why I don't write them any more ;-)

So no JDBC-based connections could be provided on the Web or there is some
other methods I'm missing? I can do my charts with fetching all values using
and then pass it as parameters to an applet, but then it wouldn't be
JDBC-based soltion...

Thank you,


> Anyhow, you need to put the classpath in the <applet> tag. I'm not 100%
> certain, but it should go under the archive= parameter?
> Peter
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
> -----Original Message-----
> From: Twinsun [mailto:id212(at)cam(dot)ac(dot)uk]
> Sent: 15 July 1999 20:54
> To: pgsql-interfaces(at)postgreSQL(dot)org
> Subject: [INTERFACES] JDBC driver question
> Hello,
> Sorry if this question has been covered before...
> I wrote an applet which connects to my db and displays some statistics.
> I've got it on my account on Linux (RedHat 5.2) box. I've set up
> classpath for the driver:
> =========================================
> PATH=/usr/local/pgsql/bin:$PATH:/usr/local/jdk1.2/bin
> MANPATH=$MANPATH:/usr/local/pgsql/man
> PGLIB=/usr/local/pgsql/lib
> PGDATA=/usr/local/pgsql/data
> CLASSPATH=/usr/local/pgsql/lib/postgresql.jar:.
> =========================================
> No errors when I compile my applet.
> When I connect to my pages on the Net from my local machine (under Win)
> it doesn't work...
> It throws: Can't find Database driver class .... postgresql.Driver
> exception.
> Interesting that if I have postgresql.jar in classpath on my local
> machine then the applet works just fine.
> Any ideas would be very much appreciated as this is a part of my project
> I have to finish by 31 July.
> You can see it for yourself on:
> There is a form linked to a cgi scipt which basically just prints an
> html page with applet code in it with a query as a parameter to the
> applet.
> Thank you,
> Igor

In response to


pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-07-16 13:46:45
Subject: Re: [INTERFACES] backend connection lost
Previous:From: Wenhao MengDate: 1999-07-16 07:36:36

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group