I am aware of hibernates Automatic dirty checking capabilities if the entity is loaded and modified in the same session. But how does this work in the case of detached instances. What we do is load the object in one session close it and save the same with a different session after the object returned from the web tier. The problem is the genrated update sql includes all the columns in the table even though the intention is to save 2 or three columns. Any input is grately appreciated.

this has been discussed many time + you have to read hibernate in action


tips:
versionning + lock(obj,LockMode.READ)
or select-before-update
also see dynamic-update

Hi Anthony,

i am trying to understand how to use hibernate with web-tier.

I have created an EJB which has a method "retrieveEmployeePosition" to retrieve data. It returns a POJO.

public EmployeePosition retrieveEmployeePosition( Integer employeeId ) {
HibernateUtil.getSession();
HibernateUtil.beginTransaction();
...
HibernateUtil.commitTransaction();
HibernateUtil.closeSession();
return aEmployeePostion;
}

i have a jsp which calls this EJB method to retrieve the data:

EmployeePosition aEmployeePosition = aEmployeeDelegate.retrieveEmployeePosition( employeeId );

then i show the data in different html controls (textbox etc) using aEmployeePosition.getxxx()

my question is should i save the aEmployeePosition on my web-tier and if yes then where? what hibernate recommends?

when user makes the changes and want to update the database then what should be the line of action w.r.t hibernate?

Please reply.


Thanks

JY