Custom type woes

From: CG <cgg007(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Custom type woes
Date: 2006-06-28 16:33:01
Message-ID: 20060628163301.81236.qmail@web37912.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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.

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.

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

So, I need a kick in the right direction.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-06-28 17:04:11 Re: JDBC Driver
Previous Message Tamás Barta 2006-06-28 10:01:29 JDBC Driver