| From: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
|---|---|
| To: | "Shen, Ning (NSHEN)" <NSHEN(at)arinc(dot)com> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, Dave Cramer <pg(at)fastcrypt(dot)com> |
| Subject: | Re: Mapping SQL UDT to java class |
| Date: | 2015-12-21 19:46:11 |
| Message-ID: | CAB=Je-E27RxwaUXQe1w2aD53uAc8nhtBd=je+L-qgaiBdA+oaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Dave is right, SQLData is not yet supported by pgjdbc.
Shen, Ning> it seems impossible to query these UDTs and use the
functions defined in the server without JDBC’s support for the UDT.
That is not quite true.
You can always send/receive arbitrary structures via setString/getString.
Our company uses that a lot with great success (modulo manual escaping
of arrays and structs).
For trivial types like "smallint + bytea" it should be rather simple.
Vladimir
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Wooten | 2015-12-21 20:05:42 | Re: Mapping SQL UDT to java class |
| Previous Message | Alvaro Herrera | 2015-12-21 18:12:12 | Re: Patch: Implement failover on libpq connect level. |