db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dmclea...@comcast.net
Subject Re: ARRAY
Date Fri, 11 Aug 2006 12:19:16 GMT
A search of the Derby reference would find nothing (which is a pretty big clue) but looking
at the JDBCSupport page on the Derby Wiki <http://wiki.apache.org/db-derby/JDBCSupport>
you would find that none of the array methods are supported because "B. Derby does not support
the datatype at all (yet)."

 -------------- Original message ----------------------
From: "Hong Ji" <hongcodes@gmail.com>
> Hello,
> 
> How to create a table with a colume is of type ARRAY?
> The following SQL statement fails at "ARRAY."
> 
> "create table APP.Rooms (" +
>         "ID                         INTEGER NOT NULL PRIMARY KEY GENERATED
> ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)," +
>         "SYMBOL                  VARCHAR(30), " +
>         "TYPE                       VARCHAR(30), " +
>          "TICKET_IDS             ARRAY" +
>         ")";
> 
> So how to define the TICKET_IDS field as array of integers in Derby?
> 
> Thanks.
> 
> Hong




Mime
View raw message