5 Replies Latest reply on Apr 1, 2009 3:12 PM by dsailer.d.sailer.comcast.net

JpaPermissionStore generates lots of sql requests

vincent.crepin Apr 1, 2009 12:27 AM

Hello everyone.

I used the jpaidentitystore and the jpapermissionstore as described in the documentation (Chapter 15 Security).

Everything works fine except that I noticed that there are many many sql requests that are generated. They all point to the table that contains the permissions.

When I say many, I mean that to show a list for which only 2 calls are instrumented with the annotation @Read(MyEntity.class), there are about 800 sql requests that are generated.

Anyone has experimented that ?

Thanks in advance.

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.
Actions
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.
Actions
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().
Actions
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.
Actions
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!
Actions

Go to original post