jdbc - Writing to a new Blob in Java

Question

I want to be able to create a new Blob object and then write to it. Originally, my general plan for this was as follows:

Create a new blob (null, because there's no Blob constructor) Create a new OutputStream and set it to blob.setBinaryStream(0) Write to the output stream.

However, I get a NullPointerException when I try to execute this code. Is there a different way I should be going about this? Any help would be appreciated.

Thanks!

~B

Answer 1

java.sql.Blob is an interface and not a class, thus no constructor can exist. But you can instantiate the implementing class SerialBlob which allows you to construct a blob from a byte array.