dlr         01/08/16 13:48:44

  Modified:    src/templates/sql/base/mssql db.props
  Log:
  * Added correction by Artem Grinshtein <[EMAIL PROTECTED]>:
  
  "Mapping TIME to TIMESTAMP is wrong for MSSQL-database.
  The value of a timestamp column is unique within a
  MSSQL-database and  updated every time a row
  containing a timestamp column is inserted or updated.
  
  The correct solution is
  TIME = DATETIME"
  
  * Changed mapping for JDBC TIMESTAMP from native data type DATETIME to
  TIMESTAMP.
  
  Revision  Changes    Path
  1.2       +2 -2      jakarta-turbine-torque/src/templates/sql/base/mssql/db.props
  
  Index: db.props
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/mssql/db.props,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -u -r1.1 -r1.2
  --- db.props  2001/08/02 05:08:40     1.1
  +++ db.props  2001/08/16 20:48:44     1.2
  @@ -15,8 +15,8 @@
   VARCHAR = VARCHAR
   LONGVARCHAR = TEXT
   DATE = DATETIME
  -TIME = TIMESTAMP
  -TIMESTAMP = DATETIME
  +TIME = DATETIME
  +TIMESTAMP = TIMESTAMP
   BINARY = BINARY
   VARBINARY = IMAGE
   LONGVARBINARY = IMAGE
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to