JDBC and LO - invalid large object descriptor

Поиск
Список
Период
Сортировка
От Andreas Vogler
Тема JDBC and LO - invalid large object descriptor
Дата
Msg-id KHELIJKLEJJJDKDOLGPDOEIKCAAA.Andreas.Vogler@geneon.de
обсуждение исходный текст
Список pgsql-interfaces
Hi,

I have got a problem with reading large objects from Postgres through JDBC
(both 7.0.2):
a call to resultset.getBytes(...) results in:

FastPath call returned ERROR:  lo_tell: invalid large object descriptor (0)
at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141)
at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:191)
at org.postgresql.fastpath.Fastpath.getInteger(Fastpath.java:203)
at org.postgresql.largeobject.LargeObject.tell(LargeObject.java:232)
at org.postgresql.largeobject.LargeObject.size(LargeObject.java:247)
at org.postgresql.jdbc2.ResultSet.getBytes(ResultSet.java:370)

using "select lo_export(...)" is no problem, so I suppose the data is stored
correctly within the DB.
Any idea where the 0 is comming from or what the problem could be?

ByeAndreas



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

Предыдущее
От: "Chris Haas"
Дата:
Сообщение: Re: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
Следующее
От: Manika dey
Дата:
Сообщение: problem largeobject