On 05/08/2008, at 6:49 AM, Andrus Adamchik wrote:
Andrey, you are spot on with the UNSUPPORTED_DISTINCT_TYPES. Here is
one caveat (and hopefully a workaround). "text" is a SQL Server
native type; UNSUPPORTED_DISTINCT_TYPES stores abstract JDBC types.
So I think Matthias can simply map his "text" column as a CLOB in
Cayenne, and Cayenne will know to stop using DISTINCT.
On a side note, DISTINCT is added implicitly for to-many qualifiers
when Cayenne assumes that duplicates may be returned.
Thanks Andrus.
with regards,
--
Lachlan Deck
