Custom type woes

Поиск
Список
Период
Сортировка
Искать
От
CG
Тема
Custom type woes
Дата
Msg-id
20060628163301.81236.qmail@web37912.mail.mud.yahoo.com
Список
Дерево обсуждения
Custom type woes CG <cgg007@yahoo.com>
Re: Custom type woes Kris Jurka <books@ejurka.com>
Re: Custom type woes CG <cgg007@yahoo.com>
Re: Custom type woes Kris Jurka <books@ejurka.com>

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 
В списке pgsql-jdbc по дате отправления
От: Thomas Hallgren
Дата:
От: Tamás Barta
Дата:
Сообщение: JDBC Driver
FAQ