From: Twinsun <id212@cam.ac.uk>
To: Peter Mount <petermount@it.maidstone.gov.uk>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] JDBC driver/applet question
Date: Fri, 16 Jul 1999 13:07:26 +0100
Message-ID: <378F207E.6FDCB63F@cam.ac.uk> (raw)
References: <1B3D5E532D18D311861A00600865478CA0B9@exchange1.nt.maidstone.gov.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: id212@cam.ac.uk, petermount@it.maidstone.gov.uk
Subject: Re: [INTERFACES] JDBC driver/applet question
In-Reply-To: <378F207E.6FDCB63F@cam.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox