SQLServer datatype for TIMESTAMP

Description

We upgraded Liquibase from 2.0.5 to 3.0.7.

With the following ChangeSet

we now get the following error message

The old Liquibase version changed every TIMESTAMP column to a DATETIME column. The classes are annotated with PersistentLocalDateTime to persist Joda LocalDateTime via Hibernate.

We had to modify our ChangeSets with

Environment

SQL Server 2008

Activity

Show:
Dmitry Gil
November 20, 2013, 7:57 AM

Why don't you use type="DATETIME"?

Rainer Müller
November 20, 2013, 8:32 AM

The Joda LocalDateTime is mapped to a java.sql.Timestamp. For MSSQL the correct datatype is DATETIME.

see

Nathan Voxland
November 20, 2013, 10:30 PM

Fixed with

Duplicate

Reporter

Rainer Müller

Components

Fix versions

Affects versions

Priority

Major