pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: v j <jvs_a@yahoo.com>
To: Greg@10happythings.com
Cc: pgsql-interfaces@postgresql.org
Subject: JDBC APPLET Problem
Date: Mon, 5 Feb 2001 20:37:17 -0800 (PST)
Message-ID: <20010206043717.96913.qmail@web9503.mail.yahoo.com> (raw )
Hello..
This is the detial of my SampleApplet.html file
<HTML>
<BODY>
<P>
<APPLET CODE="SampleApplet.class"
ARCHIVE="jdbc7.01.2.jar"
width=500 height=700>
</APPLET>
</P>
</BODY>
</HTML>
I'm surely that I left these .html, .class,
jdbc7.01.2.jar and directory "org" on the server..
and download from the server to open the web browser..
by specify the location on the server,
but it only work when copy the "org" directory to my
computer.(I run it on Internet explorer5 and it work
when I copy the "org" directory to my computer but for
Netscape4.5 it shown not known argument)
or may I must add others to .html file?
Thank you
J. V.
--- Greg Speegle <Greg@10happythings.com> wrote:
>
> VJ,
>
> Could you post the .html file you are using? And how
> are you
> loading the file into the browser? It sounds like
> the html file is
> on your computer and you are double-clicking it to
> load. This
> would not download the driver from the server, but
> would work
> if you put the hierarchy on the local machine.
>
> Good luck,
> Greg Speegle
>
> v j wrote:
>
> > Dear Sir,
> > My Jdbc Applet have already run but only when I
> copy
> > the "org" directory into "Desktop" directory of my
> > computer, for other computer that not have "org"
> > directory in "Desktop" directory the applet can't
> run
> > and shown "no suitable driver" ,why??, or this
> means
> > that archive jdbc7.0-1.2.jar in html file can't be
> > seen..
> > advice me please..
> >
> > Thank you
> > J. V.
> >
> > --- v j <jvs_a@yahoo.com> wrote:
> > > Dear Sir,
> > > Thanks you for everybody for advicing me..
> > > I've already tried to include both
> jdbc7.0-1.2.jar
> > > and postgresql.jar archive with my applet and
> then
> > > copy the jdbc7.0-1.2.jar and postgresql.jar file
> > > into
> > > public_html directory(which is the location of
> > > SampleApplet.class file) and try to run the
> applet
> > > through web browser again and the error message
> > > still
> > > shown "No suitable driver".. how should I do
> more
> > >
> > > Thanks you
> > > J. V.
> > >
> > > --- PostgreSQL Server
> > > <postgres@gonzo.lnxsoftware.com.mx> wrote:
> > > > On Thu, 1 Feb 2001, v j wrote:
> > > >
> > > > > Dear Sir,
> > > > > Now I try to run the Java Program by using
> JDBC
> > > > > PostgreSql through Web Browser.
> > > > > I set the file pg_hba.conf as
> > > > >
> > > > > local all
> > > trust
> > > > > host all 127.0.0.1 255.255.255.255
> > > trust
> > > > > host all 0.0.0.0 0.0.0.0
> > > trust
> > > > >
> > > > > and the java code as shown below .....
> > > > >
> > > > > import java.sql.*;
> > > > > import java.applet.*;
> > > > > import java.awt.*;
> > > > > import java.awt.event.*;
> > > > > import java.net.*;
> > > > > import java.io.*;
> > > > >
> > > > >
> > > > > public class SampleApplet extends Applet
> > > > implements
> > > > > ActionListener
> > > > > {
> > > > > Connection conn;
> > > > > Statement stmt;
> > > > > String state_code;
> > > > >
> > > > > private TextField Tinput;
> > > > > private TextField Toutput;
> > > > > private TextField Terror;
> > > > >
> > > > > private Button sqlprocess;
> > > > >
> > > > >
> > > > >
> > > > > public void init(){
> > > > >
> > > > >
> > > > > try{ Class.forName
> > > > ("org.postgresql.Driver");}
> > > > > catch(Exception ex){
> > > > > ex.printStackTrace();}
> > > > >
> > > > > setFont(new
> Font("TimesRoman",Font.PLAIN,15));
> > > > > setLayout(null);
> > > > >
> > > > > Label Linput = new Label("Enter a
> state code:
> > > > ");
> > > > > Tinput = new TextField(10);
> > > > > Label Loutput = new Label("Sql
> Output");
> > > > > Toutput = new TextField(30);
> > > > > Terror = new TextField(100);
> > > > > sqlprocess = new
> Button("SqlQuery");
> > > > >
> > > > > Linput.setBounds(10,30,150,30);
> > > > > Tinput.setBounds(170,20,100,30);
> > > > > Loutput.setBounds(10,80,100,30);
> > > > > Toutput.setBounds(110,80,100,30);
> > > > > Terror.setBounds(10,150,200,30);
> > > > >
> sqlprocess.setBounds(50,210,80,30);
> > > > >
> > > > > add(Linput);
> > > > > add(Tinput);
> > > > > add(Loutput);
> > > > > add(Toutput);
> > > > > add(Terror);
> > > > > add(sqlprocess);
> > > > >
> > > > >
> sqlprocess.addActionListener(this);
> > > > >
> > > > > }
> > > > >
> > > > > public void start() {
> > > > > try{ conn =
> > > > >
> > > >
> > >
> >
>
DriverManager.getConnection("jdbc:postgresql://fmlhost.fml.t.u-tokyo.ac.jp/test","postgres","");
> > > > > stmt =
> conn.createStatement();
> > > > > }
> > > > > catch(Exception ex){
> > > > >
> > > > > ex.printStackTrace();
> > > > >
> Terror.setText(ex.getMessage());
> > > > > }
> > > > > }
> > > > >
> > > > > public void actionPerformed(ActionEvent
> ae)
> > > {
> > > > >
> > > > > if(ae.getActionCommand()=="SqlQuery"){
> > > > >
> > > > >
> > > > > state_code = Tinput.getText();
> > > > >
> > > > > try{ ResultSet res =
> stmt.executeQuery(
> > > > "Select
> > > > > name "+"From statename "+"Where code =
> > > > > '"+state_code+"'");
> > > > > if(res!=null)
> > > > > while(res.next())
> > > > > {String
> state_name = res.getString(1);
> > > > >
> Toutput.setText(state_name);}
> > > > >
> > > > > res.close();
> > > > > stmt.close();
> > > > > conn.close();
> > > > > }
> > > > >
> > > > > catch(Exception ex){
> > > > > ex.printStackTrace(); }
> > > > >
> > > > >
> > > > > }
> > > > >
> > > > > }
> > > > >
> > > > >
> > > > > }
> > > > >
> > > > > and I get the error message as
> > > > >
> > > > > "No suitable driver"
> > > > >
> > > > > Please advice me for this problem.
> > > > >
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
view thread (13+ messages)
Message-ID: <20010206043717.96913.qmail@web9503.mail.yahoo.com>
Permalink: ../20010206043717.96913.qmail@web9503.mail.yahoo.com/
Also on: postgresql.org/message-id/20010206043717.96913.qmail@web9503.mail.yahoo.com
copy link · copy postgr.es
reply 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: jvs_a@yahoo.com, Greg@10happythings.com
Subject: Re: JDBC APPLET Problem
In-Reply-To: <20010206043717.96913.qmail@web9503.mail.yahoo.com>
* 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