| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tim Penhey <tim(at)penhey(dot)net> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: PreparedStatement.setString with null |
| Date: | 2004-09-30 10:34:25 |
| Message-ID: | 415BE131.8080203@opencloud.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Tim Penhey wrote:
> What is this supposed to do?
>
> PreparedStatement stat = connection.prepareStatement("update table1
> set col1 = ?");
> stat.setString(1, null);
>
> Will this make a null value in the database or an empty string? Do we
> have to use the setNull(1, Types.VARCHAR) in order to get a null value
> entered?
The postgresql JDBC driver treats setString(x, null) identically to
setNull(x, Types.VARCHAR). I don't know how portable this behaviour is;
the javadoc is silent on how this case should be handled. You're
probably better off using setNull() explicitly.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Katsaros Kwn/nos | 2004-09-30 12:16:44 | Java app and SPI functions |
| Previous Message | Roland Walter | 2004-09-30 10:13:09 | Re: PreparedStatement.setString with null |