HSQL reference custom type in jdbc create array statement

Question

I currently get an SQLException when invoking the createArrayOf(String,Object) of the Connection class. My database is HSQL and the code used to generate the type is as follows:

create type FOO as BIGINT;

The java code I am invoking is as follows:

Connection conn = createConnection();  
conn.createArrayOf("MySchema.FOO",data);

This also fails:

Connection conn = createConnection();  
conn.createArrayOf("FOO",data);

The resulting output is:

Invalid argument in JDBC call: FOO

My question is how can I bind to a type that exists in a HSQL database, this is not an in memory instance.

Did you check http://stackoverflow.com/questions/1557085/setting-a-parameter-as-a-list-for-an-in-expression ? — Chris, Sep 20 '12 at 14:26

score 1 · Accepted Answer · answered Sep 20 '12 at 16:00

1

User defined types are not currently supported as arguments to this method. You can use "BIGINT". Future versions of HSQLDB may support user defined type arguments.

answered Sep 20 '12 at 16:00

fredt

24,044
3
40
61

Good to know. Hope they change that. – Woot4Moo Sep 20 '12 at 16:37

HSQL reference custom type in jdbc create array statement

1 Answers1