[JDBC] JDBC and large objects

[Stephen J. Thompson]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello all,

I need to store large objects in a db through the JDBC driver. What would be 
the best field type to use? Should it be an OID.

These objects can be quite large.

Thanks all,

Regards,

Stephen.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7aBUKPmm0AnNwb5MRAs1DAJwNmFjPzG2F7oOFfgKITgI6qhpx5ACggc1P
L1dNZTuevSZXA3qpXwG+9pw=
=+wuk
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[JDBC] jdbc and large objects and oid column

[Stuart Barlow]

I am running postgresql 7.0.2 on redhat linux and connecting
using the jdbc7.0-1.2.jar

Is this the latest jdbc jar?

On another subject...
I am trying to store Serialized objects, taking the byte array
and storing in a table with an OID column. I believe that Postgresql
uses this OID as a reference to the large object.
When I try to pull back the large object I just get the integer
value and not the byte array.

Do you know why this maybe?

Thanks,
Stuart Barlow

*
Information in this email is confidential and may be privileged. It is
intended for the named addressee(s) only. If you have received it in
error please notify the sender immediately and delete it from your
system. You should not otherwise copy, retransmit, use or disclose its
contents to anyone.
*


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster