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