-
1. Re: JpaPermissionStore generates lots of sql requests
dsailer.d.sailer.comcast.net Apr 1, 2009 7:01 AM (in response to vincent.crepin)I'm trying to get jpapermissionstore to work myself. I do not see an abnormal number of queries to my permissions table. I'm curious how you got your permissions to work though. Can you take a peak at http://www.seamframework.org/Community/LazyInitializationExceptionJpaIdentityStore
and see what you think? Maybe we can work together and get it all working :). I'm happy to share what I have but it's really pretty close to what examples/seamspace has except I'm not using drools at all.
-
2. Re: JpaPermissionStore generates lots of sql requests
vincent.crepin Apr 1, 2009 1:30 PM (in response to vincent.crepin)Ok, I'll have a look and come back to you.
Thanks for responding.
-
3. Re: JpaPermissionStore generates lots of sql requests
dsailer.d.sailer.comcast.net Apr 1, 2009 2:26 PM (in response to vincent.crepin)Try debugging with a break-point in org.jboss.seam.security.permission.JpaPermissionStore.listPermissions().
-
4. Re: JpaPermissionStore generates lots of sql requests
vincent.crepin Apr 1, 2009 3:04 PM (in response to vincent.crepin)I found my problem. In my list, there was a column that had rendered with a check to 3 permissions.
I don't know how this could generate 800 requests (there are only 12 items shown in my list) but it did.
So I replaced the call to a call on my controller bean which caches the result and everything is ok.
Ok, now I will look at the other post.
-
5. Re: JpaPermissionStore generates lots of sql requests
dsailer.d.sailer.comcast.net Apr 1, 2009 3:12 PM (in response to vincent.crepin)ah, sweet progress!