From: | Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> |
---|---|
To: | RW Shore <rws228(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Array of compound not supported? |
Date: | 2011-02-21 09:34:17 |
Message-ID: | 4D623199.3010703@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Have you tried setObject(1, str, Types.OTHER); ?
20.02.11 01:02, RW Shore написав(ла):
> I have a compound type defined as
>
> CREATE TYPE typedef.DECLASS_REASON_ENTRY AS (
> ENTRY_REASON VARCHAR(80),
> AUTHORIZING_USER VARCHAR(20)
> )
>
> and a table defined as
>
> create table table102 (field1 typedef.declass_reason_entry[] )
>
> The following statement works:
>
> 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Maurin, Marion | 2011-02-21 10:05:04 | Re: PGXAConnection and autocommit problem |
Previous Message | Lukas Eder | 2011-02-20 10:42:45 | Re: Array of compound not supported? |