Skip site navigation (1) Skip section navigation (2)

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-05 12:15:47
Message-ID: 20010205121547.58878.qmail@web9504.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Dear Sir,
 My Jdbc Applet have already run but only when I copy
the "org" directory into "Desktop" directory of my
computer, for other computer that not have "org"
directory in "Desktop" directory the applet can't run
and shown "no suitable driver" ,why??,  or this means
that archive jdbc7.0-1.2.jar in html file can't be
seen..
advice me please..

Thank you
J. V.

--- v j <jvs_a(at)yahoo(dot)com> wrote:
> 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/

pgsql-interfaces by date

Next:From: Thomas LockhartDate: 2001-02-05 16:52:37
Subject: Re: [ODBC] ODBC Installation woes
Previous:From: v jDate: 2001-02-05 12:11:52
Subject: Re: JDBC APPLET Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group