Hi, I have the Hibernate model

@Cache(usage = CacheConcurrencyStrategy.NONE, region = SitesConstants.CACHE_REGION)

public class Node extends StatefulEntity implements Inheritable, Cloneable {

private Node _parent;

private List<Node> _childNodes;

.. }

@Cache(usage = CacheConcurrencyStrategy.NONE, region = SitesConstants.CACHE_REGION)

public class Page extends Node implements Defaultable, Securable {

private RootZone _rootZone;

......

@OneToOne(fetch = FetchType.LAZY)

@JoinColumn(name = "root_zone_id", insertable = false, updatable = false)

public RootZone getRootZone() {

    return _rootZone;

}

public void setRootZone(RootZone rootZone) {

    if (rootZone != null) {

        rootZone.setPageId(this.getId());

        _rootZone = rootZone;

    }

}

I want to get all pages ( call getSiteTree), so I using this query

String hpql = "SELECT n FROM Node n ";

See the trace I find Page.setRootZone(RootZone) line: 155
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 39
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 25
Method.invoke(Object, Object...) line: 597
BasicPropertyAccessor$BasicSetter.set(Object, Object, SessionFactoryImplementor) line: 66
PojoEntityTuplizer(AbstractEntityTuplizer).setPropertyValues(Object, Object[]) line: 352
PojoEntityTuplizer.setPropertyValues(Object, Object[]) line: 232
SingleTableEntityPersister(AbstractEntityPersister).setPropertyValues(Object, Object[], EntityMode) line: 3580
TwoPhaseLoad.initializeEntity(Object, boolean, SessionImplementor, PreLoadEvent, PostLoadEvent) line: 152
QueryLoader(Loader).initializeEntitiesAndCollections(List, Object, SessionImplementor, boolean) line: 877
QueryLoader(Loader).doQuery(SessionImplementor, QueryParameters, boolean) line: 752 QueryLoader(Loader).doQueryAndInitializeNonLazyCollections(SessionImplementor, QueryParameters, boolean) line: 259
QueryLoader(Loader).doList(SessionImplementor, QueryParameters) line: 2232
QueryLoader(Loader).listIgnoreQueryCache(SessionImplementor, QueryParameters) line: 2129
QueryLoader(Loader).list(SessionImplementor, QueryParameters, Set, Type[]) line: 2124
QueryLoader.list(SessionImplementor, QueryParameters) line: 401 QueryTranslatorImpl.list(SessionImplementor, QueryParameters) line: 363 HQLQueryPlan.performList(QueryParameters, SessionImplementor) line: 196 SessionImpl.list(String, QueryParameters) line: 1149
QueryImpl.list() line: 102
QueryImpl.getResultList() line: 67
NodeDaoImpl.getSiteTree(long) line: 358 PageNodeServiceImpl.getSiteTree(long) line: 797 NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 39
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 25
Method.invoke(Object, Object...) line: 597
AopUtils.invokeJoinpointUsingReflection(Object, Method, Object[]) line: 307 JdkDynamicAopProxy.invoke(Object, Method, Object[]) line: 198
$Proxy100.getSiteTree(long) line: not available

the calling setRootZone in Page makes Hibernate issue a hit to database. I don't want this.

So my question is + Why query String hpql = "SELECT n FROM Node n "; issues un-expected trace logs like above.

Why the query String hpql = "SELECT n.nodename FROM Node n " not?

What is the mechanism behind?

Note: Im using hibernate caching level 2.

• In case I don't want to see that trace logs. I mean I just get Node data only. How to do ?

Thanks for your help.

Sorry for my bad english :( Van