[EL Finer]: connection: 2013-01-23 11:13:30.539--ServerSession(945282069)--Thread(Thread[Worker-3,5,main])--client acquired: 1651928704
[EL Finer]: transaction: 2013-01-23 11:13:30.539--ClientSession(1651928704)--Thread(Thread[Worker-3,5,main])--acquire unit of work: 1297139712
[EL Finest]: query: 2013-01-23 11:13:30.54--ClientSession(1651928704)--Thread(Thread[Worker-3,5,main])--Execute query ReadAllQuery(name="loadGroupMembershipWithProfileId" referenceClass=GroupMembershipProfile sql="SELECT t1.ID, t1.GROUPITEM_ID, t1.PROFILE_ID, t0.ID, t0.DELETABLE, t0.KEYNAME, t0.KEYNAMEPREFIX FROM GROUP_ITEM t0, GROUP_PROFILE t1 WHERE ((t1.PROFILE_ID = ?) AND (t0.ID = t1.GROUPITEM_ID))")
[EL Finest]: connection: 2013-01-23 11:13:30.54--ServerSession(945282069)--Connection(1920638887)--Thread(Thread[Worker-3,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2013-01-23 11:13:30.54--ServerSession(945282069)--Thread(Thread[Worker-3,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2013-01-23 11:13:30.546--ServerSession(945282069)--Connection(1992025295)--Thread(Thread[Worker-3,5,main])--SELECT t1.ID, t1.GROUPITEM_ID, t1.PROFILE_ID, t0.ID, t0.DELETABLE, t0.KEYNAME, t0.KEYNAMEPREFIX FROM GROUP_ITEM t0, GROUP_PROFILE t1 WHERE ((t1.PROFILE_ID = ?) AND (t0.ID = t1.GROUPITEM_ID))
bind => [2]
[EL Finest]: connection: 2013-01-23 11:13:30.547--ServerSession(945282069)--Connection(1920638887)--Thread(Thread[Worker-3,5,main])--Connection released to connection pool [read].
[EL Finest]: query: 2013-01-23 11:13:30.548--ServerSession(945282069)--Thread(Thread[Worker-3,5,main])--Execute query ReadObjectQuery(name="profile" referenceClass=Profile )
[EL Finer]: transaction: 2013-01-23 11:13:30.548--UnitOfWork(1297139712)--Thread(Thread[Worker-3,5,main])--begin unit of work commit
[EL Finer]: transaction: 2013-01-23 11:13:30.548--UnitOfWork(1297139712)--Thread(Thread[Worker-3,5,main])--end unit of work commit
[EL Finer]: transaction: 2013-01-23 11:13:30.548--UnitOfWork(1297139712)--Thread(Thread[Worker-3,5,main])--resume unit of work
@Entity
@Table(name = "GROUP_PROFILE")
@NamedQueries({
@NamedQuery(name = "loadGroupMembershipWithProfileId", query = "SELECT gmp FROM GroupMembershipProfile gmp WHERE gmp.profile.id=:profileId"),
@NamedQuery(name = "loadGroupMembershipWithGroupId", query = "SELECT gmp FROM GroupMembershipProfile gmp WHERE gmp.groupItem.id=:groupId"),
@NamedQuery(name = "deleteAllGroupMembershipByProfileId", query = "DELETE FROM GroupMembershipProfile a WHERE a.profile.id=:profileId")
})
public class GroupMembershipProfile extends DataObject{
@ManyToOne(cascade = { REFRESH, MERGE }, fetch = EAGER)
@JoinColumn(name="GROUPITEM_ID")
@JoinFetch(INNER)
private GroupItem groupItem;
...
}
@Entity
@Table(name = "GROUP_ITEM")
@NamedQueries({
@NamedQuery(name = "loadAllGroupsWithPrefix", query = "SELECT a FROM GroupItem a WHERE a.keyNamePrefix=:prefix"),
@NamedQuery(name = "findGroupItemByKey", query = "SELECT a FROM GroupItem a WHERE a.keyName=:key")
})
public class GroupItem extends AbstractKeyItem<GroupNameML> implements IKeyItem{
@OneToMany(fetch = EAGER, cascade = ALL)
@MapKey(name="languageCode")
@PrivateOwned
@JoinColumn(name="OWNER_ID", referencedColumnName="ID")
@JoinFetch(INNER)
private Map<String, GroupNameML> dictionaryItem = new HashMap<String, GroupNameML>();
...
}
]]>