RE: JDBC Driver Help... - Mailing list 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*/