4

I want to set default value of integer value in my table using hibernate annotations.It works but when i give default value as 1 it always set it to zero in the database.I don't know what i am doing wrong.Any help will be appreciated

This is what i am using

@Column(name = "interval",nullable = false, columnDefinition = “int default 1")
private int interval;

I have checked almost all the links i dont know when i am setting the value to be 1 then why 0 is getting stored in the database

I know we can do it as 

@Column(name = "interval",nullable = false, columnDefinition = “int default 1")
private int interval = 1;

but i dont want to set the value as above I want to know to any way to set the default value using hibernate

I had already seen these links How to set default value in Hibernate Set default values using hibernate annotations in MYSQL

Community
  • 1
  • 1
kirti
  • 4,499
  • 4
  • 31
  • 60

1 Answers1

2

That's because the annotation describes the column, not the data.

Hibernate does not know if the primitive value was changed by user or stayed the same by default.

In java the primitive integer is by default initialized to 0. If you want the interval to be 1 by default, you need something like this.

@Column(name = "interval",nullable = false, columnDefinition = “int default 1")
private int interval = 1;

or another way is to declare interval to be Integer:

@Column(name = "interval",nullable = false, columnDefinition = “int default 1")
private Integer interval;
WeMakeSoftware
  • 9,039
  • 5
  • 34
  • 52
  • if i will set the interval value then what is the need of giving the columnDefinition in the annotation – kirti Jan 28 '15 at 14:03
  • that's the default value if you're providing null into column. The trick here is that you cannot provide null to a primitive type – WeMakeSoftware Jan 28 '15 at 14:03
  • Yes But i want to know is there any way to set the default value directly from the annotation.. because right now i am doing the same as you have shown – kirti Jan 28 '15 at 14:05
  • 1
    you can declare interval to be Integer instead of int, but this will bring you to the whole new world of problems – WeMakeSoftware Jan 28 '15 at 14:06