-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
chubbard
 Post subject: Native SQL Query returning my object and my joins!
PostPosted: Tue Jun 20, 2006 2:13 pm 
Beginner
Beginner

Joined: Tue Nov 29, 2005 4:42 pm
Posts: 49
Location: Atlanta, GA
I have a Native SQL Query that I'm mapping using hibernate. It works, but the return type from the list call returns a List of Object arrays that contains 3 objects: UntypedDocumentInstances, BinaryData, and Namespace. The last two are just joins to optimize the query. How do I just get the UntypedDocumentInstances? I thought that's what setEntity was for? I was trying to follow the example in the documentation.

Here is my query and code:

SQLQuery query = session.createSQLQuery( "select {di.*}, {bd.*}, {ns.*} from DocumentInstances di inner join DocumentInstances_groups dig on di.id = dig.documentInstanceID inner join BinaryData bd on di.BinaryDataID = bd.BinaryDataID inner join Namespace ns on di.NamespaceID = ns.NamespaceID where dig.GroupID=?" );

query.addEntity( "di", UntypedDocumentInstance.class );
query.addJoin( "bd", "di.binaryData" );
query.addJoin( "ns", "di.namespace" );
query.setInteger( 0, group.getId() );
return query.list();

Thanks
Charlie
Top
 Profile  
 
tenwit
 Post subject:
PostPosted: Wed Jun 21, 2006 1:26 am 
Expert
Expert

Joined: Thu Dec 23, 2004 9:08 pm
Posts: 2008
Don't use addJoin. You've already got that in your SQL statement. addJoin is supposed to do exactly what you're seeing.

_________________
Code tags are your friend. Know them and use them.

Top
 Profile  
 
chubbard
 Post subject:
PostPosted: Wed Jun 21, 2006 10:22 am 
Beginner
Beginner

Joined: Tue Nov 29, 2005 4:42 pm
Posts: 49
Location: Atlanta, GA
Well I tried that originally, and I ended up getting tons of select statements to re-constitute the relationships I had. So I'm trying to optimize the query so that I could get the columns in one select statement. Would it just be better to map the other object?

Charlie

Here is the hibernate query that's being executed.

Hibernate: select di.id as id11_0_, di.NamespaceID as Namespac5_11_0_, di.version as version11_0_, di.Enabled as Enabled11_0_, di.BinaryDataID as BinaryDa6_11_0_, di.GUID as GUID11_0_
from DocumentInstances di
inner join DocumentInstances_groups dig on di.id = dig.documentInstanceID
inner join BinaryData bd on di.BinaryDataID = bd.BinaryDataID
inner join Namespace ns on di.NamespaceID = ns.NamespaceID
where dig.GroupID=?

Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select schemaname0_.NamespaceID as Namespac1_12_0_, schemaname0_.Namespace as Namespace12_0_ from Namespace schemaname0_ where schemaname0_.NamespaceID=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Hibernate: select binarydata0_.binaryDataId as binaryDa1_10_1_, binarydata0_.fileName as fileName10_1_, binarydata0_.binaryDataType as binaryDa3_10_1_, binarydata0_.DeleteRefCount as DeleteRe4_10_1_, binarydata0_.checksum as checksum10_1_, binarydata0_.lastModifiedAt as lastModi6_10_1_, binarydata0_.LastModifiedByPrincipalID as LastModi8_10_1_, binarydata0_.value as value10_1_, user1_.PrincipalID as Principa1_5_0_, user1_.domain as domain6_0_, user1_.login as login6_0_, user1_.SID as SID6_0_, user1_.lastLogin as lastLogin6_0_, user1_.lastLoginFailure as lastLogi6_6_0_, user1_.email as email6_0_ from BinaryData binarydata0_ left outer join Users user1_ on binarydata0_.LastModifiedByPrincipalID=user1_.PrincipalID left outer join Principal user1_1_ on user1_.PrincipalID=user1_1_.PrincipalID where binarydata0_.binaryDataId=?
Top
 Profile  
 
tenwit
 Post subject:
PostPosted: Wed Jun 21, 2006 6:08 pm 
Expert
Expert

Joined: Thu Dec 23, 2004 9:08 pm
Posts: 2008
It would behoove me to read the query before replying :) Change your query to just "select {di.*} from ..." and leave in the addJoins.

Sorry about that.

_________________
Code tags are your friend. Know them and use them.

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.