Slick to manage Array[byte] in PostgreSQL with Scala

Question

We are having a few issues managing images in the database with Slick. They are stored in a Array[Byte] format. Every source I read informs me it should work, but I keep getting this error:

could not find implicit value for parameter conv: scala.slick.jdbc.GetResult[Array[Byte]]

The compiler is telling me that no mapper is found for Array[Byte]. I must be missing a simple import, but I can't seem to find it.

Here is the query I execute: Q.queryNA[Array[Byte]]("SELECT image FROM images WHERE id = 1") — Philippe
– Philippe, Commented Jun 15, 2013 at 7:48

cmbaxter · Accepted Answer · 2013-06-15 14:54:21Z

3

You need an implicit GetResult in scope to map from the db result to the Array[Byte] that you want. Try adding the following just before your query:

implicit val GetByteArr = GetResult(r => r.nextBytes)

answered Jun 15, 2013 at 14:54

cmbaxter

35.5k4 gold badges88 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Philippe Over a year ago

Hi, thanks for the response. Because of the deadline, we took the easy way out of saving the bytes as a file. We might use your input in the near future, when we have more time. Thanks again.

Collectives™ on Stack Overflow

Slick to manage Array[byte] in PostgreSQL with Scala

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related