Hi
The documentation on caching (http://cayenne.apache.org/doc/caching-and-fresh-data.html
and http://cayenne.apache.org/doc/object-caching.html) isn't very
comprehensive, it does not answer questions like:
- what is actually stored in cache pks? datarows ? objectIds ?
- does caching change
Hi Mike:
Thanks and I understand the need for details. The relationship is a
simple one. A "Game" belongs to a "Grouping" and there are many games
in a grouping. My model is full of similar relationships.
When I use the XML encoder to dump all the games in a grouping to the
client, there
This is a complete guess on my part since I'm not sure what you are
trying to do:
http://cayenne.apache.org/doc20/querychain.html
/dev/mrg
On Mon, Mar 3, 2008 at 4:39 PM, Eric Polino
<[EMAIL PROTECTED]> wrote:
> No, I'm moving over to using SQLTemplate. i see that
> DataContext.performQueries
No, I'm moving over to using SQLTemplate. i see that
DataContext.performQueries() has been deprecated and the comment
doesn't lead me to anything I understand. How do you perform a list
of queries now?
On 3/3/08, Michael Gentry <[EMAIL PROTECTED]> wrote:
> You probably want to switch over to SQL
You probably want to switch over to SQLTemplate:
http://cayenne.apache.org/doc20/sqltemplate-query.html
It can return data objects for you, which I believe is what you want.
You might be able to rewrite your SQL, too, in a manner that would
work with Expression.fromString.
On Mon, Mar 3, 2008 at
The first thing I would check is to verify that you have an
ObjRelationship named "Artist" from your root entity. Note that the
name is "toArtist" in the analogous code.
It's somewhat difficult to comment on the cause of a concrete error
given only theoretical environment information :-)
The rel
Two options:
1. SQLTemplate
2. Cayenne 3.0/EJBQL (with EJBQL is still sort of alpha, so for
subqueries I'd suggest grabbing a nightly building following the link
on the download page: http://cayenne.apache.org/download.html
Andrus
On Mar 3, 2008, at 11:19 PM, Eric Polino wrote:
Alright,
Alright, well that clears up some stuff, now I'm getting issues with
running an exists statement? I see from the grammar that it doesn't
support them. Anyone know how to run an exists like statement? ...of
course, without looping through each element of hte super query and
testing them individua
On Mar 3, 2008, at 11:05 PM, Michael Gentry wrote:
I could be mistaken here, but I don't believe that
Expression.fromString() supports "select...".
Exactly. The closest thing it resembles is EJBQL syntax [1]. But that
would require Cayenne 3.0 and a different type of query - EJBQLQuery.
A
I could be mistaken here, but I don't believe that
Expression.fromString() supports "select...". I know I've never used
it that way. I've always started with the WHERE clause as shown on
this page:
http://cayenne.apache.org/doc20/building-expressions.html
The BNF likewise does not list SELECT,
I'm not using SQLTemplate, I'm using Expression.fromString()
On 3/3/08, Mike Kienenberger <[EMAIL PROTECTED]> wrote:
> I may very well be wrong, but don't you have to use #result macros to
> assign specific types and values for each result in the map instead of
> using "select *"?
>
> From revi
I may very well be wrong, but don't you have to use #result macros to
assign specific types and values for each result in the map instead of
using "select *"?
>From reviewing my own SQLTemplate code
"select"
+ " #result('s.ID' 'long' 'ID'),"
+ " #result('s.SHOR
> >
> > Expression exp = Expression.fromString(
> > "select * from SA.Site s" +
> > "where not exists ( "+
Small typo fix. It wasn't in my code, just in the copied version in
the email. There's a space after the 's' in "SA.Site s". So the
first line reads
"sel
I ran it with SQuirrel using the DerbyClient and it works fine.
On 3/3/08, Fredrik Liden <[EMAIL PROTECTED]> wrote:
> Hi Eric,
>
> Lot of stuff going on in that query. Did you run a test query to made
> sure it works without Cayenne? Just to make sure it's not Derby having
> some issues with th
Hi Eric,
Lot of stuff going on in that query. Did you run a test query to made
sure it works without Cayenne? Just to make sure it's not Derby having
some issues with the subqueries.
Fredrik Liden
ENLASO Corp.
-Original Message-
From: Eric Polino [mailto:[EMAIL PROTECTED]
Sent: Monday,
I'm trying to query my db with the following setup and it keep getting
Expression parsing errors
Expression exp = Expression.fromString(
"select * from SA.Site s" +
"where not exists ( "+
"select * from SA.Reservation r " +
"where " +
Greetings:
I am trying to do a parameterized select query. My situation is
directly analogous to the example:
list.add(ExpressionFactory.matchExp("paintingTitle",
new ExpressionParameter("pname")));
list.add(ExpressionFactory.matchExp("toArtist.artistName",
new ExpressionPar
Cheers for that Andrus (and for the previous help on deletes). The
single transaction is the bit I wanted. Will give it a try,
Dave
Andrus Adamchik wrote:
No (although a SQLTemplate created in the API supports multiple sets
of parameters that are applied to the same template).
If you need
No (although a SQLTemplate created in the API supports multiple sets
of parameters that are applied to the same template).
If you need multiple queries to appear as a single query (and run in
the same transaction with default Cayenne transaction settings), you
can use a QueryChain:
http:/
Hi,
is it possible to have multiple sql statments in the one SQLTemplate?
e.g.
Cheers,
Dave
Hi All,
Click web application framework version 1.4 (final) is now available.
This release is the culmination of 8 months of work, and includes some
of the biggest changes to the core framework since version 1.0.
Special thanks to all the developers and users who helped make this
happen.
Click Fr
Hi
Using ROP, paging and LOCAL_CACHE in cayenne built from trunk about
month ago I'm trying to force cache refresh using
performGenericQuery(new RefreshQuery(object)); but it does not seem to
work.
Is it a right way to refresh the cache ? Could someone advice on what
to debug to figure ou
22 matches
Mail list logo
