Execute select query (longer than 4000 chars) on oracle from java using hibernate

Question

I have a long select query, oracle database (11g) and hibernate 3. On java side I have query:

String query = "Select {some different columns} from {some tables} where param1='{some string longer than 4000 chars}' and param2= ...";

How can I execute it and get the results using hibernate session? If I just use createSQLQuery, I get:

java.sql.SQLException: ORA-01704: string literal too long

And I would prefer solution, that doesn't use session.connection() because it's deprecated.

Thanks!