OVERDONE :-)
TIMESTAMP should be DATETIME too.
could you please fix it since you've started it.
thanks.
fedor.
-------------------------------
Any expressions expressed here only express my own expressions.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: cvs commit:
> jakarta-turbine-torque/src/templates/sql/base/mssql
> db.props
>
>
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
