JDBC APPLET Problem

From: v j <jvs_a(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC APPLET Problem
Date: 2001-02-02 06:42:16
Message-ID: 20010202064216.15594.qmail@web9503.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)gonzo(dot)lnxsoftware(dot)com(dot)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.
> >
> > Thank you
> >
> >
> >
> > __________________________________________________
> > Get personalized email addresses from Yahoo! Mail
> - only $35
> > a year! http://personal.mail.yahoo.com/
> >
>
>
>
>
> Hello there :
>
> You need to include your .jar archive with your
> applet
>
> Just copy the jdbc jar to your applet directory
>
>
> <html>
> <body
> <applet code=SampleApplet archive=jdbc7.0-1.2.jar
> width=800 height=600>
> </applet>
> </body>
> </html>
>
>
>
>
> Saludos
>
>
> Leonel
>
>

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter T Mount 2001-02-02 08:38:34 Re: [INTERFACES] JDBC APPLET Problem
Previous Message v j 2001-02-02 06:22:13 Re: JDBC APPLET Problem