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*/