passing user defined data types to stored procedures

Поиск
Список
Период
Сортировка
От Jay Howard
Тема passing user defined data types to stored procedures
Дата
Msg-id 7569a8ec0811140937v2f0ea340ra41c42a0ca8088d3@mail.gmail.com
обсуждение исходный текст
Ответы Re: passing user defined data types to stored procedures  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Does the driver support passing UDTs as arguments to stored procs?

Suppose I have a class Foo that implements SQLData.

On the server side, I've created a composite type called "foo", along with a proc that accepts a single "foo" argument and returns a "foo".

On the client side, I acquire a connection and set its type map such that "foo" maps to Foo.class.

When I try to setObject(2, new Foo()) on a CallableStatement, I get that the driver can't infer the SQL type to use for an instance of class Foo.

Have I screwed something up, or is this just not supported?  The driver docs didn't have much to say, that I could find.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: serge.luc-cayol@wanadoo.fr
Дата:
Сообщение: trouble in installing postgreSQL 8.3
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: passing user defined data types to stored procedures