Search Postgresql Archives

Re: About Blobs in postgresSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux