From: v j <jvs_a@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: JDBC APPLET Problem
Date: Thu, 1 Feb 2001 05:16:10 -0800 (PST)
Message-ID: <20010201131610.9271.qmail@web9506.mail.yahoo.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jvs_a@yahoo.com
Subject: Re: JDBC APPLET Problem
In-Reply-To: <20010201131610.9271.qmail@web9506.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox