SQLTemplate returning NULL results

Hello everybody, I am getting lost in trying to use an SQLTemplate query. I have tried to reduce the problem to the core, and this is the point where I am stuck. The following two lines of code do what I was expecting them to do: Query query = new SelectQuery(SaleSummary.class); List sale

Re: SQLTemplate returning NULL results

throw an Exception or something. > > Andrus > > > On May 28, 2013, at 9:52 AM, giulio.ces...@gmail.com wrote: > > > Hello everybody, > > > > I am getting lost in trying to use an SQLTemplate query. > > > > I have tried to reduce the problem to the core, a

Re: SQLTemplate returning NULL results

; On May 28, 2013, at 3:44 PM, giulio.ces...@gmail.com wrote: > > > Hello Andrus, > > > > unfortunately your suggestion didn't help. I am now trying to build my > > project using Cayenne code base from repository Head, to see if I can > spot > > what is goi

Re: SQLTemplate returning NULL results

Jurgen, thanks for the tip; but I am either completely blind (as I can see no differences in the query compared to the structure of the DB), or there is something else going on in my case. As stated in the initial message, I have also tried using the same exact SQL statement logged by Cayenne whe

Re: SQLTemplate returning NULL results

three results; it looks like SQLTemplateMetadata is accessing query.result before the query is actually executed. Does this analysis make any sense? Regards, Giulio Cesare On Tue, May 28, 2013 at 4:22 PM, giulio.ces...@gmail.com < giulio.ces...@gmail.com> wrote: > Jurgen, > > thank

Re: SQLTemplate returning NULL results

is where we should throw an exception IMO). > > That is if I am correct about the flow in your case :) > > Andrus > > > On May 28, 2013, at 5:35 PM, giulio.ces...@gmail.com wrote: > > > Hello Andrus, > > > > I have dug through the code, and I

Re: SQLTemplate returning NULL results

with > the > > `root` class specified when creating the new SQLTemplate instance. > > DataDomainQueryAction.interceptObjectConversion(..) > > On May 29, 2013, at 2:33 AM, giulio.ces...@gmail.com wrote: > > > Andrus, > > > > I have looked closer into RowDescript

Re: SQLTemplate returning NULL results

dable and precludes > "SELECT *". > > A. > > On May 29, 2013, at 12:01 PM, giulio.ces...@gmail.com wrote: > > Andrus, > > > > I have managed to sort out what was the problem: in my model I have > Primary > > Keys of DBEntities defined using camelCa

Re: [ANN] Cayenne 3.1 final release

Congratulations to all developers involved! I am not a big fan of DI myself, but I will look into this new release and check how to update my project to use it. Cheers, Giulio Cesare On Tue, Sep 30, 2014 at 12:31 PM, Andrus Adamchik wrote: > Hi everyone! > > I am glad to report on 3.1 releas

ObjectSelect to select uncommitted objects

Hello, I have multiple places where I have to search data either on the current ObjectStore (newly inserted or modified objects) or directly in the DB. At the moment I have two distinct blocks of code, one expressed as a Predicate (used inside a stream filter) and the other with an ObjectSelect (

Re: ObjectSelect to select uncommitted objects

*return* (List) results; > > } > > > *public* *static* *class* Factory *extends* DataContextFactory { > > @Override > > *protected* MyDataContext newInstance(DataChannel parent, ObjectStore > objectStore) { > > *return* *new* MyDataContext(parent, objectStore); > >

Ordering objects by primary keys

Hello, I am try to run some BBD tests integrated with Cayenne (succesfully, so far). I am at the point where I can not fully specify the record/object to select in the test script, and so I am trying to select the latest object inserted, matching some lose criteria. Unfortunately, I don't have a

Re: Ordering objects by primary keys

It did work! 🤩 Thanks Nikita. 🙏 Cheers, Giulio Cesare On Wed, Oct 27, 2021 at 7:46 PM Nikita Timofeev wrote: > Hi! > > You could try to add "db:" prefix to the primary key name. > Something like this: orderBy("db:ARTIST_ID") > > On Wed, Oct 27, 2

Re: Ordering objects by primary keys

Is there any point in the documentation where this "db:" prefix has been documented? Cheers, Giulio Cesare On Wed, Oct 27, 2021 at 11:23 PM giulio.ces...@gmail.com < giulio.ces...@gmail.com> wrote: > It did work! 🤩 > > Thanks Nikita. 🙏 > > Cheers, > > Giu

Re: Ordering objects by primary keys

xpressions < > http://cayenne.apache.org/docs/4.1/cayenne-guide/#expressions> > > > Andrus > > > > On Oct 28, 2021, at 9:38 AM, giulio.ces...@gmail.com wrote: > > > > Is there any point in the documentation where this "db:" prefix has been > > documente

Cayenne 3.0.2 artifacts 😅

Hello everybody, I am trying to win the quest for the most weird question, so let me give it a try. I am trying to rebuild a VERY old application of mine (still smoothly running) because I would need to update how we do send metrics to DataDog. This application is Cayenne 3.0.2 old. Unfortunate

Re: Cayenne 3.0.2 artifacts 😅

). Thanks again for this wonderful project! Giulio Cesare On Sat, Aug 26, 2023 at 9:49 AM giulio.ces...@gmail.com < giulio.ces...@gmail.com> wrote: > Hello everybody, > > I am trying to win the quest for the most weird question, so let me give > it a try. > > I am tryi

Re: Cayenne 3.0.2 artifacts 😅

1.2-dev.pom > > And here's how I access it from gradle. Not sure how it's done in maven. > > Files from project root: > > repositories { > maven { > url "local-maven-repo" > } > mavenCentral() > } > dependencies { >