You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by Daniel Rall <dl...@finemaltcoding.com> on 2001/08/17 04:13:31 UTC
Re: cvs commit: jakarta-turbine-torque/src/templates/sql/base/mss ql db.props
Why should a JDBC TIMESTAMP map to a MS SQL-native DATETIME? Fedor,
it would be very helpful if you would start substantiating your
comments. I will certainly change it back if you can provide a lucid
explanation of why.
Thanks, Daniel
Fedor Karpelevitch <fe...@Barra.COM> writes:
> 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: dlr@apache.org [mailto:dlr@apache.org]
> > Sent: Thursday, August 16, 2001 1:49 PM
> > To: jakarta-turbine-torque-cvs@apache.org
> > 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 <ar...@yahoo.com>:
> >
> > "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: turbine-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org