[Sequoia] corrupted Postgres bytea field values?

[John]

Hi,

Sequoia 2.10.10
Postgresql 8.3

The Sequoia JDBC driver is not correctly returning the values of bytea
fields. The Sequoia backend is using the regular Postgres JDBC driver
(org.postgresql.Driver). Using SQuirreL (query tool), if I connect
using the Postgres driver I get the correct value but if I connect using
the Sequoia driver, I get a corrupted value.

Has anyone seen this before? Any tips about what I should be looking
at? Thanks.

[Emmanuel Cecchet]

Hi,

The list has moved to sequoiadb-discuss-5NWGOfrQmneRv+***@public.gmane.org
The Postgresql bytea type is not standard. If you are trying to retrieve
it using ResultSet.getBytes() it should work. If you are trying a
standard ResultSet.getObject() this will require a custom conversion
that can be plugged into a BackendObjectConverter object.

How are you trying to fetch the bytea field on the client side?

Thanks for your interest in Sequoia
Emmanuel

Post by John
Hi,
Sequoia 2.10.10
Postgresql 8.3
The Sequoia JDBC driver is not correctly returning the values of bytea
fields. The Sequoia backend is using the regular Postgres JDBC driver
(org.postgresql.Driver). Using SQuirreL (query tool), if I connect
using the Postgres driver I get the correct value but if I connect using
the Sequoia driver, I get a corrupted value.
Has anyone seen this before? Any tips about what I should be looking
at? Thanks.
_______________________________________________
Sequoia mailing list
http://forge.continuent.org/mailman/listinfo/sequoia