Actually types.xml only affects DB generation. So I expect bytea to
work as before, with no changes to the adapter (as long as there are
no JDBC quirks of course).
Andrus
On Dec 7, 2006, at 12:13 PM, Tore Halset wrote:
Hello.
I want to try out Slony-I replication solution for PostgreSQL. It
does not handle oid-blobs, so I must use bytea instead. This is
okay as my blobs are not that big.
PostgreSQL has a blob problem.. If the blob in the database are
bytea, you must use setBytes/getBytes. If it is oid blob, then you
must use setBlob, getBlob. cayenne ByteArrayType handle this with
the usingBlob parameter.
Some time ago, cayenne switched from bytea to oid blob as a default
blob data type. That was a good choice, but makes replication
solutions like Slony-I and Sequoia difficult to implement.
I want to be able to run the PostgresAdapter with bytea as blob
type. Should I create my own local sublcass of cayenne
PostgresAdapter with its own types.xml or is there a better way?
- Tore.
