Re: JDBC Driver Help...

From: Bob Kline <bkline(at)rksystems(dot)com>
To: Eric Buschelmann <ehb(at)one(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: JDBC Driver Help...
Date: 2000-09-06 12:56:53
Message-ID: Pine.LNX.4.10.10009060835200.2563-100000@rksystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Mon, 4 Sep 2000, Eric Buschelmann wrote:

> I am attempting to use the following code.... However, I seem to always
> get to the SQL EXCEPTION (on the query)... [snip]
> ResultSet rs = st.executeQuery("insert into test values(2);");
> rs.close();
>
>
> st.close();
> con.close();
> }
>
> catch (SQLException excpt0)
> {
> textArea2.setText("SQL EXCEPTION ON QUERY!!!");
> }

The two most egregious problems are the fact that you're not letting the
exception objects tell you what they know, and the semicolon isn't part
of the SQL syntax -- lose it.

--
Bob Kline
mailto:bkline(at)rksystems(dot)com
http://www.rksystems.com

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Carl Shelbourne 2000-09-06 15:23:59 ISO8601 Time and ODBC
Previous Message Zeljko Trogrlic 2000-09-06 12:44:29 RE: JDBC and Unicode problem