Hi,
I have a User , and UserGroup with ManyToMany mapping on both of them:
Code:
User.java:
@ManyToMany(mappedBy = "users")
public Set<UserGroup> getUserGroups()
{
return userGroups;
}
Code:
UserGroup.java
@ManyToMany()
@JoinTable(
name="user_group_user",
joinColumns = {@JoinColumn(name="user_group_id")},
inverseJoinColumns = {@JoinColumn(name="user_id")}
)
public Set<User> getUsers()
{
return users;
}
I have a service with transaction readOnly as false, so that the transaction flushes any delete queries before continuing.
Code:
interface SecurityService.java
@Transactional(readOnly=false)
public void deleteUsers(UserGroup group, Set<User> users);
class SecurityServiceImpl.java
public void deleteUsers(UserGroup group, Set<User> users)
{
group.getUsers().removeAll(users);
saveGroup(group);
}
The deleteUsers portion doesnot work, as it doesnot flush out the delete.
I have also implemented the equals, toString and hashCode functionality on the User and UserGroup classes.
Also I have verifed (with break point) that the
group.getUsers().removeAll(users)
actually removes all the users passed.
I dont know how to verify the rest of the information. I have enabled the log4j properties and tried to look at the debugging messages put into the log file
[code]
2009-02-10 17:37:23 DEBUG loading collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG loading collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select usergroups0_.users as users2_, usergroups0_.user_groups as user1_2_, usergroup1_.id as id4_0_, usergroup1_.created_at as created2_4_0_, usergroup1_.expiration_date as
expiration3_4_0_, usergroup1_.name as name4_0_, usergroup1_.parent_id as parent6_4_0_, usergroup1_.payment_method as payment5_4_0_, usergroup1_.simulation_id as simulation7_4_0_, usergroup2_.id as id4
_1_, usergroup2_.created_at as created2_4_1_, usergroup2_.expiration_date as expiration3_4_1_, usergroup2_.name as name4_1_, usergroup2_.parent_id as parent6_4_1_, usergroup2_.payment_method as paymen
t5_4_1_, usergroup2_.simulation_id as simulation7_4_1_ from user_group_users usergroups0_ left outer join user_group usergroup1_ on usergroups0_.user_groups=usergroup1_.id left outer join user_group u
sergroup2_ on usergroup1_.parent_id=usergroup2_.id where usergroups0_.users=?
2009-02-10 17:37:23 DEBUG select usergroups0_.users as users2_, usergroups0_.user_groups as user1_2_, usergroup1_.id as id4_0_, usergroup1_.created_at as created2_4_0_, usergroup1_.expiration_date as
expiration3_4_0_, usergroup1_.name as name4_0_, usergroup1_.parent_id as parent6_4_0_, usergroup1_.payment_method as payment5_4_0_, usergroup1_.simulation_id as simulation7_4_0_, usergroup2_.id as id4
_1_, usergroup2_.created_at as created2_4_1_, usergroup2_.expiration_date as expiration3_4_1_, usergroup2_.name as name4_1_, usergroup2_.parent_id as parent6_4_1_, usergroup2_.payment_method as paymen
t5_4_1_, usergroup2_.simulation_id as simulation7_4_1_ from user_group_users usergroups0_ left outer join user_group usergroup1_ on usergroups0_.user_groups=usergroup1_.id left outer join user_group u
sergroup2_ on usergroup1_.parent_id=usergroup2_.id where usergroups0_.users=?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result set contains (possibly empty) collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG result set contains (possibly empty) collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserGroup#1], null
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserGroup#1], null
2009-02-10 17:37:23 DEBUG found row of collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG found row of collection: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG 1 collections were found in result set for role: com.forio.broadcast.security.User.userGroups
2009-02-10 17:37:23 DEBUG 1 collections were found in result set for role: com.forio.broadcast.security.User.userGroups
2009-02-10 17:37:23 DEBUG initializing proxy: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG initializing proxy: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG loading entity: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG loading entity: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select simulation0_.id as id9_1_, simulation0_.author_id as author22_9_1_, simulation0_.created_at as created2_9_1_, simulation0_.description as descript3_9_1_, simulation0_.
arrayed as arrayed9_1_, simulation0_.based_on_simulation as based5_9_1_, simulation0_.upload_timestamp as upload6_9_1_, simulation0_.variable_count as variable7_9_1_, simulation0_.vensim_vmf as vensim
8_9_1_, simulation0_.vensim_vpm as vensim9_9_1_, simulation0_.name as name9_1_, simulation0_.path as path9_1_, simulation0_.popular as popular9_1_, simulation0_.rating as rating9_1_, simulation0_.run_
count as run14_9_1_, simulation0_.availability_permissions as availab15_9_1_, simulation0_.model_and_view_permissions as model16_9_1_, simulation0_.run_permissions as run17_9_1_, simulation0_.simulati
on_type as simulation18_9_1_, simulation0_.thumbnail_path as thumbnail19_9_1_, simulation0_.updated_at as updated20_9_1_, simulation0_.visible as visible9_1_, user1_.id as id11_0_, user1_.api_key as a
pi2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_user_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_nam
e as last8_11_0_, user1_.organization_name as organiza9_11_0_, user1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_,
user1_.updated_at as updated14_11_0_ from simulation simulation0_ inner join sys_user user1_ on simulation0_.author_id=user1_.id where simulation0_.id=?
2009-02-10 17:37:23 DEBUG select simulation0_.id as id9_1_, simulation0_.author_id as author22_9_1_, simulation0_.created_at as created2_9_1_, simulation0_.description as descript3_9_1_, simulation0_.
arrayed as arrayed9_1_, simulation0_.based_on_simulation as based5_9_1_, simulation0_.upload_timestamp as upload6_9_1_, simulation0_.variable_count as variable7_9_1_, simulation0_.vensim_vmf as vensim
8_9_1_, simulation0_.vensim_vpm as vensim9_9_1_, simulation0_.name as name9_1_, simulation0_.path as path9_1_, simulation0_.popular as popular9_1_, simulation0_.rating as rating9_1_, simulation0_.run_
count as run14_9_1_, simulation0_.availability_permissions as availab15_9_1_, simulation0_.model_and_view_permissions as model16_9_1_, simulation0_.run_permissions as run17_9_1_, simulation0_.simulati
on_type as simulation18_9_1_, simulation0_.thumbnail_path as thumbnail19_9_1_, simulation0_.updated_at as updated20_9_1_, simulation0_.visible as visible9_1_, user1_.id as id11_0_, user1_.api_key as a
pi2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_user_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_nam
e as last8_11_0_, user1_.organization_name as organiza9_11_0_, user1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_,
user1_.updated_at as updated14_11_0_ from simulation simulation0_ inner join sys_user user1_ on simulation0_.author_id=user1_.id where simulation0_.id=?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#1], EntityKey[com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#1], EntityKey[com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG done entity load
2009-02-10 17:37:23 DEBUG done entity load
2009-02-10 17:37:23 DEBUG collection fully initialized: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG collection fully initialized: [com.forio.broadcast.security.User.userGroups#2]
2009-02-10 17:37:23 DEBUG 1 collections initialized for role: com.forio.broadcast.security.User.userGroups
2009-02-10 17:37:23 DEBUG 1 collections initialized for role: com.forio.broadcast.security.User.userGroups
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG done loading collection
2009-02-10 17:37:23 DEBUG done loading collection
2009-02-10 17:37:23 DEBUG processing flush-time cascades
2009-02-10 17:37:23 DEBUG processing flush-time cascades
2009-02-10 17:37:23 DEBUG dirty checking collections
2009-02-10 17:37:23 DEBUG dirty checking collections
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.children#1], was: [com.forio.broadcast.domain.UserGroup.children#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.children#1], was: [com.forio.broadcast.domain.UserGroup.children#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.permissions#1], was: [com.forio.broadcast.domain.UserGroup.permissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.permissions#1], was: [com.forio.broadcast.domain.UserGroup.permissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.userPermissions#1], was: [com.forio.broadcast.domain.UserGroup.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.userPermissions#1], was: [com.forio.broadcast.domain.UserGroup.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.users#1], was: [com.forio.broadcast.domain.UserGroup.users#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.users#1], was: [com.forio.broadcast.domain.UserGroup.users#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#2], was: [com.forio.broadcast.security.User.simulationRatings#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#2], was: [com.forio.broadcast.security.User.simulationRatings#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#2], was: [com.forio.broadcast.security.User.userFavorites#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#2], was: [com.forio.broadcast.security.User.userFavorites#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#2], was: [com.forio.broadcast.security.User.userGroups#2] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#2], was: [com.forio.broadcast.security.User.userGroups#2] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#2], was: [com.forio.broadcast.security.User.userPermissions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#2], was: [com.forio.broadcast.security.User.userPermissions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#2], was: [com.forio.broadcast.security.User.userSubscriptions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#2], was: [com.forio.broadcast.security.User.userSubscriptions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#1], was: [com.forio.broadcast.security.User.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#1], was: [com.forio.broadcast.security.User.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#1], was: [com.forio.broadcast.security.User.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#1], was: [com.forio.broadcast.security.User.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#1], was: [com.forio.broadcast.security.User.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#1], was: [com.forio.broadcast.security.User.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#1], was: [com.forio.broadcast.security.User.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#1], was: [com.forio.broadcast.security.User.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#1], was: [com.forio.broadcast.security.User.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#1], was: [com.forio.broadcast.security.User.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.products#1], was: [com.forio.broadcast.domain.Simulation.products#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.products#1], was: [com.forio.broadcast.domain.Simulation.products#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.runArchives#1], was: [com.forio.broadcast.domain.Simulation.runArchives#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.runArchives#1], was: [com.forio.broadcast.domain.Simulation.runArchives#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationRatings#1], was: [com.forio.broadcast.domain.Simulation.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationRatings#1], was: [com.forio.broadcast.domain.Simulation.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationTags#1], was: [com.forio.broadcast.domain.Simulation.simulationTags#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationTags#1], was: [com.forio.broadcast.domain.Simulation.simulationTags#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userFavorites#1], was: [com.forio.broadcast.domain.Simulation.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userFavorites#1], was: [com.forio.broadcast.domain.Simulation.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userGroups#1], was: [com.forio.broadcast.domain.Simulation.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userGroups#1], was: [com.forio.broadcast.domain.Simulation.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userSubscriptions#1], was: [com.forio.broadcast.domain.Simulation.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userSubscriptions#1], was: [com.forio.broadcast.domain.Simulation.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Flushed: 0 insertions, 1 updates, 0 deletions to 4 objects
2009-02-10 17:37:23 DEBUG Flushed: 0 insertions, 1 updates, 0 deletions to 4 objects
2009-02-10 17:37:23 DEBUG Flushed: 0 (re)creations, 0 updates, 0 removals to 21 collections
2009-02-10 17:37:23 DEBUG Flushed: 0 (re)creations, 0 updates, 0 removals to 21 collections
2009-02-10 17:37:23 DEBUG listing entities:
2009-02-10 17:37:23 DEBUG listing entities:
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.Simulation{visible=false, thumbnailPath=null, simulationRatings=<uninitialized>, modelDetail=component[arrayed,basedOnSimulation,uploadTimestamp,va
riableCount,vensimVmf,vensimVpm]{vensimVpm=false, basedOnSimulation=null, vensimVmf=false, variableCount=0, uploadTimestamp=0, arrayed=false}, securityModel=component[availabilityPermissions,modelAndV
iewPermissions,runPermissions]{runPermissions=NOT_SUBSCRIBE, modelAndViewPermissions=VIEW_MODEL_AND_INTERFACE_SOURCE, availabilityPermissions=PUBLIC}, userFavorites=<uninitialized>, userSubscriptions=
<uninitialized>, updatedAt=2009-02-10 17:36:18, id=1, simulationTags=<uninitialized>, author=com.forio.broadcast.security.User#1, runCount=0, userGroups=<uninitialized>, createdAt=2009-02-10 17:36:10,
description=, runArchives=<uninitialized>, simulationType=1, name=test, popular=false, path=test, rating=0.0, products=<uninitialized>}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.Simulation{visible=false, thumbnailPath=null, simulationRatings=<uninitialized>, modelDetail=component[arrayed,basedOnSimulation,uploadTimestamp,va
riableCount,vensimVmf,vensimVpm]{vensimVpm=false, basedOnSimulation=null, vensimVmf=false, variableCount=0, uploadTimestamp=0, arrayed=false}, securityModel=component[availabilityPermissions,modelAndV
iewPermissions,runPermissions]{runPermissions=NOT_SUBSCRIBE, modelAndViewPermissions=VIEW_MODEL_AND_INTERFACE_SOURCE, availabilityPermissions=PUBLIC}, userFavorites=<uninitialized>, userSubscriptions=
<uninitialized>, updatedAt=2009-02-10 17:36:18, id=1, simulationTags=<uninitialized>, author=com.forio.broadcast.security.User#1, runCount=0, userGroups=<uninitialized>, createdAt=2009-02-10 17:36:10,
description=, runArchives=<uninitialized>, simulationType=1, name=test, popular=false, path=test, rating=0.0, products=<uninitialized>}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER, cbUserId=null, joined
At=2009-02-10 17:36:42, userFavorites=<uninitialized>, password=test, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:37:23, id=2, timeZoneString=null, userGroups=[], email=tes
t@forio.com, userPermissions=<uninitialized>, path=test@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER, cbUserId=null, joined
At=2009-02-10 17:36:42, userFavorites=<uninitialized>, password=test, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:37:23, id=2, timeZoneString=null, userGroups=[], email=tes
t@forio.com, userPermissions=<uninitialized>, path=test@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER SIM_AUTHOR.1, cbUserId
=null, joinedAt=2009-02-10 17:36:01, userFavorites=<uninitialized>, password=6502Apple, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:36:10, id=1, timeZoneString=null, userGr
oups=<uninitialized>, email=info@forio.com, userPermissions=<uninitialized>, path=info@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER SIM_AUTHOR.1, cbUserId
=null, joinedAt=2009-02-10 17:36:01, userFavorites=<uninitialized>, password=6502Apple, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:36:10, id=1, timeZoneString=null, userGr
oups=<uninitialized>, email=info@forio.com, userPermissions=<uninitialized>, path=info@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserGroup{id=1, users=[], expirationDate=null, userPermissions=<uninitialized>, createdAt=null, name=SIMULATION_ROOT, permissions=<uninitialized>,
parent=null, children=[], simulation=com.forio.broadcast.domain.Simulation#1, paymentMethod=null}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserGroup{id=1, users=[], expirationDate=null, userPermissions=<uninitialized>, createdAt=null, name=SIMULATION_ROOT, permissions=<uninitialized>,
parent=null, children=[], simulation=com.forio.broadcast.domain.Simulation#1, paymentMethod=null}
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select userpermis0_.id as id2_, userpermis0_.permission as permission2_, userpermis0_.user as user2_, userpermis0_.user_group as user4_2_ from user_permission userpermis0_ wh
ere userpermis0_.user_group=? and userpermis0_.user=? limit ?
2009-02-10 17:37:23 DEBUG select userpermis0_.id as id2_, userpermis0_.permission as permission2_, userpermis0_.user as user2_, userpermis0_.user_group as user4_2_ from user_permission userpermis0_ wh
ere userpermis0_.user_group=? and userpermis0_.user=? limit ?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.UserPermission#1]
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG processing flush-time cascades
2009-02-10 17:37:23 DEBUG processing flush-time cascades
2009-02-10 17:37:23 DEBUG dirty checking collections
2009-02-10 17:37:23 DEBUG dirty checking collections
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.children#1], was: [com.forio.broadcast.domain.UserGroup.children#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.children#1], was: [com.forio.broadcast.domain.UserGroup.children#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.permissions#1], was: [com.forio.broadcast.domain.UserGroup.permissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.permissions#1], was: [com.forio.broadcast.domain.UserGroup.permissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.userPermissions#1], was: [com.forio.broadcast.domain.UserGroup.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.userPermissions#1], was: [com.forio.broadcast.domain.UserGroup.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.users#1], was: [com.forio.broadcast.domain.UserGroup.users#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.UserGroup.users#1], was: [com.forio.broadcast.domain.UserGroup.users#1] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#2], was: [com.forio.broadcast.security.User.simulationRatings#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#2], was: [com.forio.broadcast.security.User.simulationRatings#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#2], was: [com.forio.broadcast.security.User.userFavorites#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#2], was: [com.forio.broadcast.security.User.userFavorites#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#2], was: [com.forio.broadcast.security.User.userGroups#2] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#2], was: [com.forio.broadcast.security.User.userGroups#2] (initialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#2], was: [com.forio.broadcast.security.User.userPermissions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#2], was: [com.forio.broadcast.security.User.userPermissions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#2], was: [com.forio.broadcast.security.User.userSubscriptions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#2], was: [com.forio.broadcast.security.User.userSubscriptions#2] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#1], was: [com.forio.broadcast.security.User.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.simulationRatings#1], was: [com.forio.broadcast.security.User.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#1], was: [com.forio.broadcast.security.User.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userFavorites#1], was: [com.forio.broadcast.security.User.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#1], was: [com.forio.broadcast.security.User.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userGroups#1], was: [com.forio.broadcast.security.User.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#1], was: [com.forio.broadcast.security.User.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userPermissions#1], was: [com.forio.broadcast.security.User.userPermissions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#1], was: [com.forio.broadcast.security.User.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.security.User.userSubscriptions#1], was: [com.forio.broadcast.security.User.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.products#1], was: [com.forio.broadcast.domain.Simulation.products#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.products#1], was: [com.forio.broadcast.domain.Simulation.products#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.runArchives#1], was: [com.forio.broadcast.domain.Simulation.runArchives#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.runArchives#1], was: [com.forio.broadcast.domain.Simulation.runArchives#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationRatings#1], was: [com.forio.broadcast.domain.Simulation.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationRatings#1], was: [com.forio.broadcast.domain.Simulation.simulationRatings#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationTags#1], was: [com.forio.broadcast.domain.Simulation.simulationTags#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.simulationTags#1], was: [com.forio.broadcast.domain.Simulation.simulationTags#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userFavorites#1], was: [com.forio.broadcast.domain.Simulation.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userFavorites#1], was: [com.forio.broadcast.domain.Simulation.userFavorites#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userGroups#1], was: [com.forio.broadcast.domain.Simulation.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userGroups#1], was: [com.forio.broadcast.domain.Simulation.userGroups#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userSubscriptions#1], was: [com.forio.broadcast.domain.Simulation.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Collection found: [com.forio.broadcast.domain.Simulation.userSubscriptions#1], was: [com.forio.broadcast.domain.Simulation.userSubscriptions#1] (uninitialized)
2009-02-10 17:37:23 DEBUG Flushed: 0 insertions, 1 updates, 1 deletions to 5 objects
2009-02-10 17:37:23 DEBUG Flushed: 0 insertions, 1 updates, 1 deletions to 5 objects
2009-02-10 17:37:23 DEBUG Flushed: 0 (re)creations, 0 updates, 0 removals to 21 collections
2009-02-10 17:37:23 DEBUG Flushed: 0 (re)creations, 0 updates, 0 removals to 21 collections
2009-02-10 17:37:23 DEBUG listing entities:
2009-02-10 17:37:23 DEBUG listing entities:
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.Simulation{visible=false, thumbnailPath=null, simulationRatings=<uninitialized>, modelDetail=component[arrayed,basedOnSimulation,uploadTimestamp,va
riableCount,vensimVmf,vensimVpm]{vensimVpm=false, basedOnSimulation=null, vensimVmf=false, variableCount=0, uploadTimestamp=0, arrayed=false}, securityModel=component[availabilityPermissions,modelAndV
iewPermissions,runPermissions]{runPermissions=NOT_SUBSCRIBE, modelAndViewPermissions=VIEW_MODEL_AND_INTERFACE_SOURCE, availabilityPermissions=PUBLIC}, userFavorites=<uninitialized>, userSubscriptions=
<uninitialized>, updatedAt=2009-02-10 17:36:18, id=1, simulationTags=<uninitialized>, author=com.forio.broadcast.security.User#1, runCount=0, userGroups=<uninitialized>, createdAt=2009-02-10 17:36:10,
description=, runArchives=<uninitialized>, simulationType=1, name=test, popular=false, path=test, rating=0.0, products=<uninitialized>}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.Simulation{visible=false, thumbnailPath=null, simulationRatings=<uninitialized>, modelDetail=component[arrayed,basedOnSimulation,uploadTimestamp,va
riableCount,vensimVmf,vensimVpm]{vensimVpm=false, basedOnSimulation=null, vensimVmf=false, variableCount=0, uploadTimestamp=0, arrayed=false}, securityModel=component[availabilityPermissions,modelAndV
iewPermissions,runPermissions]{runPermissions=NOT_SUBSCRIBE, modelAndViewPermissions=VIEW_MODEL_AND_INTERFACE_SOURCE, availabilityPermissions=PUBLIC}, userFavorites=<uninitialized>, userSubscriptions=
<uninitialized>, updatedAt=2009-02-10 17:36:18, id=1, simulationTags=<uninitialized>, author=com.forio.broadcast.security.User#1, runCount=0, userGroups=<uninitialized>, createdAt=2009-02-10 17:36:10,
description=, runArchives=<uninitialized>, simulationType=1, name=test, popular=false, path=test, rating=0.0, products=<uninitialized>}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER, cbUserId=null, joined
At=2009-02-10 17:36:42, userFavorites=<uninitialized>, password=test, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:37:23, id=2, timeZoneString=null, userGroups=[], email=tes
t@forio.com, userPermissions=<uninitialized>, path=test@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER, cbUserId=null, joined
At=2009-02-10 17:36:42, userFavorites=<uninitialized>, password=test, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:37:23, id=2, timeZoneString=null, userGroups=[], email=tes
t@forio.com, userPermissions=<uninitialized>, path=test@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER SIM_AUTHOR.1, cbUserId
=null, joinedAt=2009-02-10 17:36:01, userFavorites=<uninitialized>, password=6502Apple, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:36:10, id=1, timeZoneString=null, userGr
oups=<uninitialized>, email=info@forio.com, userPermissions=<uninitialized>, path=info@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.security.User{lastName=test, thumbnailPath=null, organizationName=test, simulationRatings=<uninitialized>, authorityNames=ROLE_USER SIM_AUTHOR.1, cbUserId
=null, joinedAt=2009-02-10 17:36:01, userFavorites=<uninitialized>, password=6502Apple, apiKey=null, userSubscriptions=<uninitialized>, updatedAt=2009-02-10 17:36:10, id=1, timeZoneString=null, userGr
oups=<uninitialized>, email=info@forio.com, userPermissions=<uninitialized>, path=info@forio.com, firstName=test}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserGroup{id=1, users=[], expirationDate=null, userPermissions=<uninitialized>, createdAt=null, name=SIMULATION_ROOT, permissions=<uninitialized>,
parent=null, children=[], simulation=com.forio.broadcast.domain.Simulation#1, paymentMethod=null}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserGroup{id=1, users=[], expirationDate=null, userPermissions=<uninitialized>, createdAt=null, name=SIMULATION_ROOT, permissions=<uninitialized>,
parent=null, children=[], simulation=com.forio.broadcast.domain.Simulation#1, paymentMethod=null}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserPermission{id=1, userGroup=com.forio.broadcast.domain.UserGroup#1, permission=USER, user=com.forio.broadcast.security.User#2}
2009-02-10 17:37:23 DEBUG com.forio.broadcast.domain.UserPermission{id=1, userGroup=com.forio.broadcast.domain.UserGroup#1, permission=USER, user=com.forio.broadcast.security.User#2}
2009-02-10 17:37:23 DEBUG Pre-invalidating space [sys_user]
2009-02-10 17:37:23 DEBUG Pre-invalidating space [sys_user]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG update sys_user set api_key=?, authority_names=?, cb_user_id=?, email=?, first_name=?, joined_at=?, last_name=?, organization_name=?, password=?, path=?, thumbnail_path=?, ti
me_zone=?, updated_at=? where id=?
2009-02-10 17:37:23 DEBUG update sys_user set api_key=?, authority_names=?, cb_user_id=?, email=?, first_name=?, joined_at=?, last_name=?, organization_name=?, password=?, path=?, thumbnail_path=?, ti
me_zone=?, updated_at=? where id=?
2009-02-10 17:37:23 DEBUG Executing batch size: 1
2009-02-10 17:37:23 DEBUG Executing batch size: 1
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG Pre-invalidating space [user_permission]
2009-02-10 17:37:23 DEBUG Pre-invalidating space [user_permission]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG delete from user_permission where id=?
2009-02-10 17:37:23 DEBUG delete from user_permission where id=?
2009-02-10 17:37:23 DEBUG Executing batch size: 1
2009-02-10 17:37:23 DEBUG Executing batch size: 1
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG Invalidating space [sys_user], timestamp: 5055759334989824
2009-02-10 17:37:23 DEBUG Invalidating space [sys_user], timestamp: 5055759334989824
2009-02-10 17:37:23 DEBUG Invalidating space [user_permission], timestamp: 5055759334989825
2009-02-10 17:37:23 DEBUG Invalidating space [user_permission], timestamp: 5055759334989825
2009-02-10 17:37:23 DEBUG opened session at timestamp: 5055759335034880
2009-02-10 17:37:23 DEBUG opened session at timestamp: 5055759335034880
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG loading entity: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG loading entity: [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select simulation0_.id as id9_1_, simulation0_.author_id as author22_9_1_, simulation0_.created_at as created2_9_1_, simulation0_.description as descript3_9_1_, simulation0_.
arrayed as arrayed9_1_, simulation0_.based_on_simulation as based5_9_1_, simulation0_.upload_timestamp as upload6_9_1_, simulation0_.variable_count as variable7_9_1_, simulation0_.vensim_vmf as vensim
8_9_1_, simulation0_.vensim_vpm as vensim9_9_1_, simulation0_.name as name9_1_, simulation0_.path as path9_1_, simulation0_.popular as popular9_1_, simulation0_.rating as rating9_1_, simulation0_.run_
count as run14_9_1_, simulation0_.availability_permissions as availab15_9_1_, simulation0_.model_and_view_permissions as model16_9_1_, simulation0_.run_permissions as run17_9_1_, simulation0_.simulati
on_type as simulation18_9_1_, simulation0_.thumbnail_path as thumbnail19_9_1_, simulation0_.updated_at as updated20_9_1_, simulation0_.visible as visible9_1_, user1_.id as id11_0_, user1_.api_key as a
pi2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_user_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_nam
e as last8_11_0_, user1_.organization_name as organiza9_11_0_, user1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_,
user1_.updated_at as updated14_11_0_ from simulation simulation0_ inner join sys_user user1_ on simulation0_.author_id=user1_.id where simulation0_.id=?
2009-02-10 17:37:23 DEBUG select simulation0_.id as id9_1_, simulation0_.author_id as author22_9_1_, simulation0_.created_at as created2_9_1_, simulation0_.description as descript3_9_1_, simulation0_.
arrayed as arrayed9_1_, simulation0_.based_on_simulation as based5_9_1_, simulation0_.upload_timestamp as upload6_9_1_, simulation0_.variable_count as variable7_9_1_, simulation0_.vensim_vmf as vensim
8_9_1_, simulation0_.vensim_vpm as vensim9_9_1_, simulation0_.name as name9_1_, simulation0_.path as path9_1_, simulation0_.popular as popular9_1_, simulation0_.rating as rating9_1_, simulation0_.run_
count as run14_9_1_, simulation0_.availability_permissions as availab15_9_1_, simulation0_.model_and_view_permissions as model16_9_1_, simulation0_.run_permissions as run17_9_1_, simulation0_.simulati
on_type as simulation18_9_1_, simulation0_.thumbnail_path as thumbnail19_9_1_, simulation0_.updated_at as updated20_9_1_, simulation0_.visible as visible9_1_, user1_.id as id11_0_, user1_.api_key as a
pi2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_user_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_nam
e as last8_11_0_, user1_.organization_name as organiza9_11_0_, user1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_,
user1_.updated_at as updated14_11_0_ from simulation simulation0_ inner join sys_user user1_ on simulation0_.author_id=user1_.id where simulation0_.id=?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#1], EntityKey[com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#1], EntityKey[com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.security.User#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.Simulation#1]
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG done entity load
2009-02-10 17:37:23 DEBUG done entity load
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select usergroup0_.id as id4_, usergroup0_.created_at as created2_4_, usergroup0_.expiration_date as expiration3_4_, usergroup0_.name as name4_, usergroup0_.parent_id as pare
nt6_4_, usergroup0_.payment_method as payment5_4_, usergroup0_.simulation_id as simulation7_4_ from user_group usergroup0_ where usergroup0_.simulation_id=? and (usergroup0_.parent_id is null) limit ?
2009-02-10 17:37:23 DEBUG select usergroup0_.id as id4_, usergroup0_.created_at as created2_4_, usergroup0_.expiration_date as expiration3_4_, usergroup0_.name as name4_, usergroup0_.parent_id as pare
nt6_4_, usergroup0_.payment_method as payment5_4_, usergroup0_.simulation_id as simulation7_4_ from user_group usergroup0_ where usergroup0_.simulation_id=? and (usergroup0_.parent_id is null) limit ?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG resolving associations for [com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG done materializing entity [com.forio.broadcast.domain.UserGroup#1]
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG begin
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG current autocommit status: true
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG disabling autocommit
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG select usergroup0_.id as id4_, usergroup0_.created_at as created2_4_, usergroup0_.expiration_date as expiration3_4_, usergroup0_.name as name4_, usergroup0_.parent_id as pare
nt6_4_, usergroup0_.payment_method as payment5_4_, usergroup0_.simulation_id as simulation7_4_ from user_group usergroup0_ where usergroup0_.parent_id=?
2009-02-10 17:37:23 DEBUG select usergroup0_.id as id4_, usergroup0_.created_at as created2_4_, usergroup0_.expiration_date as expiration3_4_, usergroup0_.name as name4_, usergroup0_.parent_id as pare
nt6_4_, usergroup0_.payment_method as payment5_4_, usergroup0_.simulation_id as simulation7_4_ from user_group usergroup0_ where usergroup0_.parent_id=?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close ResultSet (open ResultSets: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG initializing non-lazy collections
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG commit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG re-enabling autocommit
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG committed JDBC Connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG aggressively releasing JDBC connection
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-02-10 17:37:23 DEBUG loading collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG loading collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG opening JDBC connection
2009-02-10 17:37:23 DEBUG select users0_.user_groups as user1_1_, users0_.users as users1_, user1_.id as id11_0_, user1_.api_key as api2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_us
er_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_name as last8_11_0_, user1_.organization_name as organiza9_11_0_, user
1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_, user1_.updated_at as updated14_11_0_ from user_group_users users0_
left outer join sys_user user1_ on users0_.users=user1_.id where users0_.user_groups=?
2009-02-10 17:37:23 DEBUG select users0_.user_groups as user1_1_, users0_.users as users1_, user1_.id as id11_0_, user1_.api_key as api2_11_0_, user1_.authority_names as authority3_11_0_, user1_.cb_us
er_id as cb4_11_0_, user1_.email as email11_0_, user1_.first_name as first6_11_0_, user1_.joined_at as joined7_11_0_, user1_.last_name as last8_11_0_, user1_.organization_name as organiza9_11_0_, user
1_.password as password11_0_, user1_.path as path11_0_, user1_.thumbnail_path as thumbnail12_11_0_, user1_.time_zone as time13_11_0_, user1_.updated_at as updated14_11_0_ from user_group_users users0_
left outer join sys_user user1_ on users0_.users=user1_.id where users0_.user_groups=?
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG about to open ResultSet (open ResultSets: 0, globally: 0)
2009-02-10 17:37:23 DEBUG result set contains (possibly empty) collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG result set contains (possibly empty) collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#2]
2009-02-10 17:37:23 DEBUG result row: EntityKey[com.forio.broadcast.security.User#2]
2009-02-10 17:37:23 DEBUG found row of collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG found row of collection: [com.forio.broadcast.domain.UserGroup.users#1]
2009-02-10 17:37:23 DEBUG about to close ResultSet (op