Re: JDBC APPLET Problem
От | S.A.Pamungkas |
---|---|
Тема | Re: JDBC APPLET Problem |
Дата | |
Msg-id | 20010202052142.878.qmail@web4903.mail.yahoo.com обсуждение исходный текст |
Ответ на | JDBC APPLET Problem (v j <jvs_a@yahoo.com>) |
Список | pgsql-interfaces |
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/
В списке pgsql-interfaces по дате отправления: