Re: cayenne 3.1 B3 dependencies missing commons-lang-2.6

2013-12-17 Thread Andrus Adamchik
Cayenne does not have commons-lang dependency. I think it is a dependency of Velocity. Velocity 1.6.3 depends on commons-lang 2.4 (and also oro 2.0.8 - why in the world people would still use oro?) So commons-lang will be needed if you are running SQLTemplate and EJBQL queries (that are using V

Re: cayenne performance tuning issues

2013-12-17 Thread Aristedes Maniatis
Prefetching is not supposed to change the records that you return from the query in the primary table. Which is why a left join is appropriate. An inner join would suppress records in the primary table without a relation to the second table. That might be what you want, but that isn't the point

Re: cayenne performance tuning issues

2013-12-17 Thread Michael Hatch
I did testing with default prefetching disjoint joint semantics and joint prefetching. As you stated, disjoint sends multiple SQL requests. I'm not sure which scenario that would be preferred. Joint semantics seems to create left joins, although I'd want inner joins. Is there an option to prefetch

Re: cayenne performance tuning issues

2013-12-17 Thread Aristedes Maniatis
On 18/12/2013 4:29am, Michael Hatch wrote: > The first sql statement is fetching the user info, while the second sql is > for inflating the roles relationship. I understand the documentation > explicitly states that prefetching will inflate relationships for you, but > it still does so via multipl

Re: cayenne 3.1 B3 dependencies missing commons-lang-2.6

2013-12-17 Thread Mike Kienenberger
This was on the windows distribution. I haven't checked the other ones. On Tue, Dec 17, 2013 at 10:07 PM, Mike Kienenberger wrote: > We state: > > = > > When using cayenne-server-x.x.jar you'll need a few third party jars > (all included in lib/third-party directory of the distributi

cayenne 3.1 B3 dependencies missing commons-lang-2.6

2013-12-17 Thread Mike Kienenberger
We state: = When using cayenne-server-x.x.jar you'll need a few third party jars (all included in lib/third-party directory of the distribution): Apache Velocity Template Engine, version 1.6.x (and all its dependencies bundled with velocity-dep) Apache Commons Collections, version 3

Re: cayenne performance tuning issues

2013-12-17 Thread Mike Kienenberger
What you're showing here in the log doesn't seem to have anything to do with Cayenne peformance problems. 2013-12-16 23:17:52,338 [http-bio-8080-exec-10] INFO SELECT [...t0.*...] FROM EDU_SEC.dbo.APP_USER t0 WHERE ((t0.PWD = ?) OR (t0.PWD = ?)) AND (t0.UID = ?) [bind: 1->PWD:'REDACTED', 2->PWD

cayenne performance tuning issues

2013-12-17 Thread Michael Hatch
I was asked to provide further details of the performance issues I'm facing. I have a simple grails app that logs a user into the app (with valid role permissions) and performs simple CRUD operations on object entities. The below output is the login sql generated during the login attempt. I am fetc