Android Question [RESOLVED] jdbcSQL date Value '0000-00-00' can not be represented

[sigster]

Hi

I am using jdbcSQL and mysql

when I try to get date I get this error


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

                Dim adate As String = Crsr.GetString("VV_date")
                If adate = Null Then adate = ""
                row(8) = " " & adate

 

[makis_best]

I think this caused by JDBC, add zeroDateTimeBehavior=convertToNull at the end of the jdbc connection string.
That will fix the problem. Do something like this..

jdbc:mysql://127.0.0.1:3306?zeroDateTimeBehavior=convertToNull

 

[Erel]

Nulls and strings don't go well together.
If the above suggestion hasn't solved the issue then please post the full error message.

 

[sigster]

Thanks

this works