Dear Hibernate community,

I want to insert a lot if of objects of the class "Characteristic" which has a manytoone relationship to "CharacteristicDefinitionType", but I'm having performance problems:

this.session.beginTransaction();
for (Map<String, String> row : table.getData()) {
CharacteristicDefinitionType cdt = session.createQuery("from CharacteristicDefinitionType where and name = ?").setString(0, row.get("DEFTP")).uniqueResult();
Characteristic characterstic = new Characteristic();
characterstic.setSapId(row.get("ELTUID"));
characterstic.setDefType(cdt);
characterstic.setName(row.get("MAPNAME"));
this.session.save(characterstic);
}
this.session.getTransaction().commit();

As you can see each time before inserting the characteristic object I've to fetch the corresponding characteristicdefinitiontype object by executing a query. Therefore in SQL it looks like this:
select * from characteristicdefinitiontype where ...
insert into characteristic ...
select * from characteristicdefinitiontype where ...
insert into characteristic ...
select * from characteristicdefinitiontype where ...
insert into characteristic ...
....

Now, having to execute a select statement before each insert operation makes this proccess very slow. Is it somehow possible (eg by caching) that it just makes a one-time select for all characteristicdefinitiontype objects?
select * from characteristicdefinitiontype
insert into characteristic ...
insert into characteristic ...
insert into characteristic ...
...

Of course it's possible, you could do that using one * query if the number of loaded entities is not too high, or better
take a look at the scrollable results API ;-)

http://docs.jboss.org/hibernate/stable/core/reference/en/html_single/#objectstate-querying-executing-scrolling