java.sql.Date not inserted into datatables

Question

I have a class which contains:

@Column(name = "end_date")
private Date endDate;

and its setter

public void setEndDate() {
    endDate = new java.sql.Date(Calendar.getInstance().getTime().getTime());
    System.out.println(endDate);
}

When I'm calling the setter, and check again if the value is correct, everything's fine.(even getEndDate().getClass() ). However, when I'm saving my object into PostgreSQL (myObject.persist()), there's no value on END_TIME column. Other values are correct.

Does anyone know what's the problem?

Also, I have to mention that hibernate is set to create SQL tables

Setter and getter:

public void setEndDate(Date endDate) {
    setEndDate();
}
public Date getEndDate() {
    return endDate;
}

Am I getting correctly that the column is called END_TIME on the table and end_date in the @Column tag? This might explain … :-) — Anonymous
– Anonymous, Commented Mar 23, 2016 at 11:58
With a private field, hibernate will use java bean standard setters and getters. Can you post the other setters (that take an argument) and getters you have for that field on that bean? — Andrew Norman
– Andrew Norman, Commented Mar 23, 2016 at 12:02
OleV.V , it was me that wrote end_time uppercased. @AndyN, I don't have a setter wich takes a parameter, I guess there is the problem — UnguruBulan
– UnguruBulan, Commented Mar 23, 2016 at 12:06
I edited te post, and added setter/getter. It's still not working — UnguruBulan
– UnguruBulan, Commented Mar 23, 2016 at 12:13
@Adyzds It is not the case that @Olev.V was commenting on. The annotation is end_date. If the column is end_time, the annotation does not match. — bradimus
– bradimus, Commented Mar 23, 2016 at 12:27

Ravi Kavaiya · Accepted Answer · 2016-03-23 12:38:18Z

1

import java.util.Date instead of import java.sql.date
assign current date as per following code
default date assign while creating object of this entity if user need to change then using setter on run time

try this it will work

@Column(name = "END_TIME")
private Date endDate = new Date();

public void setEndDate(Date endDate) {
  this.endDate = endDate;
}

public Date getEndDate() {
    return endDate;
}

edited Mar 23, 2016 at 12:38

answered Mar 23, 2016 at 12:27

Ravi Kavaiya

8576 silver badges16 bronze badges

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

1 Comment

UnguruBulan Over a year ago

It's working, thank's man! Still don't understand why my approach wasn't working

VinhNT · Accepted Answer · 2016-03-23 12:36:49Z

0

I use java.util.Date for this case, and change the mapping of your @Column as

@Column(name = "end_time")
private Date endDate = new Date();

public void setEndDate(Date endDate) {
  this.endDate = endDate;
}

public Date getEndDate() {
    return endDate;
}

edited Mar 23, 2016 at 12:36

answered Mar 23, 2016 at 12:16

VinhNT

1,1119 silver badges14 bronze badges

4 Comments

UnguruBulan Over a year ago

the same thing. no value in database

VinhNT Over a year ago

I see you mark the column with end_date but checking the value in END_TIME, is that anything wrong?\

UnguruBulan Over a year ago

I told you above that I uppercased the column name. In database it's "end_time"

VinhNT Over a year ago

I edit answer and change the @column to end_time, logically, this column name is not case-sensitive

Collectives™ on Stack Overflow

java.sql.Date not inserted into datatables

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related