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
|
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: