SQL Datetime field insert failure
---------------------------------
Key: GEOS-353
URL: http://jira.codehaus.org/browse/GEOS-353
Project: GeoServer
Type: Bug
Components: WFS
Versions: 1.3.0-beta4
Environment: MySQL
Reporter: Pat Cappelaere
Assigned to: dblasby
Fix For: 1.3-rc1
Trying to insert a feature with a Datetime field in MySQL, the datetime field seems to always be 0000-00-00 00:00:00. the insert fails for that field.
GeoServer insert code translates the date field to:
date=Sat Jun 04 08:59:00 EDT 2005
This does not seem to be a valid format for MySQL (ref: http://dev.mysql.com/doc/mysql/en/datetime.html)
Thanks,
Pat.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira