JDBC APPLET Problem - Mailing list pgsql-interfaces

From v j
Subject JDBC APPLET Problem
Date
Msg-id 20010202064216.15594.qmail@web9503.mail.yahoo.com
Whole thread Raw
Responses Re: JDBC APPLET Problem  (v j <jvs_a@yahoo.com>)
List 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@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.
> > 
> > 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/


pgsql-interfaces by date:

Previous
From: v j
Date:
Subject: Re: JDBC APPLET Problem
Next
From: "Jose Luis LG"
Date:
Subject: JDBC documentation