Received: from web9506.mail.yahoo.com (web9506.mail.yahoo.com
 [216.136.129.20])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f11DGDq57129
	for <pgsql-interfaces@postgresql.org>;
	Thu, 1 Feb 2001 08:16:13 -0500 (EST) (envelope-from jvs_a@yahoo.com)
Message-ID: <20010201131610.9271.qmail@web9506.mail.yahoo.com>
Received: from [133.11.72.102] by web9506.mail.yahoo.com;
	Thu, 01 Feb 2001 05:16:10 PST
Date: Thu, 1 Feb 2001 05:16:10 -0800 (PST)
From: v j <jvs_a@yahoo.com>
Subject: JDBC APPLET Problem
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200102/1
X-Sequence-Number: 951

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/