How to auto insert Current DATE in SQL with Java / Hibernate

Question

I need to add automatically the current date into my Database when I create a new OperantionBank. I'm using Hibernate. Thanks

import java.io.Serializable;
import java.sql.Date;
import javax.persistence.*;
import org.hibernate.annotations.Generated;
import org.hibernate.annotations.GenerationTime;

@Entity
public class OperationBank implements Serializable {
private static final long serialVersionUID = 1L;

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;

private String wordring;

private Double amount;

@Generated(GenerationTime.ALWAYS)
@Temporal(javax.persistence.TemporalType.DATE)
private Date dateoperation = new java.sql.Date(new java.util.Date().getTime());

@OneToOne
private Account account;

so, what happens when you run the above code?Did it work? Post the logs if you are getting any exceptions. — ManuPK
– ManuPK, Commented Feb 25, 2012 at 5:51
there is no exceptions but the col "date" in my sqldatabase is filled by NULL. — socrateisabot
– socrateisabot, Commented Feb 25, 2012 at 6:47

elusive-code · Accepted Answer · 2013-11-21 14:51:14Z

5

While Emil H is correct, I would like to add that way you did should work too.

It didn't most likely because the name of the column (you said in comment it is "date") doesn't match name of the field ("dateoperation").

You could either rename field/column, or add annotation:

@Column(name = "date")

Also note: you don't have to use java.sql.Date, it should work with java.util.Date just as well.

import java.util.Date;
...

@Column(name = "date")
private Date dateoperation = new Date();

answered Nov 21, 2013 at 14:51

elusive-code

1,18310 silver badges9 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:58:53Z

3

This answer might help you:

https://stackoverflow.com/a/221827/355499

In essence you use @PrePersist and/or @PreUpdate annotation to generate the dates when needed.

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Feb 25, 2012 at 6:28

Emil L

21.2k3 gold badges48 silver badges71 bronze badges

Comments

Sebastián Riquelme · Accepted Answer · 2020-03-04 20:16:58Z

0

For create, you need to use:

@CreationTimestamp
@Generated(GenerationTime.ALWAYS)
@Temporal(javax.persistence.TemporalType.DATE)
private Date dateoperation = new java.sql.Date(new java.util.Date().getTime());

answered Mar 4, 2020 at 20:16

Sebastián Riquelme

544 bronze badges

1 Comment

Torben Jan 23 at 7:43

@CreationTimestamp and @Generated(GenerationTime.ALWAYS) are conflicting annotations. They should not be used together.

CPlus · Accepted Answer · 2025-01-31 02:04:40Z

0

Try this as input: 2004-05-19

@Temporal(TemporalType.DATE)

private Calendar tryMe;

edited Jan 31 at 2:04

CPlus

5,10948 gold badges33 silver badges77 bronze badges

answered Jun 8, 2021 at 23:38

Mezen sboui

392 bronze badges

Comments

ankit · Accepted Answer · 2018-07-19 12:23:53Z

-1

Just use:

@CreatedDate
@Temporal(TemporalType.DATE)
@Column(name = "start_date")
private Date startDate;

answered Jul 19, 2018 at 12:23

ankit

2,8853 gold badges32 silver badges58 bronze badges

1 Comment

Torben Jan 23 at 7:46

@CreatedDate is not a Hibernate annotation.

Collectives™ on Stack Overflow

How to auto insert Current DATE in SQL with Java / Hibernate

5 Answers 5

Comments

Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related