using null value timestamps

From: "Scott Muir" <wsmuir(at)islandnet(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: using null value timestamps
Date: 2001-08-14 01:16:33
Message-ID: NCBBKLMCJOGCLFHOFECNEEPCDPAA.wsmuir@islandnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I have a problem with using a null value for a timestamp. Here's a small
example of what I mean.

PreparedStatement pstmt =
con.prepareStatement("UPDATE sometable SET date = ?");
pstmt.setTimestamp(1, null);
int rows = pstmt.executeUpdate();

Here's the exception that I'm getting. It looks like I can't use nulls for
timestamps.

java.lang.NullPointerException
at java.util.Calendar.setTime(Calendar.java:882)
at java.text.SimpleDateFormat.format(SimpleDateFormat.java:400)
at java.text.DateFormat.format(DateFormat.java:305)
at
org.postgresql.jdbc2.PreparedStatement.setTimestamp(PreparedStatement.java:3
88)
at Test.update(Test.java:40);

We're using version 7.1.1 and the jdbc which comes with 7.0.3 and java 1.3,
redhat 7.1

Thanks,
Scott.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Philip Camilleri 2001-08-14 08:51:24 PQsendQuery() -- There is no connection to the backend
Previous Message Constantin Teodorescu 2001-08-13 19:58:02 Re: Pgaccess on win2k