EntityMode.DOM4J gives me a strange encoding for binary data from PostgreSQL. The data type in PostgreSQL is bytea, and the data type of the POJO is byte[].

Using EntityMode.POJO, Query.list() gives me POJOs with correct byte[] field values.

Using EntityMode.DOM4J, Query.list() returns this encoding of my sample data in an XML structure:

binary data ==> xml element content
0x000102 ==> 808182
0x303132333435 ==> b0b1b2b3b4b5

Does anybody know where this encoding is defined and documented? It's not the PostgreSQL "escaped" binary encoding, nor is it any XML binary encoding I've seen.

Thanks,
--Steve

OK, I missed an obvious pattern here. With a little more data it becomes very clear.

binary data ==> xml element content
0x000102 ==> 808182
0x303132333435 ==> b0b1b2b3b4b5
0x7e7f808182 ==> feff000102

This smells like a bug.

--Steve