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