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 stackoverflow.com/questions/1557085/… ?

Chris
– Chris

2012-09-20 14:26:37 +00:00
Commented Sep 20, 2012 at 14:26 — Chris
– Chris, Commented Sep 20, 2012 at 14:26
@Chris I am not using JPA nor am I using the IN syntax.

Woot4Moo
– Woot4Moo

2012-09-20 14:29:45 +00:00
Commented Sep 20, 2012 at 14:29 — Woot4Moo
– Woot4Moo, Commented Sep 20, 2012 at 14:29

fredt · Accepted Answer · 2012-09-20 16:00:57Z

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, 2012 at 16:00

fredt

24.5k3 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Woot4Moo Over a year ago

Good to know. Hope they change that.

Collectives™ on Stack Overflow

HSQL reference custom type in jdbc create array statement

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related