EJBQLQuery and LEFT JOIN FETCH

2008-02-29 Thread David Marko
I have two tables (Issue and Reply) with 1:N relationship. I'm trying to construct EJBQL query that would load issues and prefetch replies. I tried this query: new EJBQLQuery("select a FROM Issue a LEFT JOIN FETCH a.replyArray") .. but it throws error as below. Am I doing something wrong? Davi

Re: CayenneObjectManager - alternative API for using Apache Cayenne

2008-02-25 Thread David Marko
Just for note, you can look to this URL, maybe we can learn something or at least grab some idea. http://www.thimbleware.com/projects/jrel

Re: CayenneObjectManager - alternative API for using Apache Cayenne

2008-02-24 Thread David Marko
I just read both links. I think that having some concept, that avoids using DAO schema, would be very good. For most web applications DAO is just overhead and require to write large infrastructure. Would be good to have flexibility of ActiveRecord or Django ORM for many solutions where just 5 ta

Re: CayenneObjectManager - alternative API for using Apache Cayenne

2008-02-24 Thread David Marko
Haven't read it yet. Will look at it, thanks very much! I would really appreciate some Cayenne standardized way, if there will be some. David Marko Aristedes Maniatis wrote: On 24/02/2008, at 9:13 PM, David Marko wrote: // find first item by property and given condition co_manager

CayenneObjectManager - alternative API for using Apache Cayenne

2008-02-24 Thread David Marko
Hello, a few months ago a wrote about creating alternative approach for using Apache Cayenne. Actualy I use Cayenne with Click Framework and following scenario came from practice on several projects. The main idea is to use Cayenne as very stable background(engine) but alter API to something cl

Cayenne 3.0M2 and EJBQLQuery

2007-11-13 Thread David Marko
Are there any performance differences(penalty) when using EJBQLQuery instead of e.g. SelectQuery? Also for the others, I use succesfully http://openjpa.apache.org/builds/1.0.1/apache-openjpa-1.0.1/docs/manual/jpa_langref.html as a very nice EJBQLQuery syntax manual. David

Cayenne 3.0M2 and log4j

2007-11-12 Thread David Marko
Can someone help with Cayenne 3M2 and log4j? When having commons-logging and log4j libraries available and running ... it claims as below and no INFO logs appears on console. --- log4j:WARN No appenders could be found for logger (org.apache.cayenne.conf.DefaultConfiguration). log4j:WARN Please ini

Re: [ANN] Cayenne 3.0M2 released

2007-11-12 Thread David Marko
Where can I find more info on EJB QL? Is e.g. http://openjpa.apache.org/builds/1.0.1/apache-openjpa-1.0.1/docs/manual/jpa_langref.html suitable/compatible with Cayenne implementation? David Aristedes Maniatis wrote: > > On 12/11/2007, at 7:24 AM, David Marko wrote: > >> Is th

Re: [ANN] Cayenne 3.0M2 released

2007-11-11 Thread David Marko
Is there any example for using JPA? Are there any hints/recomendations for schema evolution/migration? David Andrus Adamchik wrote: > We are glad to announce second milestone of Cayenne 3.0. For details > follow the link below: > > http://cayenne.apache.org/2007/11/11/november-11-2007-cayenne-30

Re: Cayenne ActiveRecord like interface

2007-10-09 Thread David Marko
Yes, I can provide you with code. Its suprisingly simple code. I will prepare it with some description and examples of usage. David Andrus Adamchik wrote: > > On Oct 9, 2007, at 4:56 PM, Andrus Adamchik wrote: > >> dotae > > I meant "donate" of course :-) > > A. > >

Re: SelectQuery and getting where clause

2007-10-09 Thread David Marko
m("year", 2003)); David Michael Gentry wrote: > Will: > > Expression exp = sq.getQualifier(); > String clause = exp.toString(); > > do what you are wanting? > > > On 10/9/07, David Marko <[EMAIL PROTECTED]> wrote: >> Hello, I need to create a select quer

Cayenne ActiveRecord like interface

2007-10-09 Thread David Marko
Hello, I like a ROR ActiveRecord a lot and I decided to create a special interface for Cayenne to let me work easier in most cases. I borrowed some ideas and created a wrapper for Apache Cayenne. Instead a common DAO like scenario of using services for each model, I can now use one EntityManager th

SelectQuery and getting where clause

2007-10-09 Thread David Marko
Hello, I need to create a select query that have some parameters and I need to get SQL where statement from it containing replaced parameters. (see snippet below) . Is there any way how to accomplish this? [Code snippet] SelectQuery sq = new SelectQuery(Role.class,Expression.fromString(this.wher