checked out the latest code from SVN, build and deploy
(with hypersonic database and Ehcache, show sql set to true, log statements as specified
by vivek, Non clustered server )
created 4 users, went to there dashboard, verified in db the no of dashboards created:
| select count(1) from JBP_OBJECT_NODE where PARENT_KEY = 8
| COUNT(1)
| -----------
| 4
|
Restarted the server:
login as First user, first access to dashboard, url requested (portal/auth/dashboard):
| 12:01:37,331 INFO [STDOUT] before getChild(name);===>
| 12:01:37,332 INFO [STDOUT] Hibernate: select objectnode0_.PK as PK9_,
objectnode0_."PATH" as PATH2_9_, objectnode0_.NAME as NAME9_,
objectnode0_.PARENT_KEY as PARENT4_9_ from JBP_OBJECT_NODE objectnode0_ where
objectnode0_."PATH"=?
| 12:01:37,333 INFO [STDOUT] Hibernate: select portalobje0_.PK as PK10_0_,
portalobje0_.LISTENER as LISTENER10_0_, portalobje0_4_.INSTANCE_REF as INSTANCE2_18_0_,
case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2
when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when
portalobje0_.PK is not null then 0 end as clazz_0_, declaredpr1_.OBJECT_KEY as OBJECT1_2_,
declaredpr1_.jbp_VALUE as jbp2_2_, declaredpr1_.NAME as NAME2_, modes2_.PK as PK3_,
modes2_.name as name3_, windowstat3_.PK as PK4_, windowstat3_.name as name4_ from
JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on
portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on
portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on
portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on
portalobje0_.PK=portalobje0_4_.PK left outer join JBP_PORTAL_OBJECT_PROPS declaredpr1_ on
portalobje0_.PK=declaredpr1_.OBJECT_KEY left outer join JBP_PORTAL_MODE modes2_ on
portalobje0_.PK=modes2_.PK left outer join JBP_PORTAL_WINDOW_STATE windowstat3_ on
portalobje0_.PK=windowstat3_.PK where portalobje0_.PK=?
| 12:01:37,343 INFO [STDOUT] After getChild(name);===>
|
only the select queries corresponding to requested dashboards fired.
First user, second access:
| 12:04:07,243 INFO [STDOUT] before getChild(name);===>
| 12:04:07,243 INFO [STDOUT] After getChild(name);===>
|
|
logout first user.
Login as second user:
Second user, First access
| 12:10:30,827 INFO [STDOUT] before getChild(name);===>
| 12:10:30,828 INFO [STDOUT] Hibernate: select objectnode0_.PK as PK9_,
objectnode0_."PATH" as PATH2_9_, objectnode0_.NAME as NAME9_,
objectnode0_.PARENT_KEY as PARENT4_9_ from JBP_OBJECT_NODE objectnode0_ where
objectnode0_."PATH"=?
| 12:10:30,830 INFO [STDOUT] Hibernate: select portalobje0_.PK as PK10_0_,
portalobje0_.LISTENER as LISTENER10_0_, portalobje0_4_.INSTANCE_REF as INSTANCE2_18_0_,
case when portalobje0_1_.PK is not null then 1 when portalobje0_2_.PK is not null then 2
when portalobje0_3_.PK is not null then 3 when portalobje0_4_.PK is not null then 4 when
portalobje0_.PK is not null then 0 end as clazz_0_, declaredpr1_.OBJECT_KEY as OBJECT1_2_,
declaredpr1_.jbp_VALUE as jbp2_2_, declaredpr1_.NAME as NAME2_, modes2_.PK as PK3_,
modes2_.name as name3_, windowstat3_.PK as PK4_, windowstat3_.name as name4_ from
JBP_PORTAL_OBJECT portalobje0_ left outer join JBP_CONTEXT portalobje0_1_ on
portalobje0_.PK=portalobje0_1_.PK left outer join JBP_PORTAL portalobje0_2_ on
portalobje0_.PK=portalobje0_2_.PK left outer join JBP_PAGE portalobje0_3_ on
portalobje0_.PK=portalobje0_3_.PK left outer join JBP_WINDOW portalobje0_4_ on
portalobje0_.PK=portalobje0_4_.PK left outer join JBP_PORTAL_OBJECT_PROPS declaredpr1_ on
portalobje0_.PK=declaredpr1_.OBJECT_KEY left outer join JBP_PORTAL_MODE modes2_ on
portalobje0_.PK=modes2_.PK left outer join JBP_PORTAL_WINDOW_STATE windowstat3_ on
portalobje0_.PK=windowstat3_.PK where portalobje0_.PK=?
| 12:10:30,841 INFO [STDOUT] After getChild(name);===>
|
|
Second user, Second access:
| 12:12:22,037 INFO [STDOUT] before getChild(name);===>
| 12:12:22,038 INFO [STDOUT] After getChild(name);===>
|
|
Logout second user, Login as First user again :
First access to dashboard:
| 12:13:54,833 INFO [STDOUT] session destroyed
| 12:13:54,835 INFO [STDOUT] user logout
| 12:13:54,845 INFO [STDOUT] session created
| 12:14:18,574 INFO [STDOUT] user login
| 12:14:18,583 INFO [STDOUT] before getChild(name);===>
| 12:14:18,584 INFO [STDOUT] After getChild(name);===>
|
|
Directly from cache no query fired.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4229534#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...