Hi Friend, When I insert a bug I don't know why it goes NULL value insted of 00-00-0000 into FixedDate column in database this column can be null by the fauld but when I insert directly through mysql to make sure it is working I have no problem you can see
bugNumber submittedDate fixedDate --------- ------------- ---------- 159 2002-04-15 0000-00-00 Any advice is appreciated, Elahe
Solved it my query was not correct... Thanks, Elahe PreparedStatement stmt =conn.prepareStatement("insert into bug" + "(ID,bdesc,submittedDate,userID,contact) values (?,?,?,?,?)");
Thanks,
Elahe
Once upon a time there were three bears. And they were visted by a golden haired tiny ad:
a bit of art, as a gift, that will fit in a stocking