From: Eric Buschelmann <ehb@one.net>
To: pgsql-interfaces@postgresql.org
Subject: JDBC Driver Help...
Date: Mon, 4 Sep 2000 15:25:18 -0400
Message-ID: <39B3FAD7.D4603E09@one.net> (raw)
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 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*/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ehb@one.net
Subject: Re: JDBC Driver Help...
In-Reply-To: <39B3FAD7.D4603E09@one.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox