Re: [Hsqldb-user] Nullpointer in jdbcResultSet.getDate(int, Calendar)

[Michael L. - I. <ml...@ib...>]

I dont' understand what you want to be fixed?  If you are getting the NPE 
from this statement:

    cal.setTime(date);

then problem is in your method (you need to make sure date != null).

Or, are you saying that you're getting the NPE when you call 
ResultSet.getDate()?

Michael


----- Original Message ----- 
From: "Jacob Tomaw" <jac...@gm...>
To: <hsq...@li...>
Sent: Thursday, December 30, 2004 9:36 AM
Subject: [Hsqldb-user] Nullpointer in jdbcResultSet.getDate(int, Calendar)


All,

I am using version 1.7.3.0.  I have a column that is a DATE and nullable.

If I have a row with null in this column and then call getDate(int,
Calendar) for this column in the resultset I get a null pointer
exception.

The is the source for the method.  Taken from the 1.7.3 distribution.

    public java.sql.Date getDate(int columnIndex,
                                 Calendar cal) throws SQLException {

        java.sql.Date date = getDate(columnIndex);

        cal.setTime(date);
        HsqlDateTime.resetToDate(cal);

        return new java.sql.Date(cal.getTime().getTime());
    }

Calendar.setTime does not allow the date to be null.  So this pretty
easily throws an NPE when the date is null.  The javadoc says the
method returns "the column value as a java.sql.Date object; if the
value is SQL NULL, the value returned is null in the Java programming
language."  So, I assume the method should check for and return null
before setting the time.

There is a bug that seems to be related to this, but not directly.
The number is 1071467.  Has anyone else seen this and what should I do
to put it in the queue to be fixed?

Thanks,
Jacob Tomaw


-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user