Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NULL value problem!!!

 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Solved it my query was not correct...
Thanks,
Elahe
PreparedStatement stmt =conn.prepareStatement("insert into bug" + "(ID,bdesc,submittedDate,userID,contact) values (?,?,?,?,?)");
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic