Re: JDBC APPLET Problem - Mailing list pgsql-interfaces
| From | v j |
|---|---|
| Subject | Re: JDBC APPLET Problem |
| Date | |
| Msg-id | 20010206043241.81755.qmail@web9507.mail.yahoo.com Whole thread Raw |
| In response to | JDBC APPLET Problem (v j <jvs_a@yahoo.com>) |
| List | pgsql-interfaces |
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/
pgsql-interfaces by date: