Can't I fetch bytea values from my postgres db

[Manuel Pettersson]

Hello,

I am trying to map a postgres bytea value to a java byte[].

This is my table:

This is what it contains:

My DAO has this method:

@SqlQuery("SELECT ba from my_test fetch first 1 row only")

byte[] selectBytea();

But when I execute it, I get:

... Caused by: org.postgresql.util.PSQLException: Bad value for type byte : \x01 at org.postgresql.jdbc.PgResultSet.getByte(PgResultSet.java:2135) at org.jdbi.v3.core.mapper.PrimitiveMapperFactory.lambda$primitiveMapper$0(PrimitiveMapperFactory.java:64) at org.jdbi.v3.core.mapper.SingleColumnMapper.lambda$new$0(SingleColumnMapper.java:41) at org.jdbi.v3.core.mapper.SingleColumnMapper.map(SingleColumnMapper.java:55) at org.jdbi.v3.core.result.ResultSetResultIterator.next(ResultSetResultIterator.java:83)

Does anyone know what is going on?

I have also posted this question here on SO.

I am wondering if the wrong mapper is being used? ResultSet::getByte when it should be  ResultSet::getBytes?

[Matthew Hall]

I think the array return type is being interpreted as a set of bytes on individual rows, due to the array type. Try adding the @SingleValue annotation to the method.

http://jdbi.org/#__singlevalue

-Matthew

--
You received this message because you are subscribed to the Google Groups "jDBI" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jdbi+uns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jdbi/fa977461-bc49-4e3c-b904-3fbf718a805en%40googlegroups.com.

[Brian McCallister]

I think the jdbc driver also likes to return bytea as an InputStream

To view this discussion on the web visit https://groups.google.com/d/msgid/jdbi/CACwOQD3bF1ZizH%3DvcWBBD0O3b9-vsXXT_OOdTgifUEOBF0paUA%40mail.gmail.com.

[Manuel Pettersson]

thank you guys,

Matthew, yeah that seems to have been it. Works with @SingleValue.