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
Assigned to: 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
