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" <[EMAIL PROTECTED]>
> 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
--- Begin Message ---
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
--- End Message ---
