Dods: PostgreSQL and BLOB's

["Mike Strapp" <Michael.Strapp@xxxxxxxxxxxxxxx>]

Hi All,

    I've been experimenting with trying to get PostgreSQL BLOB's to work, and so far have been unsuccessful.  I've been able to get data put into the blob and to come out of the blob, but somewhere along the line it seems to be applying some kind of Unicode encoding rules - bytes which are FF by themselves are skipped, and all data past the first case of FF FF is also skipped.  I've actually been trying this with straight JDBC, on the assumption that if I can figure out what the problem is, that I can apply the same solution to the Enhydra data objects, or come up with a workaround if need be.  But so far, it has me stumped.  (I've tried both the PreparedStatement.setBinaryStream() method and the PreparedStatement.setBytes() method.)

    I have been using the OID datatype, should I be using the BYTEA type instead (since that's what's suggested in the dods.conf)?  I gave that a try and couldn't get around the "ERROR:  Attribute 'small_icon' is of type 'bytea' but _expression_ is of type 'int4'" message.

    Has anyone out there successfully used Blobs on PostgreSQL in Java (either through JDBC or through DODS-generated data objects)?

 

Thanks in advance...

Mike.