[ http://jira.andromda.org/browse/DB-9?page=history ]
Chad Brandon closed DB-9:
-------------------------
Resolution: Fixed
fixed, thanks.
> MSSQLMappings.xml uses invalid datatype
> ---------------------------------------
>
> Key: DB-9
> URL: http://jira.andromda.org/browse/DB-9
> Project: Database Cartridge
> Type: Bug
> Environment: MS SQL
> Reporter: Nayan Hajratwala
> Assignee: Chad Brandon
> Priority: Critical
>
> MSSQLMappings.xml has the following mappings:
> <mapping>
> <from>datatype::Date</from>
> <to>DATETIME</to>
> </mapping>
> <mapping>
> <from>datatype::Time</from>
> <to>DATETIME</to>
> </mapping>
> <mapping>
> <from>datatype::Timestamp</from>
> <from>datatype::DateTime</from>
> <to>TIMESTAMP</to>
> </mapping>
>
> According to the SQL Server docs, the only really valid fields are DATETIME
> and SMALLDATETIME. Trying to use a TIMESTAMP field in MSSQL causes the
> create scripts to fail.
> Here's an article about it:
> http://www.databasejournal.com/features/mssql/article.php/2191631
> SMALLDATETIME seems relatively lame, and I can't imagine why you would want
> to use it unless running in an extremely memory constrained environment, so
> the TIMESTAMP value should be changed to DATETIME.
> Thanks!
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
