How to set java.sql.Date to null ?

Поиск
Список
Период
Сортировка
От Kapoor, Nishikant X
Тема How to set java.sql.Date to null ?
Дата
Msg-id C7DCBA49A357D11196A500805F851ACD0146163E@MNMAIL04
обсуждение исходный текст
Ответы Re: [INTERFACES] How to set java.sql.Date to null ?  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-general
Hi there

I'm trying to pass a java.sql.Date parameter to a sql query using
JDBC-PostgreSQL interface. The problem shows up when I pass a null
java.sql.Date but as it happens in my application, the user may or may
not
enter the logDate.
(It works fine if the java.sql.Date(logDate) is a valid date).
Here is the code:

    PreparedStatement pstmt = null;
    try {
      pstmt = connect.prepareStatement("insert into prfs (prfNo, author,
severity, blockFunc, probArea, status, probDesc, logDate, estCompDate,
actCompDate, assigned, assignee,
 solution, attachment, siemensVar, reviewer) values " +
"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" );

      pstmt.setString(1,  prfNo);
      pstmt.setString(2,  author);
      pstmt.setInt(3,     severity);
      pstmt.setInt(4,     blockFunc);
      pstmt.setInt(5,     probArea);
      pstmt.setInt(6,     status);
      pstmt.setString(7,  probDesc);
-->   pstmt.setDate(8,    logDate); <-- NullPointerException ex
    } catch (SQLException e) { }


How do I set a Date to be a null ?

Thanks
Nishi

--------To err is human but to really mess it up is computer--------
mailto:nishikant.x.kapoor@nspco.com   http://www.c3ipros.com/nkapoor
-----------------------------------~~~------------------------------


В списке pgsql-general по дате отправления:

Предыдущее
От: "Krasnow, Greg"
Дата:
Сообщение: default date
Следующее
От: "John E. Garrott"
Дата:
Сообщение: Re: [GENERAL] psql problem