Hi,
I am new to hibenate. so, i need some help. I am storing value in table using Annotations and EntityManagerAPI.

I am storing the name, age in user table, in that table id is primary key and also autoincreament value. so, i am doing that using below way :

EntityManager entityManager = null;
User user = new User();
user.setName("abc");
user.setAge(12);
---
some code
---
entityManager.persist(user)

In above code, id is primay key and i am not setting id in user object. so , how i will retrieve the value of that primary key, which is inserted in above record ? Do i need to again submit second query using find method ?

Is there any way, that give us value primay key of inserted record without submitting second query ?

Thanks in advance.

Hi,

just call getId() on the persisted object. For a more detailed discussion on the subject see http://forum.hibernate.org/viewtopic.php?t=986388.

--Hardy

Thanks for reply.

I tried below different way, but still not working.

1
entityManager.persist(user);
user.getId();
entityManager.commit();

2
Session session = (Session)entityManager.getDelegate();
int id = ((Integer)session.getIdentifier(user)).intValue();

3
User user1 = (User)entityManager.merge(user);

Hi,

maybe you could provide some more information, for example the annotated classes, which db you are using and which version of hibernate.

Hi,

i am using hibernate - 3.2 and hibernateEntityManager-3.3.2.CR1
and MySQL Database.

Bena class :
@Entity
@Table(name = "wiklet", catalog = "my_db")
public class Wiklet implements java.io.Serializable {

private long wikletId;

private ContactDetails contact;
private Project project;
private Integer dekiPageId;

public Wiklet() {
}

public Wiklet(long wikletId) {
this.wikletId = wikletId;
}

@Id
@Column(name = "wiklet_id", unique = true, nullable = false, precision = 10, scale = 0)
public long getWikletId() {
return this.wikletId;
}

public void setWikletId(long wikletId) {
this.wikletId = wikletId;
}
}

and my code :

public void store(Object object){

EntityManager entityManager = null;

entityManager = JPAEntityManagerFactory.getEntityManager();

EntityTransaction transaction = entityManager.getTransaction();

transaction.begin();
entityManager.persist(object);
transaction.commit();

}

and in call to above method, i am passing bean class object.

Hi,

do you use any other mapping files, or where do you define the id generator strategy. If you just want to use annotations try adding @GeneratedValue after @Id. See also http://www.hibernate.org/hib_docs/annotations/reference/en/html_single/#entity-mapping-identifier.

--Hardy

Hi,

i just change in Id annothations .

@Id @GeneratedValue(strategy=GenerationType.AUTO)
@Column(name = "wiklet_id", unique = true, nullable = false, precision = 10, scale = 0)
public long getWikletId() {
return this.wikletId;
}

and it works :-)

Thanks for help, but still i didnt understant the problem, so can u pls tell me that?

Without @GeneratedValue Hibernate assumes you generate the ids manually.