Mapping SQL-Server Datetime Column

Question

I'm using Spring Boot with Spring Data JPA to map an Entity to a table in a SQL Server database for which I've created an @Embeddable composite key. There's a column I'd like to use as part of the key and according to SQuirreL its type name is datetime and the class name is java.sql.Timestamp. The key class looks like this:

@Embeddable
public class MyEntityIdentifier implements Serializable {

    @Column(name = "LastUpdateDateTime")
    private Timestamp lastUpdateDateTime;

...but the lastUpdateDateTime property always resolves to null without error. I've checked and there are no null fields for this column. I've also tried resolving to java.util.Date without success. Is there another type I should be using or something I'm doing wrong?

How are you mapping to the table? Could you be using a query or view that isn't including that column? — ᴇʟᴇvᴀтᴇ
– ᴇʟᴇvᴀтᴇ, Commented Jan 17, 2018 at 18:08
With the @Table annotation - column is definitely there :/ — TheRealJimShady
– TheRealJimShady, Commented Jan 17, 2018 at 18:10
the sql server jdbc driver docs say that java.sql.timestamp is the correct type to map to learn.microsoft.com/en-us/sql/connect/jdbc/… — TheRealJimShady
– TheRealJimShady, Commented Jan 17, 2018 at 18:14
nailed the little sucker, see answer below in case you ever run into this. — TheRealJimShady
– TheRealJimShady, Commented Jan 17, 2018 at 18:23

TheRealJimShady · Accepted Answer · 2018-01-17 18:20:59Z

3

Hibernate will internally convert to a native Java type (i.e. java.util.Date as opposed to java.sql.Timestamp) by adding the @Temporal annotation.

@Column(name = "LastUpdateDateTime")
@Temporal(TemporalType.DATE)
private Date lastUpdateDateTime;

answered Jan 17, 2018 at 18:20

TheRealJimShady

4,3655 gold badges26 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Savitsky Over a year ago

Just wanted to add that this date treatment is not Hibernate-specific, but mandated for any JPA implementation

sunitkatkar Over a year ago

Also look into the @DateTimeFormat annotation provided by Spring in case you are using Spring JPA in your project.

Collectives™ on Stack Overflow

Mapping SQL-Server Datetime Column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related