I'm getting error "RDMS-F-VIEWNORET, view cannot be retrieved by database key"
when accessing a view built by "GROUP BY" via calling session.find(query, value,
type).

This is a known issue for Oracle RDB database, see
http://www.kuzbass.ru/docs/rdb702/oracl ... o_108.html,

The workaround is either to use nondynamic cursors to access the view or access the base tables that make up the view, not the view itself.

We can't access base tables, *have to* access views, so the only one choice for us is looking for a solution from hibernate to use nondynamic cursors since the legacy databse never goes away. Is it possible to pass a flag into session.find() to turn on/off dynamic cursor for a particular query? Or any better ideas?