 |  |  |  |  |  |  |  |
About setBLOb & getBlob
 |
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);
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);
•
•
Join Date: Dec 2007
Posts: 1,662
Reputation: 
Solved Threads: 224
I have never used these objects before but I can tell you that you get the exception because you don't instantiate the 'msg' object:
Blob msg; <-- it is null so when you write this:
msg.setBytes(1,msgval) --> you get the exception
Blob msg; <-- it is null so when you write this:
msg.setBytes(1,msgval) --> you get the exception
Check out my New Bike at my Public Profile at the "About Me" tab
•
•
•
•
Originally Posted by javaAddict 
I have never used these objects before but I can tell you that you get the exception because you don't instantiate the 'msg' object:
Blob msg; <-- it is null so when you write this:
msg.setBytes(1,msgval) --> you get the exception
how could I instantiate blob object.
•
•
Join Date: Dec 2007
Posts: 1,662
Reputation:
Solved Threads: 224
•
•
Join Date: Sep 2008
Posts: 1,574
Reputation:
Solved Threads: 199
You can't instantiate a 'Blob'. According to the API, it is an interface. You can, however, instantiate SerialBlob.
•
•
Join Date: Jun 2006
Posts: 7,615
Reputation:
Solved Threads: 466
> I want to insert byte array in database schema as follows
Where is this byte array coming from? If you are reading the contents of a file into a byte array which you are then trying to insert into the database, better use the methodsetBlob(int, InputStream, long) to avoid reading into a temporary byte array.
If it is a standalone byte array which you are trying to insert into the database, use the method specified above by wrapping the given byte array into a ByteArrayInputStream.
Something like:
Where is this byte array coming from? If you are reading the contents of a file into a byte array which you are then trying to insert into the database, better use the methodsetBlob(int, InputStream, long) to avoid reading into a temporary byte array.
If it is a standalone byte array which you are trying to insert into the database, use the method specified above by wrapping the given byte array into a ByteArrayInputStream.
Something like:
Java Syntax (Toggle Plain Text)
I don't accept change; I don't deserve to live.
|
Other Threads in the Java Forum
- Previous Thread: Java newbie needs help with arrays
- Next Thread: Recursive AVL Binary Search Tree
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Java Posts
- Today's Posts
- Unanswered Threads
911 addball addressbook android api append applet application apps array arrays automation binary bluetooth businessintelligence button card chat class client code collision component crashcourse css csv database eclipse ee error fractal free game gis givemetehcodez graphics gui html ide image input integer integration j2me japplet java javaarraylist javadoc javafx javaprojects jni jpanel julia jvm linux list loan loop machine map method methods migrate mobile netbeans newbie objects oriented output panel phone physics problem program programming project radio recursion reporting scanner se server service set sms socket software sort sql string swing test textfield threads transfer tree trolltech ubuntu utility windows
