Re: About Blobs in postgresSQL

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