Hibernate version: 3

MySQL 5

I have a set of values in a hashmap which i will have to insert into the database...

The hashmap will contain values like {0.key="xxx", 1.key="yyy",...}

I try to get the values from the hashmap with a for loop and save all those values to the session. And i will flush and commit the session and traction after the loop finishes execution.

When i try to complete this task with the following code, only one insert statement is being executed.


for(int i=0; i<valueMap.size(); i++){
Keywords key = new Keywords(); //Keywords is the class for the table
key.unPack(valueMap, i); // Unpack is method which assigns values to
// the fields, Value map is the hashMap
session.clear();
session.save(key);
}
session.flush();
tr.commit();

Method unPack():
public void unPack(HashMap map, int i) {
this.keyword = map.get(i+".key").toString();
}


And if i try with this code, all the insert is being executed...


for(int i=0; i<valueMap.size(); i++){
Keywords key = new Keywords();
String id = valueMap.get(i+".key").toString();
queryStr = "from Keywords where keyword='"+id+"'";
if(queryStr!=null){
Query query = (Query)session.createQuery(queryStr);
key.unPack(valueMap, i);
if(query.list().isEmpty()){
session.clear();
session.save(key);
}
else{
session.clear();
session.update(key);
}
}
else{
objSel.unPack(valueMap, i);
session.clear();
session.save(key);
}
}
session.flush();
tr.commit();


Where might be the problem? Please help me...
Thanks is advance

Do you know what Session.clear() does? Why are you using it all over the place? Under normal circumstances, you do not need to use this method.

http://www.hibernate.org/hib_docs/v3/ap ... tml#clear()

-Chris

Thanks for the reply. It says session.clear() clears all saved objects...

Ok. When i dont use session.clear(), i get an exception like,
Session is already assoicated with someother object... and so on...

What should i use there instead of session.clear() ?

Hi naren.sarma
Post your Exact Error Stack trace