Re: JDBC APPLET Problem

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 











Saludos 


Leonel