Re: [JDBC] SQLData user-defined-types and getObject()

On Sat, 7 Jan 2006, Assad Jarrahian wrote:

> I am quite confused (PLEASE PLEASE Help), I cannot find anything on
> the web). I read that you can declare a class that implements SQLData
> (in this case I set up a class called Complex from the /src/tutorial
> datatype that mimics the user-defined datatype in the db) and then set
> the mapping appropriately (see below).

This is possible according to the JDBC spec, but the postgresql driver
does not implement it. At the moment your only option is to have your
class implement org.postgresql.util.PGobject and register it using a pg
specific method. This is fine for a true user defined type, but it
certainly isn't ideal for a composite type because it requires the type
creator to handle all of the fields himself.

There isn't much documentation on PGobject implementations either, but the
javadoc and source code will point you in the right direction.

http://jdbc.postgresql.org/documentation/publicapi/org/postgresql/util/PGobject.html

Kris Jurka