Re: Syntax error and question about JOIN

2011-07-11 Thread Andrus Adamchik
Heh :-) In 3.1 we have a nice mechanism for creating simple extension points of Cayenne. I hope we'll start using that more to unwind these chains and allow for easier extensibility. I guess community input and contributions should become a driving force here. Andrus On Jun 30, 2011, at 4:0

Re: Syntax error and question about JOIN

2011-06-30 Thread Wernke zur Borg
Thanks Andrus, that got me going. I had to create six classes to add a single word to a query! ;) And fortunately that single word is the first one to be output, so in my appendJoinSubtree() function I am simply outputting " INNER" and then call super.appendJoinSubtree() for the rest. Would have

Re: Syntax error and question about JOIN

2011-06-29 Thread Andrus Adamchik
There's a tree of related objects involved. Check Oracle8Adapter and related classes. It actually switches Cayenne back to joins in WHERE clause. The chain of overridden objects goes like this: Oracle8Adapter.getAction(..) Oracle8ActionBuilder Oracle8SelectAction Oracle8JoinStack

Re: Syntax error and question about JOIN

2011-06-28 Thread Wernke zur Borg
Thanks for your answers. I would like to stick to version 3.1, so could somebody give me a hint as to where to modify the JOIN syntax in a custom DB adapter? I looked at all the existing DB adapters and I guess I would subclass JdbcAdapter but I could not find a suitable method to override. Thank

Re: Syntax error and question about JOIN

2011-06-21 Thread Andrus Adamchik
Past versions of Cayenne used joins in WHERE clause, that were likely compatible with MS Access. So older Cayenne 2.0.x should probably work. Also writing a custom Access DbAdapter that adds INNER should be possible. Andrus On Jun 21, 2011, at 11:36 AM, Aristedes Maniatis wrote: > On 21/06/11

Re: Syntax error and question about JOIN

2011-06-21 Thread Aristedes Maniatis
On 21/06/11 6:02 PM, Wernke zur Borg wrote: Hi, I am having a few problems with queries on an MS Access database when I use object relationships to access related tables. I am using Cayenne 3.1 M2. My case is very simple. Let's say I have two tables A and B where A has a column col containing a

Syntax error and question about JOIN

2011-06-21 Thread Wernke zur Borg
Hi, I am having a few problems with queries on an MS Access database when I use object relationships to access related tables. I am using Cayenne 3.1 M2. My case is very simple. Let's say I have two tables A and B where A has a column col containing a primary key of B. Given an object a from tabl