How to cast a blob (>32k) to a string?

Question

Java

Hello!
Task: in the db2 database there is a table with a BLOB type column, it maintains data in JSON format, the size can exceed 32kb (varchar overflow), this data needs to be obtained. ORM - OpenJPA
tried casting to java.sql.Blob, pulling out an array of bytes from it, etc.,
everything I have is not working - the class of the object into which this blob is thrown (com.ibm.db2.jcc.am.he) .
thanks in advance

Answer 1

no ORM - pure JDBC
https://www.ibm.com/support/knowledgecenter/ssw_ib...
byte[] outByteArray = blob1.getBytes(startingPoint, (int)endingPoint);
then specify in string with the desired encoding