RE: JDBC Driver Help...
От | Peter Mount |
---|---|
Тема | RE: JDBC Driver Help... |
Дата | |
Msg-id | 1B3D5E532D18D311861A00600865478CF1B355@exchange1.nt.maidstone.gov.uk обсуждение исходный текст |
Ответ на | JDBC Driver Help... (Eric Buschelmann <ehb@one.net>) |
Список | pgsql-interfaces |
INSERT doesn't return any results, so your use of executeQuery() is wrong here, and an SQLException should be thrown. You should use executeUpdate() for any SQL statements that don't return a ResultSet. PS: If you were writing a shell, so don't know if a ResultSet would be returned or not, then theres the execute() method, but you have to handle the results differently, so you should stay away from it. Peter -- Peter Mount Enterprise Support Officer, Maidstone Borough Council Email: petermount@maidstone.gov.uk WWW: http://www.maidstone.gov.uk All views expressed within this email are not the views of Maidstone Borough Council -----Original Message----- From: Eric Buschelmann [mailto:ehb@one.net] Sent: Monday, September 04, 2000 8:25 PM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] JDBC Driver Help... I am attempting to use the following code.... However, I seem to always get to the SQL EXCEPTION (on the query)... What am I doing wrong? I'm sure it is simple -- but still it is frustrating :) I'm not sure if this is related to the use of the driver or my configuration -- if anything -- a URL with some FAQ's would help... The details in the JDBC (postgres) guide are a little slim... Thanks Eric ehb@One.net /* * * Test.java * */ import java.awt.*; import java.awt.event.*; import java.io.*; import java.applet.*; /* import necessary for PGSQL */ import java.sql.*; public class Test extends Appletimplements ActionListener, TextListener { Button newButton=new Button("New"); Panel flow3 = new Panel (new FlowLayout(FlowLayout.LEFT,5,5));TextArea textArea2 = new TextArea ("",5,10,TextArea.SCROLLBARS_BOTH);Panelborder1 = new Panel (new BorderLayout(5,5)); public void init(){ this.setLayout(new BorderLayout()); this.setBackground(SystemColor.control); this.setForeground(SystemColor.controlText);newButton.addActionListener(this); flow3.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));flow3.add(newButton); textArea2.setText("Starting text...");textArea2.setBackground(SystemColor.window); textArea2.setForeground(SystemColor.windowText); textArea2.addTextListener(this);border1.add("North",flow3); border1.add("Center",textArea2); add("Center",border1); } public void actionPerformed(ActionEvent evt){ if (evt.getSource() == newButton ) { Connection con = null; try { Class.forName("org.postgresql.Driver").newInstance(); con=DriverManager.getConnection ("jdbc:postgresql:ehb","ehb","rhimgeti"); textArea2.setText("SUCCESSFULL connection object"); } catch (SQLException excpt0) { textArea2.setText("EXCEPTION0"); } catch (ClassNotFoundException excpt1) { textArea2.setText("EXCEPTION1"); } catch (InstantiationException excpt2) { textArea2.setText("EXCEPTION2"); } catch (IllegalAccessException excpt3) { textArea2.setText("EXCEPTION3"); } /* there should be a connection now*/ try { Statement st = con.createStatement(); ResultSet rs = st.executeQuery("insert into test values(2);"); rs.close(); st.close(); con.close(); } catch (SQLException excpt0) { textArea2.setText("SQL EXCEPTION ON QUERY!!!"); } } } public void textValueChanged(TextEvent evt) { String[] test = new String[2];} } /* end class*/
В списке pgsql-interfaces по дате отправления: