I am using HIbernate 3.1.3
RAD 7
compiling to jre 1.4
Oracle 9

A query which I can ran in few seconds in a sql client takes long time 2 to 3 minths to run through hibernate
I use plain sql and not HSQL

I nerrow down the problem to this line of code
ResultSet rs = ps.executeQuery();
in
AbstractBatcher public ResultSet getResultSet(PreparedStatement ps) throws SQLException

ps is of type com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement

The query in the end is returned with the right results.

any idea?