Thread: JDBC APPLET Problem
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;privateTextField 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 v,
Thursday, February 01, 2001, 2:16:10 PM, you wrote:
vj> public void start() {
vj> try{ conn =
vj> DriverManager.getConnection("jdbc:postgresql://fmlhost.fml.t.u-tokyo.ac.jp/test","postgres","");
vj> stmt = conn.createStatement();
vj> }
Maybe you forgot to load the driver?
Excerpt from the SUN docs:
------------------------
Loading Drivers
Loading the driver or drivers you want to use is very simple and involves just one line of code. If, for example, you
wantto use the JDBC-ODBC Bridge driver, the following code will load it:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Your driver documentation will give you the class name to use. For instance, if the class name is jdbc.DriverXYZ , you
wouldload the driver with the following line of code:
Class.forName("jdbc.DriverXYZ");
You do not need to create an instance of a driver and register it with the DriverManager because calling Class.forName
willdo that for you automatically. If you were to create your own instance, you would be creating an unnecessary
duplicate,but it would do no harm.
When you have loaded a driver, it is available for making a connection with a DBMS.
-------------
--
Best regards,Bruno mailto:bruno@dickhoff.de
Hi VJ,
I had experience that connecting Postgresql (JDBC) by
Applet has several (many) problems. The most problem
is about driver such as "no suitable driver".
So, I decided to use Java Servlet in the server side
instead of Applet. Applet is used only in the client
side.
And Applet-Servlet-JDBC-Postgresql communication
provides good system for data collection and(or) data
retrieval (including BLOB).
Hope that this information helps you.
Regard.
-S.A.Pamungkas-
--- v j <jvs_a@yahoo.com> 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/
__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
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/
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
Hi, we are acquiring data of from systems on windows and WindowsNT platform ,size of datafiles are in gigabytes(GB) My
postgresdatabase is installed on sun solaris platform.
I would like to the know about the different methods or techniques that i can apply to transfer the data to my
postgresdatabase .All the systems(computer ) are connect through network.
-------------------------------------------------------------------
From:- | Ms. Manika Dey. |Ph.No:--Engineer-SC (Comp. Tech.) | IPR -- 02712
-69276 I.P.R | EXT 336,315BHAT, GANDHINAGAR | Residence -- 079 -7421117
Gujrat-- 382 428 | FAX --- 69017 ------------------------------------------------------------------