Re: Mapping SQL UDT to java class - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: Mapping SQL UDT to java class
Date
Msg-id CAB=Je-E27RxwaUXQe1w2aD53uAc8nhtBd=je+L-qgaiBdA+oaA@mail.gmail.com
Whole thread Raw
In response to Re: Mapping SQL UDT to java class  (Dave Cramer <pg@fastcrypt.com>)
List 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


pgsql-jdbc by date:

Previous
From: "Markus KARG"
Date:
Subject: Re: Migration to Maven
Next
From: Kevin Wooten
Date:
Subject: Re: Mapping SQL UDT to java class