Hi,

I am new in hibernate.

My problem is that in the following code, the SQLQuery, executed by the getList() method, stay locked and never returns. But when I execute the sqlquery in the console of the oracle client (PL/SQL Developer), no problem occurs. No problem occurs when I use pure JDBC to execute the same query of the getList() method.

Does anybody knows why in hibernate the SQLQuery stay locked??

please, help me!!!!

Thanks!!


Hibernate version: 3.1

Code between sessionFactory.openSession() and session.close():

int count = getDao(session).getCount();

if (count != 0) {
List l = getDao(session).getList();
}


Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 10g

Hi,

the method getResultSet of the Batcher instance stay locked when ps.executeQuery() is executed, and never returns, but when I use JDBC, instead of hibernate, to execute the same query, no problem occurs.

why this happens in hibernate???

thanks!!