Re: getting PSQLException Can't infer the SQL type to use with Native Query call

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: getting PSQLException Can't infer the SQL type to use with Native Query call
Дата
Msg-id 26841.1304353818@sss.pgh.pa.us
обсуждение исходный текст
Ответ на getting PSQLException Can't infer the SQL type to use with Native Query call  (Steven Dahlin <pgdb.sldahlin@gmail.com>)
Список pgsql-sql
Steven Dahlin <pgdb.sldahlin@gmail.com> writes:
> In trying to call a postgresql 8.4 stored function I am passing a
> class as well as a List (I have to save a master record as well as the
> detail records). This is being done with a native query using
> EclipseLink 2.1. However, I am getting back a message for the first
> item:

> PSQLException: Can't infer the SQL type to use for an instance of
> com.hwcs.veri.shared.dto.MyClass. Use setObject() with an explicit
> Types value to specify the type to use.

That looks like a complaint from JDBC, so possibly you'd have better
luck asking on pgsql-jdbc.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FATAL: invalid cache id: 19
Следующее
От: "Charles N. Charotti"
Дата:
Сообщение: PLpgSQL variables persistance between several functions calls