Cannot convert value from column 9 to TIMESTAMP

Classic Servoy
1

Have anybody seen the following error thread in the Server log?

java.sql.SQLException: Cannot convert value ‘0000-00-00 00:00:00’ from column 9 to TIMESTAMP.

What could it be?

The solution’s database Servers in connection with this error message is MySQL 5.0.

2

Hi Carlos,

I think this is actually a jdbc error and not so much a MySQL error but you didn’t provide the full trace so I have to guess here.
Anyway the value ‘0000-00-00 00:00:00’ is NOT a valid timestamp. Fix the data or change that column to allow nulls (and change those invalid values into nulls).

3

Thanks Roberts,

That’s what I suspected. I’ll check the version of the jdbc driver, BUT, I will do as you suggested. Although the value ‘0000-00-00 00:00:00’ is valid in the database… go figure. I won’t bother, and I’ll set the timestamp default as NULL and not as ‘0000-00-00 00:00:00’.

Thanks again!