18. May. 06, 16:08
by korbendallas
about: helma sql
Problems with Object-Relational Mapping and SQL-Date format
The following error message can occure while mapping a SQL table that contains datetime fields with zero values to an Helma internal object :
Cannot convert value '0000-00-00 00:00:00' from column XY
This problem seems to be a MySQL Bug and could be solved by changing the connection string to the database (in db.properties) to:
myDataSrc.url = jdbc:mysql://localhost/[database]?zeroDateTimeBehavior=convertToNull
Cannot convert value '0000-00-00 00:00:00' from column XY
This problem seems to be a MySQL Bug and could be solved by changing the connection string to the database (in db.properties) to:
myDataSrc.url = jdbc:mysql://localhost/[database]?zeroDateTimeBehavior=convertToNull
