Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of giulio.cesare@gmail.com
 designates 209.85.214.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAAOOpAMzJAf7EuYfEgc5JytGPrY87QbfE3v6Zs1h43omqjfUSw@mail.gmail.com>
References: <13085.105.249.62.7.1369748538.squirrel@webmail.xsinet.co.za>
	<CAAOOpAMzJAf7EuYfEgc5JytGPrY87QbfE3v6Zs1h43omqjfUSw@mail.gmail.com>
Date: Tue, 28 May 2013 16:35:39 +0200
Message-ID: 
 <CAAOOpANwOxpZRq6UeD03dwXcWrEjJT=tuR+7x17hcLtAo-wBRQ@mail.gmail.com>
Subject: Re: SQLTemplate returning NULL results
From: "giulio.cesare@gmail.com" <giulio.cesare@gmail.com>
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=bcaec52bf14be3743304ddc82d72

--bcaec52bf14be3743304ddc82d72
Content-Type: text/plain; charset=UTF-8

Hello Andrus,

I have dug through the code, and I have found a point where something I
don't understand happens.

When `SQLTemplateMetadata.resolve` method is invoked, `query.result()`
return null, and this means that `resultSetMapping` is set to null.

But the query is actually returning 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.cesare@gmail.com <
giulio.cesare@gmail.com> wrote:

> 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 when using SelectQuery instead of
> SQLTemplate; but to no avail.
>
> I will post here any findings.
>
> Giulio Cesare
>
>
>
> On Tue, May 28, 2013 at 3:42 PM, <dollj@xsinet.co.za> wrote:
>
>> Hi Giulio,
>>
>> I've had this problem before. Try the following: goto SaleSummary in
>> Cayenne Modeler and click on the attributes tab.
>>
>> Make sure that your SQLTemplate query contains all the DbAttributes
>> listed.
>> They must be spelt exactly the same way (CaPs SenSitiTive), order isn't
>> important.
>>
>> Also the table's Primary key MUST be included as indicated in the related
>> table/view dbEntity for SaleSummary. Also CaPs SenSitiTive !
>>
>> Hope this helps
>> regards
>> Jurgen
>>
>>
>> > 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<SaleSummary> saleSummariesToProcess =
>> > objectContext.performQuery(query);
>> >
>> > Looking into the logs, this is the SQL statement generated automatically
>> > by
>> > Cayenne:
>> >> SELECT t0.amount, t0.unique_id, t0.period, t0.registrationDate,
>> >> t0.id_contract, t0.id_currency, t0.id_customer, t0.id_frontendSystem,
>> >> t0.id_saleSummary, t0.id_store FROM wolf.SaleSummary t0
>> >
>> > So far, so good. But as soon as I replace the SelectQuery with a
>> > SQLTemplate, I can no longer get any result. Actually, I get the
>> expected
>> > results, but instead of being instances of SaleSummary, the list
>> contains
>> > all nulls.
>> >
>> > I need to run a fairly complex query that I would like to store into the
>> > model, but also the most trivial tests are failing.
>> >
>> > I have tried all the following options, all with the same bad result:
>> > - query = new SQLTemplate(SaleSummary.class, "select * from
>> salesummary");
>> > - query = new SQLTemplate(SaleSummary.class, "SELECT * FROM
>> SALESUMMARY");
>> > - query = new SQLTemplate(SaleSummary.class, "SELECT t0.amount,
>> > t0.unique_id, t0.period, t0.registrationDate, t0.id_contract,
>> > t0.id_currency, t0.id_customer, t0.id_frontendSystem, t0.id_saleSummary,
>> > t0.id_store FROM wolf.SaleSummary t0");
>> >
>> > This latest option includes the same exact SQL query logged by the
>> initial
>> > working code (that was using the SelectQuery class instead of
>> > SQLTemplate).
>> >
>> > Am I doing something blatantly wrong, or is there something weird going
>> on
>> > here?
>> >
>> > BTW, I am using Cayenne 3.1B2. I was tempted to go back to 3.0.2, but
>> > being
>> > the model files not compatible, I was trying to understand why it is not
>> > working on 3.1B2 first.
>> >
>> > Any hints?
>> >
>> > Best regards,
>> >
>> > Giulio Cesare
>> >
>>
>>
>>
>

--bcaec52bf14be3743304ddc82d72--