[GROOVY-3809] Sql.Dataset: Values are converted to string causing errors when inserting dates

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7-beta-1
• Fix Version/s: 1.7-rc-1
• Component/s: SQL processing
• Assignee: Paul King
• Reporter: Albatross
• Created: 04/Oct/09 14:37
• Updated: 07/Apr/15 19:12
• Resolved: 18/Oct/09 05:29

Description

Testcase:

myMap = [EMPNO: 10, HIREDATE: Date.parse("yyyy-MM-dd", "1982-12-25")]
dbSet.add myMap

This results in:
WARNING: Failed to add row for:

{EMPNO=10, HIREDATE=Sat Dec 25 00:00:00 CET 1982}

java.sql.SQLException: Invalid column type

The database does not recognize this date format.
The add() method should use the values as a bind variable without converting them to string.