Hibernate Community • View topic - Second level and query caches not helping!

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Second level and query caches not helping!

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

EdLaFave

Post subject: Second level and query caches not helping!

Posted: Wed Nov 12, 2008 11:45 am

Newbie

Joined: Mon Jan 28, 2008 1:55 pm
Posts: 19

I'm using Hibernate in conjunction with Spring. I have turned on the second level cache and query caching but I'm not seeing a performance benefit.

Hibernate version:
3
Player.hbm.xml:

Code:

<hibernate-mapping package="emst.dao.player">
   <class name="Player" table="PL_Players">
      <cache usage="nonstrict-read-write"/>
      <id name="databaseKey" column="databaseKey" type="long">
         <generator class="native" /> 
      </id>
      <property name="loginId" type="string" not-null="true" />
      <property name="simulationId" type="long" not-null="true" />
      <property name="salutation" type="string"/>
      <property name="firstname" type="string" not-null="true" />
      <property name="lastname" type="string" not-null="true" />
      <property name="organization" type="string"/>
      <property name="simulated" type="true_false"/>
      <property name="loggedIn" type="true_false"/> 
      <list name="roles" lazy="false" table="PL_Roles">
         <key column="playerKey"/>
         <list-index column="sort"/>
         <many-to-many column="role" class="emst.dao.player.Role"/>
      </list>
      <many-to-one name="region" class="emst.dao.region.Region" column="regionDatabaseKey"
         cascade="all" lazy="false"/>
      <property name="remotePlayer" type="true_false"/>
      <property name="skillLevel" type="integer"/>
   </class>
</hibernate-mapping>

Portion of my applicationContext.xml that configures the SessionFactory for caching:

Code:

<prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.SingletonEhCacheProvider</prop>
<prop key="hibernate.cache.provider_configuration_file_resource_path">ehcache.xml</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>

ehcache.xml

Code:

<ehcache>
  <diskStore path="user.dir"/>
  <defaultCache
      maxElementsInMemory="10000"
      eternal="false"
      overflowToDisk="false"
      timeToIdleSeconds="300"
      timeToLiveSeconds="300"
      diskPersistent="false"
      diskExpiryThreadIntervalSeconds="120"
      memoryStoreEvictionPolicy="LRU"/>
  
  <cache name="org.hibernate.cache.StandardQueryCache"
      maxElementsInMemory="100"
      eternal="false"
      timeToIdleSeconds="120"
      timeToLiveSeconds="120"
      overflowToDisk="false"/>
  
  <cache name="org.hibernate.cache.UpdateTimestampsCache"
      maxElementsInMemory="5000"
      timeToIdleSeconds="120"
      timeToLiveSeconds="120"
      eternal="true"/>
   
    <cache name="emst.dao.player.Player"
        maxElementsInMemory="500"
        eternal="true"
        overflowToDisk="false"/>
</ehcache>

Code between sessionFactory.openSession() and session.close():
I've written a test app that calls this method 300 times:

Code:

private static long getAllPlayers(PlayerDao playerDao)
{
   long taskStart, taskLength;
   taskStart = System.currentTimeMillis();
   playerDao.getAll();
   taskLength = System.currentTimeMillis() - taskStart;
   return taskLength;
}

The PlayerDao getAll method looks something like this:

Code:

public List<Player> getAll()
{
   getHibernateTemplate().setCacheQueries(true);
   DetachedCriteria criteria = DetachedCriteria.forClass(Player.class);
   return getHibernateTemplate().findByCriteria(criteria);
}

Name and version of the database you are using:
Microsoft SQL Server 2005

Each time I pull the players from the database it takes about 200 ms. I would expect the first call to take 200 ms but I'm not seeing a speed up in later calls. Any ideas what I'm doing wrong?

Top

farzad

Post subject: Re: Second level and query caches not helping!

Posted: Wed Nov 12, 2008 12:16 pm

Expert

Joined: Wed Apr 11, 2007 11:39 am
Posts: 735
Location: Montreal, QC

I can't see anything immediately wrong with this code. However, you might want to set the specific cache region for your criteria object before the execution. If this doesn't help I suggest you start validating that the configuration is picked up properly.

In addition, you could turn on sql logging and give us the output.

Farzad-

Top

EdLaFave

Post subject:

Posted: Wed Nov 12, 2008 12:20 pm

Newbie

Joined: Mon Jan 28, 2008 1:55 pm
Posts: 19

I'll look in the documentation for setting the cache region (if anybody feels generous a posted example would be appreciated). I'm not really sure how I can validate the configuration was picked up properly, any suggestions? I had SQL logging on and the Eclipse console window cut quite a bit of it out but what I do have looks like this:

[code]Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select region0_.databaseKey as database1_154_0_, region0_.locationDatabaseKey as location2_154_0_, region0_.subRegionDatabaseKey as subRegio3_154_0_ from Region region0_ where region0_.databaseKey=?
Hibernate: select region0_.databaseKey as database1_154_0_, region0_.locationDatabaseKey as location2_154_0_, region0_.subRegionDatabaseKey as subRegio3_154_0_ from Region region0_ where region0_.databaseKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1_.roleid as roleid145_0_, role1_.abbrev as abbrev145_0_, role1_.readableName as readable3_145_0_, role1_.superior as superior145_0_, role1_.counterpart as counterp5_145_0_, role1_.domain as domain145_0_, role1_.numInstances as numInsta7_145_0_ from PL_Roles roles0_ left outer join ROL_Roles role1_ on roles0_.role=role1_.roleid where roles0_.playerKey=?
Hibernate: select roles0_.playerKey as playerKey1_, roles0_.role as role1_, roles0_.sort as sort1_, role1

Top

farzad

Post subject:

Posted: Wed Nov 12, 2008 12:30 pm

Expert

Joined: Wed Apr 11, 2007 11:39 am
Posts: 735
Location: Montreal, QC

I can't see much in this log. what I'd like to see is how much more is fetched in the consecutive calls. You could also see if it is the query that is executed or the its fetching entities that happens. As for making sure your config files are picked up, make a stupid change in the files and run it. It should fail and you should see the smokes :)

Farzad-

Top

thatmikewilliams

Post subject:

Posted: Wed Nov 12, 2008 3:50 pm

Expert

Joined: Fri Jul 13, 2007 8:18 am
Posts: 370
Location: london

This might not be causing your problem but worth a look... you should ensure that the UpdateTimestampsCache timeout is set to a higher value than any query cache, as desribed here:
http://ehcache.sourceforge.net/documentation/hibernate.html

Read the UpdateTimestampsCache section...
I had problems initially because my config didn't adhere to this rule (it was lower). After adopting the recommended settings (eternal="true" and no timeout) things improved markedly.

Your value is _equal_ to the UpdateTimestampsCache so doesn't comply exactly with the docs but you're testing boundary conditions...

Another possibility is that you haven't explicitly cached the roles collection. Maybe this goes into the default cache, I'm not sure - farzad, do you have an opinion on this? However, the fact we don't see the query for the players (i.e. it _was_ cached) but see the queries for lots of roles might suggest this. Or, are there more than 10000 roles (the max size of the default cache) so the roles overflowed?

Try adding the roles collection to cache config:

Code:

    <cache name="emst.dao.player.Player.roles"
      maxElementsInMemory="500"
      maxElementsOnDisk="400"
      eternal="false"
      overflowToDisk="true"
      diskSpoolBufferSizeMB="5"
      timeToIdleSeconds="32400"
      timeToLiveSeconds="0"
      memoryStoreEvictionPolicy="LRU"
      />

...tune settings to suit your situation of course.

Top

Page 1 of 1

[ 5 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum