Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:0.99

I'm using NHibernate for C# application in Oracle 9.2.

I'm trying to use optimistic access of Oracle to resolve an SQL Join.
Anyone knows if it's possible to do it??

This is my HQL:

select /*+RULE*/ a
FROM PagamStorno a , Posizione b
where a.ProgPosizioneNullable=b.ProgPosizione
and b.ProgPosizione = :progPos
order by a.ProgPagamento

i could not use RULE mode in NHibernate?

Thanks

F.