Hi,

I have the below two lines of code to get the record from the table but returning null in spite of record present in the table. Just before running the below code I ensured that the data inserted successfully into the database.

1) inserted the data successfully into MyData Table

public boolean insertUpdateXMLintoMyData(Long key,String messageId)throws Exception
{

Session session = sessionFactory.getCurrentSession();
MyData myData = new MyData();
myData .setKey(key);
myData .setMessageId(messageId);
session.saveOrUpdate(myData );
return true;
}

2) Fetching the data to update but returns null in spite of data present in the database.

Session session = sessionFactory.getCurrentSession();
MyData data = (MyData) session.get(MyData.class,Key,LockMode.UPGRADE);


What could be the reason.

Thanks in Advance.

You need to post the mappings of all the entities and the actual logic that does the persistence.
There's too little information to find out what it's not working.

Try this

session.saveOrUpdate only add your entity object into the level1 memory cache of current session, the database is not changed, that why nothing can be found.

The change of session level cache must be uploaded to database by
(1)org.hibernate.Transaction.commit()
or
(2) org.hibernate.Session.flush()