Robert, Thank you for your message and sorry for my slow response. EJBQLQuery looks like a good way to perform 'general' query to get non entity result.
nobu On 15 July 2016 at 22:28, Robert Zeigler <robert.zeig...@roxanemy.com> wrote: > Cayenne supports EJBQLQuery, which would be another way to go about this. > > See also: > > http://cayenne.apache.org/docs/4.0/cayenne-guide/queries.html#ejbqlquery < > http://cayenne.apache.org/docs/4.0/cayenne-guide/queries.html#ejbqlquery> > > Robert > > > On Jul 15, 2016, at 12:58 PM, Harunobu Oyama <h...@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 <johnth...@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 <h...@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 <blackn...@gmail.com> wrote: > >>> > >>>> On Fri, Jul 15, 2016 at 12:39 PM, Harunobu Oyama <h...@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 > >>>> > >>> > >> > >
