Hi,
Im porting a J2EE application from CMP/CMT to hibernate. We use the framework from
http://www.cassar.id.au/hibernate-j2ee/ to integrate hibernate.
In some parts of our application we use finders the retreive the data from the database. In one transaction some finders are called many times with different parameter values. A classic example for prepared statements.
Now we have the problem, that hibernate is about 3-4 times slower than our application server (Orion). I looked at the hibernate code and did a little moving step by step to the code. The main performance killer is, that for every finder execution a NEW prepared statement is created!
Why do you use prepared statements if you dont reuse them or is this a configuration problem?
Thanks in advance, and please dont get me wrong. I like hibernate and I think it is the best persistence layer around.
Thanks.
Alex