Re: Custom type woes

On Wed, 28 Jun 2006, CG wrote:

> I'm trying to use the datatype defined in the uniqueidentifier contrib
> module from within my java application. I had originally thought I would
> process the values in java as strings, but I can't insert the values
> back into a table becuase I can't figure out how to create an explicit
> cast. I had hoped that the automatic type conversion would work, but it
> doesn't in the case of insert, or in function parameters.

If you use the 8.2dev driver and create your connection using the
stringtype=unspecified, then these automatic casts should work.

http://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters

> My next idea was to add the type to JDBC a la Money and Interval. I've never
> worked with JDBC drivers before, so I just guessed at what it would take. I
> created the java class PGuniqueidentifier and modeled it after the other
> classes in org.postgresql.util. I linked it up along with all the other odd
> types in org.postgresql.jdbc2.AbstractJdbc2Connection ... That didn't work
> either.

Could you describe didn't work? I don't see why it wouldn't.

> SQLWorkbench reports columns of uniqueidentifier as java sql type OTHER ...
>

It will still do that regardless of what you do. What java.sql.Type would
you like it to use and how could it know that?

Kris Jurka