(How to) Make SQLData of UUID?
От | Alexander Myodov |
---|---|
Тема | (How to) Make SQLData of UUID? |
Дата | |
Msg-id | CAHF95JzG9dAJnmjR000VQMeyLb1+4JsyffDQcSQ5h2LrNTaqHA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: (How to) Make SQLData of UUID?
Re: (How to) Make SQLData of UUID? (How to) Make composite PGObject with Text? (Was: (How to) MakeSQLData of UUID?) |
Список | pgsql-jdbc |
CREATE TYPE MYFUNC_RETURN_TYPE AS
(
key UUID
);
Now, to handle it in JDBC, I need to make a custom type like MyfuncReturnType implements SQLData, and then add it to the type map of the connection. In MyfuncReturnType, I’ll need to implement void writeSQL(SQLOutput stream) method, and at some point I’ll need to do something like this: to call either
SQLOutput::writeObject(SQLData x)
or
SQLOutput::writeObject(Object x, SQLType targetSqlType),
passing my UUID in somehow.
But UUID doesn’t satisfy SQLData interface in any way; and if I use the second method, I do not have a proper SQLType for UUID anywhere.
I previously used the pgjdbc-ng driver, and they had a collection of postgresql-specific SQLType's; but that driver had other problems, so I decided to switch to the mainstream JDBC driver, and faced this lack.
Any hints please?
В списке pgsql-jdbc по дате отправления: