Supporting Array types

[Savva Kolbachev <s....@gmail.com>]

Hi All
We have an issue CAY-1985 <https://issues.apache.org/jira/browse/CAY-1985> with
supporting Array types in Cayenne.

I've investigated which databases support array types and posted results in
JIRA (see comment for issue).

Could everyone who interested comments how you see support array types in
Cayenne and what do you think about necessity of such functionality.

Re: Supporting Array types

[Andrus Adamchik <an...@objectstyle.org>]

Also it appears that we need to peg array in our model to a specific element type (e.g. VARCHAR ARRAY, INT ARRAY, etc.; all these are available as simply ARRAY in JDBC). This places us in an unfamiliar territory, as we no longer can define a DbAttribute with a simple int type and need an extra piece of metadata. Perhaps we need to add "array" boolean property to DbAttribute that would change type selection choices from simple types to array types.

Also a related, but not fully relevant Jira: https://issues.apache.org/jira/browse/CAY-1752 

Andrus

> On Mar 18, 2015, at 4:58 PM, Savva Kolbachev <s....@gmail.com> wrote:
> 
> Hi All
> We have an issue CAY-1985 <https://issues.apache.org/jira/browse/CAY-1985> with
> supporting Array types in Cayenne.
> 
> I've investigated which databases support array types and posted results in
> JIRA (see comment for issue).
> 
> Could everyone who interested comments how you see support array types in
> Cayenne and what do you think about necessity of such functionality.