beehive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Schoettger" <>
Subject Re: Inserting Null Dates
Date Tue, 17 Jul 2007 20:03:02 GMT
I wasn't able to recreate the issue (with Derby).  Were you getting
errors from the SQL Driver ?  Or were they from the JDBC control?

If you can include the error messages you were getting I'll take
another shot at reproducing this issue.

  - Chad

On 7/17/07, <> wrote:
> Hello,
> I am having the following problem:
> I want to insert a NULL for a row in a PostgreSQL 8.2 DATE field.
> I am trying the follwoing SQL JDBC Control function:
>         @SQL(statement="insert into test(id,date) values ({id},{date})")
>         public void insertIntoTest(int id, java.sql.Date date);
> I cannot do that with date=null.
> I also tried with {d{date}} and then tried to use a second parameter of String
> with null, and "" values, both with {date} and {d {date}} substitutions -
> I get different error messages.
> How can I insert a null date value with the usual substitutional syntax?
> This will be necessary when I get a table with a default non null value for a
> DATE column and I will need to purposefully set the value to null.
> Kind regards:
> al_shopov

View raw message