| Author |
About Blobs in postgresSQL
|
|
| kishore mukati 2005-12-20, 9:23 am |
| Hi
I am facing a proble when I am trying to store images, filse in
postgreSQL.by using Bytea datatype field in table
using setBinaryStream().
it show me exception
inputstream is supported.
please send me if anybody have solution of this problem.
thanks
kishore mukati
____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| |
| Leonel Nunez 2005-12-20, 11:23 am |
| kishore mukati wrote:
> Hi
> I am facing a proble when I am trying to store images, filse in
> postgreSQL.by using Bytea datatype field in table
> using setBinaryStream().
> it show me exception
> inputstream is supported.
>
> please send me if anybody have solution of this problem.
>
> thanks
> kishore mukati
>
>
> ____________________
____________________
__________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
No problems here
this is what I used as reference :
http://jdbc.postgresql.org/document...inary-data.html
Leonel
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| kishore mukati 2005-12-21, 3:23 am |
| 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
Leonel Nunez <lnunez@enelserver.com> wrote:
kishore mukati wrote:
> Hi
> I am facing a proble when I am trying to store images, filse in
> postgreSQL.by using Bytea datatype field in table
> using setBinaryStream().
> it show me exception
> inputstream is supported.
>
> please send me if anybody have solution of this problem.
>
> thanks
> kishore mukati
>
>
> ____________________
____________________
__________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
No problems here
this is what I used as reference :
http://jdbc.postgresql.org/document...inary-data.html
Leonel
____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| |
| Leonel Nunez 2005-12-21, 3:23 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|