| From: | Moreno Mauri <moreno(dot)mauri(at)italtel(dot)it> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | SQLState with pg74.1jdbc3.jar |
| Date: | 2004-01-15 14:50:18 |
| Message-ID: | 4006A8AA.E3A2F43A@italtel.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi all,
I'm a newbie in JDBC code.
I tried to execute a Statement.executeUpdate() method to insert a row
already present in my Postgresql DB.
With JDBC I receive a SQLException but I would like to have
more informations about the error (something like Duplicate Key
Exception).
I read that SQLException class have the getSQLState() method, but
when I call it, the result is null (the getErrorCode() return always 0).
The same if I try to generate another error (an INSERT command
without specifying all NOT NULL colums of my table).
I use pg74.1jdbc3.jar on a i686 Intel - Suse host.
Here is the code (insertCommand is intentionally a wrong command)
public int execInsert(String insertCommand) {
Statement stateSql;
Connection conn;
conn = <get the Connection>;
try {
stateSql = conn.createStatement();
return(stateSql.executeUpdate(insertCommand));
}
catch (SQLException e) {
System.out.println("SQLException: error code = " +
e.getErrorCode());
System.out.println("SQLException: sqlstate = " +
e.getSQLState());
return(-1);
}
}
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Thomas | 2004-01-15 15:11:40 | Re: SQLState with pg74.1jdbc3.jar |
| Previous Message | Kris Jurka | 2004-01-15 10:37:03 | Re: jdbc1.AbstractJdbc1Statement.setBinaryStream bug and |