JDBC Driver Help...

From: Eric Buschelmann <ehb(at)one(dot)net>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC Driver Help...
Date: 2000-09-04 19:25:18
Message-ID: 39B3FAD7.D4603E09@one.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)One(dot)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 Applet
implements 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);
Panel border1 = 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*/

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-09-05 06:46:07 RE: using large objects with jdbc
Previous Message Peter Mount 2000-09-04 15:08:15 RE: JDBC isNullable is not working