jboss - Hibernate SQLQuery bypasses hibernate session cache -

i'm "transactionalizing" extensive database manipulation , came across issue if run sql queries through hibernate not using mql approach, view of database doesn't appear correct. code uses hibernate in more appropriate manner in cases there places decided execute sql. don't did @ point "it is".

i found explanation seems explain examples wrt getting , managing transaction in code. using @transactionattribute annotation on entire class change code , finding lot of places behavior happens i'm not entirely convinced explanation applies code wrapped in annotation--i assuming using hibernate manager rely on object cache in session.

apologies in advance if referring concepts in hibernate incorrect terminology, etc.

your question confusing, assume saying hibernate not looking entities in session cache when performing native queries.

sql query, or native query, query hibernate relays database. hibernate won't parse query, , won't parse results. hibernate will, though, let handle results, convert columns properties of class. said, sounds quite natural native queries bypass session cache. that's because hibernate doesn't knows query, nor "results" of query (which not objects @ point).