Got a reply from Kevin, which said that Hibernate had set the BLOB
column maximum size to 255 bytes. After this was fixed, inserting the
64k BLOB worked fine.
--
Kristian
Kristian Waagan wrote:
Kevin Wu wrote:
I use embedded derby as my database, but when I save a Blob to DB, it
throw the following exception, I am wandering how to solve the matter.
It looks the BLOB only 255 bytes. How can I save a 64k bytes to the
BLOB column.
Hello Kevin,
Can you show us the SQL used to create the table, or just the SQL
specifying the BLOB column?
If you did not specify a maximum length for the BLOB column, something
is wrong in Derby, because the default should be 2GB -1 bytes (assuming
your using a recent version of Derby).
Assuming you have not found a Derby bug, the error message you get says
that the Blob is too big for the column it is being inserted into. And
Derby is not able to shrink it.
(The 'XX-RESOLVE-XX' looks a bit scary, but I think it is only put there
in lack of a name for the Blob).
regards,
