insert into table102(field1) values ('{"(\\"abcdef\\",\\"ghijkl\\")","(\\"abcdef\\",\\"ghijkl\\")"}')
Consider the following prepared statement:
insert into table102 (field1) values (?)
If I use setString() on this prepared statement, execution throws a variant of illegal type (complains about the parameter being a char varying when it wants something else). If I use setObject() and pass it a java.sql.Array implementation that wraps this same string, I get a malformed array literal error.Note that the same code works fine with arrays of all the built-in types, including point. No matter what I do, I can't insert into the array of compound from my app.
Anybody have any suggestions, or is array of compound simply not supported via a prepared statement?