This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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 (?,?,?,?,?)");
 
Don't get me started about those stupid light bulbs.
 
subject: NULL value problem!!!
 
Similar Threads
How can I get sysdate in java?
Variable type question?
Where I have to mention my template in XML?
mysql date problem
How can I see my record?