Android Question Bitmap will not load (extracting from DB)

[chinku_chan]

Hi Good People,
I REALLY REALLY need help on this one. I've been stuck on this error for two days now and I just don't get it.

I have attached an image of where the error occurs. Basically I'm Creating a scrollview and other controls "dynamically" to which I then load various values (pulled from a SQLITE DB). Everything works fine except for when I attempt to initialize the Bitmap that will hold the Picture/Blob loaded from the DB.

FUNNY thing is, this "LastException java.lang.RuntimeException: Error Loading bitmap" error ONLY does not here. I placed a 'test' imageView on a random activity and have managed to load images from the DB successfully. I don't get why it wont work here.

PLEASE HELP. THANKS!!!

 

[Mahares]

I think your code is correct, but you need to position the cursor to the first record. See where I added the line for you.

Main.cur.Position=0  'Add this line
Dim Buffer() as Byte
Buffer=Main.cur.GetBlob(“Picture”)

 

[chinku_chan]

THANKS for your response

The cursor is already initialized to 0 initially (runs in a loop) so that works OK - as other tables values are successfully pulled from the DB.
So that is not the issue. It's just the IMAGE extraction that's the issue. PLEASE could you maybe take a look at my code and the comments I've put in.

Dim ListOfMaps As List
            ListOfMaps.Initialize
            Dim aMap As Map
                aMap.Initialize
                aMap.Put("ProductID", NewProdID)
                aMap.Put("Name", txtProdName.Text)
                aMap.Put("Size", txtSize.Text)
                aMap.Put("Price", txtPrice.Text)
                aMap.Put("Description", txtProdDes.Text)
                aMap.Put("Type", spType.SelectedItem)
                aMap.Put("ArtistID_fk", Main.globID)

                'THIS IS WHERE I INSERT THE IMAGE WHICH I LATER TRY TO EXTRACT. AM I DOING IT RIGHT?
                If picSelected Then
                    aMap.Put("Picture", imgSelected.Bitmap) 'THIS IS WHERE I INSERT THE IMAGE FROM GALLERY
                Else
                  imgSelected.Bitmap = LoadBitmap(File.DirAssets, "empty_gallery.png")
                  aMap.Put("Picture", imgSelected.Bitmap)
                End If
               
                ListOfMaps.Add(aMap)
       
            DBUtils.InsertMaps(Main.aSQL,Main.DBTableProduct, ListOfMaps)

'=================================================================================
'I USE THIS METHOD TO EXTRACT THE IMAGE AND THE ERROR OCCURS HERE

 Sub getImage
    Dim Buffer() As Byte
    Dim inpStream As InputStream
    Dim Bitmap1 As Bitmap
       
    Buffer = Null
   
    If Main.cur.Getstring("Picture") <> Null Then
        Buffer =  Main.cur.GetBlob("Picture")
    End If

    If Buffer = Null Then
       
    Else
        inpStream.InitializeFromBytesArray(Buffer, 0, Buffer.Length    )
        Bitmap1.Initialize2(inpStream) 'ERROR OCCURS HERE
    End If 
    inpStream.Close

End Sub

Thanks again

 

[Erel]

Your code is correct. How do you insert the image?

There is an example of inserting and fetching images from a database here: http://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content

 

[merlin2049er]

I've got the same problem.