Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
References: <CADYwi8gYOrEq3CqCvKQv0o_8D0u=tnGEZbeH==pH1mcrRctWEg@mail.gmail.com>
 <CAOy5kzOWv2eVLO3CsdSrEaXQQH3NGY1Yn51iMuRjwsrt6GX6yQ@mail.gmail.com>
 <CADYwi8ixthWTL3MSe-b4rbScw9ZnsXMR+r62OqgYq5ouYbx01g@mail.gmail.com>
 <CADYwi8hhpM4Ej0WuZq1ZiW-hjk5zX8wUE4QTKKKrh_vHN9a4GQ@mail.gmail.com>
 <CAOy5kzNT7BP22+CaM7pGocemkXFenOo8vqS3mW-c02eMeDFEkg@mail.gmail.com>
 <CADYwi8io1S9C+aTN8E-O=wWMB2h7wEBDxmRzoS8wsROfJp2Gpw@mail.gmail.com>
 <CAOUwSGvNriZFO3ku-1=eMWvZ-8eMG+3P2ajU_dDAD1R40P3cRQ@mail.gmail.com>
 <CADYwi8iDpxtRt-cArXGKz1VX-bwFaek=0vN5g7vh9o_ijDqjZA@mail.gmail.com> <CAOUwSGsX+uuBkfdr9AJ=99cCV0K60Mz-0TQw=cCA_HOoNYin=A@mail.gmail.com>
In-Reply-To: <CAOUwSGsX+uuBkfdr9AJ=99cCV0K60Mz-0TQw=cCA_HOoNYin=A@mail.gmail.com>
From: John Huss <johnthuss@gmail.com>
Date: Fri, 15 Jul 2016 18:10:34 +0000
Message-ID: <CAOUwSGtKNmjdLRYx4rArXfcUbi+gh5ubSpw+_YWvMOb6XaEqKA@mail.gmail.com>
Subject: Re: Aggregate function
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=001a114fb5387f35420537b0896a
archived-at: Fri, 15 Jul 2016 18:10:51 -0000

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

You have to call query.setFetchesDataRows(true)
On Fri, Jul 15, 2016 at 1:08 PM John Huss <johnthuss@gmail.com> wrote:

> That's the query you don't want. You want a DataRow object not a Reading.
> On Fri, Jul 15, 2016 at 12:58 PM Harunobu Oyama <ho@telensa.com> wrote:
>
>> John,
>>
>> So, there is no Cayenne native way to perform a query such as SELECT
>> MAX("reading_id") FROM "reading"  ?
>> It sounds like you are recommending to write another query to fetch a
>> record with max reading_id instead.
>>
>> Indeed, the code below worked.
>>
>>   SQLTemplate query = new SQLTemplate( Reading.class, "SELECT * FROM
>> \"reading\" WHERE \"reading_id\"=( SELECT MAX(\"reading_id\") FROM
>> \"reading\" )" );
>>   List result = context.performQuery( query );
>>
>> thank you,
>> nobu
>>
>>
>>
>>
>> On 15 July 2016 at 18:35, John Huss <johnthuss@gmail.com> wrote:
>>
>> > Make sure your sqltemplate us set to fetch datarows (hashmap) not
>> objects
>> > On Fri, Jul 15, 2016 at 12:27 PM Harunobu Oyama <ho@telensa.com> wrote:
>> >
>> > > Michael,
>> > >
>> > > The min connection and max connection are both 1 as default.
>> > >
>> > > nobu
>> > >
>> > >
>> > > On 15 July 2016 at 18:16, Michael Gentry <blacknext@gmail.com> wrote:
>> > >
>> > > > On Fri, Jul 15, 2016 at 12:39 PM, Harunobu Oyama <ho@telensa.com>
>> > wrote:
>> > > >
>> > > > > Caused by: java.sql.SQLException: Can't obtain connection. Request
>> > > timed
>> > > > > out. Total used connections: 1
>> > > > > at
>> > > > >
>> > > > >
>> > > >
>> > >
>> >
>> org.apache.cayenne.conn.PoolManager.uncheckPooledConnection(PoolManager.java:454)
>> > > > > at
>> > > >
>> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:382)
>> > > > > at
>> > > >
>> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:371)
>> > > > > at
>> > > > >
>> > > > >
>> > > >
>> > >
>> >
>> org.apache.cayenne.configuration.server.DefaultDbAdapterFactory.detectAdapter(DefaultDbAdapterFactory.java:97)
>> > > > > ... 15 more
>> > > >
>> > > >
>> > > > Hi Nobu,
>> > > >
>> > > > Given this part of the exception, it seems it was unable to get a
>> > > > connection to the database.  How is your connection pool configured?
>> > Do
>> > > > you only have one connection?
>> > > >
>> > > > mrg
>> > > >
>> > >
>> >
>>
>

--001a114fb5387f35420537b0896a--