Hi,

I have faced similar issue recently where we have a distributed server(currently consists of 2 hosts) trying to execute similar HQL at the same time(database : Oracle). One server is able to do so and all of its threads are able to process the hql and gets the result. On the other hand, the second server tries to run the same hql and hungs! i.e. all the threads of this server which are trying to execute this hql are in hung state and does not come out for ever. the log shows the trace of the hql which is being fired by hibernate but after that nothing happens. On the DB side, we can see that queries never reaches. CPU of server host shows 100% utilization!

This looks a similar to what this bug describes and I thought to verify once if this type of issue was seen in hibernate version 3.2.4 or beyond too!

Thanks,