Обсуждение: setBlob/getBlob, slony and bytea
Hello. My application uses lots of setBlob and getBlob to handle the oid blobs in the database. I do not use streaming of blobs as my largest blob are only 5MB. I want to try out Slony-I. It can replicate bytea fields, but not oid blobs. As I do not use streaming I just switched over the fields from oid to bytea. After the switch to bytea setBlob and getBlob are not working anymore. Can this be fixed in the driver or do I need to detect if the blob in the database are oid or bytea before deciding if I should use setBlob or setBytes? - Tore.
On Fri, 1 Dec 2006, Tore Halset wrote: > After the switch to bytea setBlob and getBlob are not working anymore. Can > this be fixed in the driver or do I need to detect if the blob in the > database are oid or bytea before deciding if I should use setBlob or > setBytes? > The driver could provide a wrapper that work for getBytes, but setBytes is trickier because the driver doesn't know what data type the value will be assigned to, it just fires away the data and hopes for the best. This was previously discussed in this thread: http://archives.postgresql.org/pgsql-jdbc/2005-01/thrd2.php#00029 Kris Jurka