Getting auto-increment value as 0 in hibernate after insert

Asked Apr 03 '17 at 13:49

Active Nov 09 '18 at 17:15

Viewed 69 times

I am getting only 0 as the auto-increment value (primary key) after database insert in hibernate. Please see the code below

Session session = HibernateSession.getHibernateSession();//Singleton class
Transaction t = session.beginTransaction();
Ticket ticket = new Ticket();
ticket.setTicket_desc("This is ticket description 5");
session.save(ticket);
//session.persist(ticket);
t.commit();
System.out.println("Created ticket id is " + ticket.getTicket_id());

Below is the xml mapping

In the database side - mysql, I can see the auto-increment working correctly, I am not sure why I am getting only 0 in java. I have also tried with session.persist(). Can you imagine where am I going wrong?

edited Nov 09 '18 at 17:15

Cœur

37,241
25
195
267

asked Apr 03 '17 at 13:49

Balaji Vignesh

Call `session.refresh(ticket)` before you access the ID. Let us know if you can't figure it out after reading the duplicate link. – Tim Biegeleisen Apr 03 '17 at 13:53
If the id is auto increment, you can try to add this to your xml mapping instead of the generator class: – June Apr 03 '17 at 13:54
Using session.refresh(ticket) is throwing me this exception ---> Exception in thread "main" org.hibernate.UnresolvableObjectException: No row with the given identifier exists: [com.bosch.database.tables.Ticket#0] – Balaji Vignesh Apr 03 '17 at 13:56
Using instead of throws xml error in eclipse @June – Balaji Vignesh Apr 03 '17 at 14:04
@Tim Biegeleisen, I am sorry but I could not figure out the from the link that you have marked as duplicate. – Balaji Vignesh Apr 03 '17 at 14:13
If the auto increment is working correctly in MySQL, then my guess is that the Hibernate session is not updating. – Tim Biegeleisen Apr 03 '17 at 14:18
I have identified the issue, fixed the issue. @June thanks, you were close. – Balaji Vignesh Apr 04 '17 at 03:31

Getting auto-increment value as 0 in hibernate after insert

0 Answers0