java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

[aquila....@gmail.com]

Hi all,

I am  recently get familiar with  dbfit with its new release. I am  currently using mysql database and  got stuck  In running inspect query on dbfit when  the date column may have a date with '0000-00-00' 

As per my understanding  of mysql 

Illegal DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type ('0000-00-00' or '0000-00-00 00:00:00').

So In that case when  i run inspect query then i got exception. Please let me know if any one having any solution. please see the attachment for Exception message.

Thanks 

Harshit

[Yavor Nikolov]

How does your test look like?

--
You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at http://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.

[Yavor Nikolov]

You may try the solution described here: http://stackoverflow.com/questions/782823/handling-datetime-values-0000-00-00-000000-in-jdbc

I.e. add zeroDateTimeBehavior=convertToNull parameter to your database connection URL.

Regards,
Yavor