This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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 (?,?,?,?,?)");
 
Have you checked out Aspose?
 
subject: NULL value problem!!!
 
It's not a secret anymore!