convert byteArray to bitmap retrieved from sqlite

Question

I am trying to save image in sqlite database and then retrieve it later. I have stored it in form of byte[]. BUt bitmap is not being formed!

Storing images: (blob type)

Drawable myDrawable = getResources().getDrawable(arr[i]);
myLogo = ((BitmapDrawable) myDrawable).getBitmap();
ByteArrayOutputStream stream = new ByteArrayOutputStream();
myLogo.compress(Bitmap.CompressFormat.JPEG, 100, stream);
b = stream.toByteArray();

My code for retrieving:

byte[] Image;
Image = c.getBlob(c.getColumnIndex("img_str"));
BitmapFactory.Options options = new BitmapFactory.Options();
decodedByte = BitmapFactory.decodeByteArray(Image, 0,Image.length, options);
arr_img.add(decodedByte);

System.out.println("Image = " + Image);
System.out.println("decodedByte = " + decodedByte);

Logcat:

07-22 07:15:55.482: D/skia(19319): --- SkImageDecoder::Factory returned null
07-22 07:15:55.482: I/System.out(19319): Image = [B@4057ea48
07-22 07:15:55.482: I/System.out(19319): decodedByte = null
07-22 07:15:55.521: D/dalvikvm(19319): GC_EXPLICIT freed 114K, 50% free 2871K/5639K,external 5406K/5783K, paused 43ms
07-22 07:15:55.541: D/skia(19319): --- SkImageDecoder::Factory returned null
07-22 07:15:55.541: I/System.out(19319): Image = [B@40577aa0
07-22 07:15:55.541: I/System.out(19319): decodedByte = null

please help as i am clueless why this is not working. thanks

why are you storing image in db? You could simply store the location of the image file in DB instead of the complete image. — Rajeev, Jul 22 '13 at 08:12
i am storing image prepopulated database. the app will just display it! — Carbon, Jul 22 '13 at 08:15
Refer this for storing images and retrieving images.[Refer][1] [Refer This][2] [1]:http://stackoverflow.com/questions/7620401/how-to-convert-byte-array-to-bitmap [2]:http://stackoverflow.com/questions/11790104/how-to-storebitmap-image-and-retrieve-image-from-sqlite-database-in-android — Aravin, Jul 22 '13 at 08:15
Are you sure the images have been encoded in the same way that you are trying to decode them? — npace, Jul 22 '13 at 08:17
I did not encode the images.. please have a look at the edit — Carbon, Jul 22 '13 at 08:20

ObieMD5 · Answer 1 · 2013-07-22T08:29:52.070

1

Your image bytes are very small. Are you sure that is the whole image? Accoring to your output the image is only 22 bytes and that is small. I only say this because the API states:

Returns The decoded bitmap, or null if the image could not be decode.

I believe that image is not as large as it is supposed to be.

Try to store your image again in the database with this code and try to retrieve again:

Bitmap myLogo = BitmapFactory.decodeResource(getResources(), R.drawable.yourBitmap);
ByteArrayOutputStream stream = new ByteArrayOutputStream();
myLogo.compress(Bitmap.CompressFormat.JPEG, 100, stream);
b = stream.toByteArray();

edited Jul 22 '13 at 08:29

answered Jul 22 '13 at 08:12

ObieMD5

2,684
1
16
26

i think it is the whole image. because when i was encoding it in Base64.encodeBytes(b); the entire image was displaying – Carbon Jul 22 '13 at 08:14
how did you obtain the bytes from the image? – ObieMD5 Jul 22 '13 at 08:18
I took the image from the R.drawable folder and converted them into bytes. please have a look at the edit – Carbon Jul 22 '13 at 08:21
try my new response @Pooja – ObieMD5 Jul 22 '13 at 08:33

score 0 · Accepted Answer · answered Aug 02 '13 at 06:19

Actually the problem was not with the conversion but the way how i was storing it..

I used prepared statement to insert values.. bindBlob() did the job

String sql = "INSERT INTO demoImage (img_name,img_str) VALUES(?,?)";

    SQLiteStatement insertStmt = dbsqlite.compileStatement(sql);
    insertStmt.clearBindings();
    insertStmt.bindString(1, name);
    insertStmt.bindBlob(2, bal);
    insertStmt.executeInsert();

convert byteArray to bitmap retrieved from sqlite

2 Answers2

Related