Cannot format given object as a date

Question

I want to insert a product into table. For that I have a Date field for which I use Date Chooser Combo. and for adding date for that product I wrote the following code,

String sql = "INSERT INTO ProductInfo(Name,Price,Date,Image,Category) values(?,?,?,?,?) ";
            pst=conn.prepareStatement(sql);
            pst.execute();

            pst.setString(1, txt_name.getText());
            pst.setString(2, txt_price.getText());

            SimpleDateFormat dateFormat = new SimpleDateFormat("MM-dd-yyyy");
            String addDate = dateFormat.format(txt_AddDate.getDateFormat());
            pst.setString(3, addDate);

But this is giving me "Cannot format given object as a date" error. I've tried a lot but can't solve. Anyone help me please?

Possible duplicate of [Using setDate in PreparedStatement](http://stackoverflow.com/questions/18614836/using-setdate-in-preparedstatement) — Nikolas, Mar 13 '17 at 15:19
How about `pst.setDate(3, txt_AddDate.getDateFormat()));` (assuming that `getDateFormat()` doesn't what the name implies but rather returns a date (otherwise `dateFormat.format(txt_AddDate.getDateFormat());` wouldn't compile either). — Thomas, Mar 13 '17 at 15:19
It depends of four database but surely the format MM-dd-yyyy is not correct, what database are u using? — Mikel, Mar 13 '17 at 15:21
For mysql yyyy-mm-dd must work, you try it? The value of addDate is correct? — Mikel, Mar 13 '17 at 15:35
Exactly, what line throws the exception? ("Cannot format given object as a date"), what is the type of txt_AddDate variable? — Mikel, Mar 14 '17 at 07:26

score 0 · Answer 1 · answered Mar 14 '17 at 09:34

in

pst.setString(3, addDate);

you are telling that you want to use a String in a Date property.

you should change it to

pst.setDate(3, addDate);

And also why not use the date that you have? why not?

pst.setDate(3, txt_AddDate.getDateFormat());

If this don't work because a format or simple because it doesn't return a date and you still want to use the SimpleDateFormat you could use something like:

pst.setDate(3, java.sql.Date.valueOf(addDate));

Cannot format given object as a date

1 Answers1