aspose file tools*
The moose likes Beginning Java and the fly likes NULL  value problem!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "NULL  value problem!!!" Watch "NULL  value problem!!!" New topic
Author

NULL value problem!!!

Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
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


Thanks,
Elahe
Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Solved it my query was not correct...
Thanks,
Elahe
PreparedStatement stmt =conn.prepareStatement("insert into bug" + "(ID,bdesc,submittedDate,userID,contact) values (?,?,?,?,?)");
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: NULL value problem!!!