-->
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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Many-to-Many mapping on Set dosnot remove the elements
PostPosted: Tue Feb 10, 2009 10:04 pm 
Newbie

Joined: Tue Feb 10, 2009 9:48 pm
Posts: 1
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

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.