Re: SQLSelect and Prefetching (cayenne 4.1)

2020-07-29 Thread Andrus Adamchik
> It can theoretically support DISJOINT_BY_ID, but IIRC it does not. Actually I was wrong about this one. DISJOINT_BY_ID works just fine with SQLSelect, and will save you a lot of trouble mapping SQL: List result = SQLSelect.query(Artist.class, "SELECT " + "#result('ARTIST_NAME' 'String'

Re: SQLSelect and Prefetching (cayenne 4.1)

2020-07-29 Thread Andrus Adamchik
Hi, We may need to make it more obvious in the API, but SQLSelect only supports JOINT prefetching [1]. It can't support disjoint, as Cayenne has no way of building the right WHERE clause for prefetch queries. It can theoretically support DISJOINT_BY_ID, but IIRC it does not. So let's focus on

Re: springboot and cayenne

2020-07-29 Thread Andrus Adamchik
Hi Tony, I haven't used Cayenne with SpringBoot for obvious reasons, but it should be no different from using it in any other env: * Create a ServerRuntime singleton * Get ObjectContext from it when you need it. Andrus > On Jul 29, 2020, at 5:33 PM, Tony Giaccone wrote: > > I see there's a c

springboot and cayenne

2020-07-29 Thread Tony Giaccone
I see there's a cayenne spring boot starter project, has anyone used this? What's the state of using Cayenne with springboot? Tony Giaccone