 |  |  |  |  |  |  |  |
About setBLOb & getBlob
Please support our Java advertiser: Programming Forums - DaniWeb Sister Site
 |
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,698
Reputation: 
Solved Threads: 227
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,698
Reputation:
Solved Threads: 227
•
•
Join Date: Sep 2008
Posts: 1,625
Reputation:
Solved Threads: 205
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,635
Reputation:
Solved Threads: 469
> 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.
Jo Tujhe Jagaaye, Nindein Teri Udaaye Khwaab Hai Sachcha Wahi.
Nindon Mein Jo Aaye Jise To Bhul Jaaye Khawab Woh Sachcha Nahi.
Khwaab Ko Raag De, Nind Ko Aag De
Jo Tujhe Jagaaye, Nindein Teri Udaaye Khwaab Hai Sachcha Wahi.
Nindon Mein Jo Aaye Jise To Bhul Jaaye Khawab Woh Sachcha Nahi.
Khwaab Ko Raag De, Nind Ko Aag De
|
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 |
Latest Java Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Java
android api apple applet application arc arguments array arrays automation binary bluetooth c++ chat class classes client code codesnippet component csv database doctype draw ebook eclipse error event exception fractal freeze game givemetehcodez graphics gui html ide image input integer intellij iphone j2me java java.xls javaprojects jni jpanel jtable julia linux list loop loops mac map method methods mobile netbeans newbie number online oracle page parameter plazmic print problem program programming project recursion reporting rotatetext scanner screen sell server set size sms socket sort sourcelabs sql string superclass swing system template test testautomation threads time title tree tutorial-sample windows working
