here which line i have to change..i want to update if record is already exxisted....else i schould be the save...


public String saveorUpdateEntity(CityMasterForm cform,HttpServletRequest request) {
_LOGGER.info("CityMasterDAO :: saveorupdate ");
SessionFactory factory = null;
Session hibernateSession = null;
Transaction transaction = null;
CityMaster cityForm = null;
/*SQLQuery query=Session.createSQLQuery(query);
query.addEntity(policy.class);
query.setString("pcode","c001");

List <Policy> plist=(List<Policy>) query.list();
Iterator <Policy> iterator=plist.iterator();*/

try {
factory = (SessionFactory) request.getSession().getServletContext().getAttribute(HibernatePlugin.KEY_NAME);
hibernateSession = factory.openSession();
transaction = hibernateSession.beginTransaction();
String query="Select * from CityMaster where cityCode='"+cform.getCityCode()+"'" +
" order by cityMasterID desc";
_LOGGER.info("CityMasterDAO :: query :: "+query);
Query qu=hibernateSession.createQuery(query);
List<CityMaster> cityList=null;
cityList=qu.list();

Calendar instance=Calendar.getInstance();
instance.add(Calendar.DATE,-1);
Date yesterday=instance.getTime();
SimpleDateFormat sdfSource = new SimpleDateFormat("dd/MM/yyyy");
String yestday=sdfSource.format(yesterday);
if(cityList.size()>0){
for(CityMaster city :cityList)
{
city.setEffectiveEndDate(yestday);
hibernateSession.saveOrUpdate(city);
hibernateSession.refresh(city);
break;
}

}
else
hibernateSession.save(cform);

Which entity u need to save ?

hi dear shynate26

id START_DATE EXPIRE_DATE PCODE
---------- ------------- -------------- ----------
5 23-APR-09 31-JUL-10 p001
6 01-AUG-09 08-NOV-09 p002
7 09-NOV-09 05-AUG-12 p003
8 09-NOV-09 05-AUG-12 p002
9 01-AUG-10 06-JUN-11 p001

here my requirement is using hibernate i want update(using criteria or hql)
1.suppose i have do save or update based on ourrequirement

2.suppose i enter with 10 01-AUG-11 06-JUN-12 p005
this is record is diffrent this is not matching with previous code like p001 or p002 or p003.....
3.so it will inserted...
4.when ever i enter same code like c002...i want update existing record and this record also i have to inserted(here two restictions suppose i entered stardate 09-dec-2016 with p002....in this time
based on p002 code 2 records is available..i want to call max(id) record..

after that we scould set poo2 EXPIRE_DATE is 08-dec-2016(ie means wat i have enter date that one minus-1 as poo2code..

can i have prevoius plz gve me..reply

use flush() before calling refresh().
It is also not advisable to use refresh() in long running session.