Am Donnerstag, 12. Februar 2004 10:05 schrieb Kris Jurka:
> It is entirely unclear what your column's underlying data type is, for
> binary data it should be oid or bytea, but the only mention of datatype in
> your email is varchar. The Blob interface only works with the oid
That was failure number one ;-)
> datatype and large object method and even then support is poor. JDBC3 has
> added write support for blobs, but these have not been implemented in the
> pg JDBC driver. If you want to use large objects the easiest way is to
Ok, then i would use setBytes/getBytes anyway.
> pass compatible=7.1 as a URL parameter
How do i specify that paramter in the URL?
>and then use setBytes/getBytes.
> Could you be more clear on what you want to do and where it is failing?
I tried using rs.updateBytes() and using bytea datatype and writing seems to
work now.
But if the data are read back using getBytes() the RTF-Editorkit mourns about
"to many closed brackets", but that might not be a problem of JDBC, still
tracking it down.
Have not yet tried using setBytes() - would that make a difference other than
speed?
> The numerous one line snippets you have included aren't clear and actually
> seem contradictory to me.
Sorry - yes they were contradictory, i just pointed out all ways i tried
already.
Thanks,
Guido