A friendly place for programming greenhorns!
Object Relational Mapping
Cannot insert null into a non nullable column
May 08, 2008 23:55:00
Am new to JPA / Hibernate / ORM
Facing a strange issue .
1 >Created a simple table in HSQLDB
2 >Then using JPA tried persisting the data - and it worked fine
Here in DB had not defined the primary key explicitly
Now I tried to use the "Embedded" attribute
( Single Table - but two
The problem that I am facing is that if I use :
@GeneratedValue(strategy = GenerationType.SEQUENCE)
it works fine
For other options ( AUTO , IDENTITY ) get the exception ::
Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: CUST_ID
Can anyone provide some pointers related to ::
when I dont use @embedded & @Embeddable I can simply do an insert using GenerationType.AUTO - This works
when I use @embedded & @Embeddable I CANNOT do an insert unless I use
May 09, 2008 09:13:00
Sorry, I might just be confused, but embedded objects won't have an @Id on it, since it is a dependant object on another object, and that object will have the pk.
Embedded is a case where, for example, you have this table, and you want two seperate objects in Java to represent all the stuff in that one table.
And you want a User and an Address object to represent all the fields in that User table.
Address object doesn't have the id, it is in the User object. So Address is an Embedded object for the User object.
Hope that helps clear some things up if I am correctly understanding what you are asking.
Wink, wink, nudge, nudge, say no more ...
This thread has been viewed 4391 times.
All times above are in ranch (not your local) time.
The current ranch time is
May 27, 2018 17:43:28
Copyright © 1998-2018