About setBLOb & getBlob

[shruty sharma]

Hi!!

I want to insert byte array in database schema as follows:
table message
{
msgid number(5),
messagevalue BLOB
};

I have done this in following way But I am getting NULL pointer exception.

//byte[] msgval .. contains byte values like 49 50 53 etc.

Blob msg;
msg.setBytes(1,msgval);
// for prepared statement I have used st2.setBlob(4,msg);

[Bauke Scholtz]

It´s hard to help without knowing the details.
http://faq.javaranch.com/java/TellTheDetails