JDBC APPLET Problem - Mailing list pgsql-interfaces

From v j
Subject JDBC APPLET Problem
Date
Msg-id 20010201131610.9271.qmail@web9506.mail.yahoo.com
Whole thread Raw
Responses Re: JDBC APPLET Problem  (Bruno Dickhoff <bruno@dickhoff.de>)
Re: JDBC APPLET Problem  ("S.A.Pamungkas" <moenk_2000@yahoo.com>)
Re: JDBC APPLET Problem  (PostgreSQL Server <postgres@gonzo.lnxsoftware.com.mx>)
List pgsql-interfaces
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;privateTextField 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/


pgsql-interfaces by date:

Previous
From: Peter T Mount
Date:
Subject: Re: JDBC Connection Problem
Next
From: Adam Haberlach
Date:
Subject: PHP and error reporting