Re: About Blobs in postgresSQL

Поиск
Список
Период
Сортировка
От Leonel Nunez
Тема Re: About Blobs in postgresSQL
Дата
Msg-id 43A8E139.6090903@enelserver.com
обсуждение исходный текст
Ответ на Re: About Blobs in postgresSQL  (kishore mukati <kishore_mukati81@yahoo.com>)
Список pgsql-general
kishore mukati wrote:

> Hi Leonel
>
>  at first thanks for help
> I try with that link you send to me
> but now I am getting a new error
> below
>
> this is exception in MyMailTracker.main()java.sql.SQLException: ERROR:
> column "attachment" is of type bytea but expression is of type integer
>
> and one more thing my postgreSQL version is 7.4 so it must support
> setBinaryStream() ;
> and
> setBytes()
> as per the postgreSQL specification
> I also tried with
> setBytes()
> but it didn't work.
>
> thanks
> regards
> kishore mukati
>
> */L/*
>



I've tested on a  postgresql 7.4.8  and  works  fine

the error says  that  you are trying to store an integer on a bytea
field,  that means  there's a mismatch  on the setBinaryStream and the
prepareStatement
check the  position on the prepareStatement  to match the
ps.setBinaryStream



leonel


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

Предыдущее
От: kishore mukati
Дата:
Сообщение: Re: About Blobs in postgresSQL
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Newbie Question: FAQ for database optimization?