Hibernate - PreUpdateEventListener - Locks Table

[Ally Cavs]

Hi Guys

This code works perfect for one appliction where JTA is used.
The second applictian I am attempting to get this code working in, freezes on the last line. The underlying DB in both cases is SQL Server 2008
What happens is that Hibernates locks the table on the database. I have to release the lock in the DB.

   
public boolean onPreUpdate(PreUpdateEvent pue) {
            final String entityName = pue.getEntity().getClass().toString();
            final Date transTime = new Date(); // new Date(event.getSource().getTimestamp());
            StatelessSession statelessSession=pue.getPersister().getFactory().openStatelessSession();
            retrieveSession=pue.getPersister().getFactory().openSession();
            auList=new ArrayList<AuditLog>();
            String entityStringID=getEntityID(pue.getEntity(),pue.getPersister());
            Object entityDB=retrieveSession.get(pue.getEntity().getClass(),Long.valueOf(entityStringID));

 

This code takes the item in the DB and compare withs the pue.getEntity(). pue.getEntity() holds the changed entity about to be persisted
This is for auditing purposes.

Now the issue is Hibernate persists the item first with the primary key and with blank fields
Then does an update to fill in the blank fields. So this is all happening in the 1 transaction
(I dont know why - this is hibernate behaviour and hence why im falling into onPreUpdate after onPreInstert)



The second app has the following code to manage transaction handling instead of using JTA. (Glass fish V2 is the server)

    
  try
        {
            tx = session.getTransaction();
            tx.begin();
            session.save(obj);
            session.flush();
            if (!tx.wasCommitted())
                tx.commit();
            tx = null;
        } catch (HibernateException hibExp){
            System.out.println(hibExp.getMessage());
            if (tx != null){
                tx.rollback();
                tx=null;
            }

            throw hibExp;
        }catch (Exception exp){
            System.out.println(exp.getMessage());
            if (tx != null){
                tx.rollback();
                tx=null;
            }
        } finally {
            session.close();
        }

onPreUpdate is entered on trx.commit()
Please help. Does my database pool on glassfish need a particular set up
Should I use LockMode when doing retrieve
retrieveSession.get(pue.getEntity().getClass(),Long.valueOf(entityStringID),LockMode.NONE);

I have tried various changes but cant nail it

Alan