Ticket #183 (new defect)
coldfusion.runtime.Cast$DateConversionException: The value could not be converted to a date
| Reported by: | bwhitehall | Owned by: | dhughes |
|---|---|---|---|
| Type: | defect | Priority: | normal |
| Milestone: | 1.0 Release | Component: | Reactor - DAO |
| Version: | 1.0 | Severity: | normal |
| Keywords: | coldfusion.runtime.Cast$DateConversionException timestamp date | Cc: |
Description
Error:
Saving a MS-SQL-based record object with a SSMA_Timestamp field generates
coldfusion.runtime.Cast$DateConversionException: The value class [B
could not be converted to a date.."
Example
person = factory.createRecord("person");
person.setName("test");
Person.save(); <--generates error
Thoughts:
SSMA_Timestamp is a timestamp field. According to Adobe docs, MS SQL timestamps should be mapped using cfqueryparam cfsqltype="binary". Instead function "getCfSqlType" maps it to cfsqltype="timestamp".
See http://svn.reactorframework.org/trunk/reactor/data/mssql/ObjectDao.cfc
CF Version: ColdFusion 7 standalone
OS: Windows Server 2000
DB: MS SQL Server 2005
Change History
Note: See
TracTickets for help on using
tickets.

