Hibernate version: 2.1.6, 9.8.2004

Sybase ASE 12.1


Hi,

I need to send a "set force plan on" command prior to sending an HQL-SQL. This is to force ASE to join the table in the order I put them in my SQL.

As it is now my query takes about 30 seconds to execute (that's outside of Hibernate). With the "set force plan on" it takes 0.5 seconds.

My DBAs are telling me I need to issue that command then issue my query.

I tried "session.createSQLQuery" and "session.createQuery" without success.

Any help will be appreciated.


Thanks

session.connection().prepareStatement()

Thanks Gavin. It's working perfectly.

Hi,

This suggestion will not use Hibernate feature of returning the list of Objects that I need. Instead it returns Resultset.

Is there anyway to force plan on HQL queries and get the list of objects ?

Thanks,
Uma