Re: [INTERFACES] JDBC driver/applet question - Mailing list pgsql-interfaces

Hello,

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,

Igor

> 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@cam.ac.uk]
> Sent: 15 July 1999 20:54
> To: pgsql-interfaces@postgreSQL.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:.
>
> export PATH MANPATH PGLIB PGDATA CLASSPATH
> =========================================
>
> 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:
> http://simon.trinhall.cam.ac.uk/~id212/
>
> 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