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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
