Re: MS SQL Server: Select Distinct on text datatype

2008-08-05 Thread Andrus Adamchik
On Aug 5, 2008, at 9:24 PM, Lachlan Deck wrote: Was just thinking that there didn't seem to be any hook available to createSqlString() (which calls the above method) to ensure suppressingDistinct is true for this case. Sure. I am +1 on such change if we find that overriding it in a subcl

Re: MS SQL Server: Select Distinct on text datatype

2008-08-05 Thread Lachlan Deck
On 06/08/2008, at 10:40 AM, Andrus Adamchik wrote: On Aug 5, 2008, at 8:27 PM, Lachlan Deck wrote: Any objections to adding (or making) isUnsupportedForDistinct non- static? i.e., assuming that SelectTranslator can be overridden. I don't have any objections per se, but can you elaborate how

Re: MS SQL Server: Select Distinct on text datatype

2008-08-05 Thread Andrus Adamchik
On Aug 5, 2008, at 8:27 PM, Lachlan Deck wrote: Any objections to adding (or making) isUnsupportedForDistinct non- static? i.e., assuming that SelectTranslator can be overridden. I don't have any objections per se, but can you elaborate how that can help in your situation? Andrus

Re: MS SQL Server: Select Distinct on text datatype

2008-08-05 Thread Lachlan Deck
Hi there, On 05/08/2008, at 6:49 AM, Andrus Adamchik wrote: Andrey, you are spot on with the UNSUPPORTED_DISTINCT_TYPES. Any objections to adding (or making) isUnsupportedForDistinct non- static? i.e., assuming that SelectTranslator can be overridden. Here is one caveat (and hopefully a wo

Using "relationship != null" qualifier with ObjEntity Inheritance

2008-08-05 Thread Dave Dombrosky
I am currently trying to use ObjEntity Inheritance in my project, but I am running into some difficulties. I was hoping that I could use "someRelationship != null" as the qualifier, but I get the following error when trying to run the code: org.apache.cayenne.exp.ExpressionException: [v.3.0-SNAPS

Re: Can't extract a master key

2008-08-05 Thread Dave Dombrosky
For some reason or another, I am not seeing this problem anymore. I think this may have been caused by another issue, for which I will create a separate thread. On Thu, Jul 31, 2008 at 2:21 PM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > Hi Dave, > > MyDataObject is likely mapped to get its PK f

Re: MS SQL Server: Select Distinct on text datatype

2008-08-05 Thread Andrus Adamchik
Hi Matthias, maybe you can switch to CLOB column type on Derby. Andrus On Aug 4, 2008, at 9:39 PM, Matthias Moeser wrote: Hi! Thank you Andrus and Andrey. I changed the mapping for the columns of datatype "text" from VARCHAR to CLOB (max length 32000) in Cayenne Modeler. Everything is wo

hsqldb and Relationships

2008-08-05 Thread Dirk Wellmann
Hi List, I've a HSQLDB issue on using Relationships with Delete-Rules. Some Relations have a Delete-Rule Cascade and some not, but the Generator generates always a "ADD CONSTRAINT XYZ FOREIGEN KEY (FIELDNAME) REFERENCES TABLENAME (FIELDNAME) ON DELETE CASCADE". I've checked the XML twice, th