Android insert image into DB

Question

I'm new to Android development and I'm trying to insert an image into a database but its not working. Below is some of my code:

On click Code

public void click(View v){
        img= DatabaseHandler.getBytes(BitmapFactory.decodeResource(getResources(), R.drawable.test));

         DatabaseHandler.insertFood("test","test",10.00,img);
         Toast toast =  Toast.makeText(getApplicationContext(), "TEST", Toast.LENGTH_LONG);
        toast.show();

    }

DatabaseHandler Class

   public static long insertFood( String Name, String Description, Double Price,Byte[] Image ){
        ContentValues cv = new ContentValues();
        cv.put(nam,Name);
        cv.put(descrp, Description);
        cv.put(prc, Price);
        cv.put(img, Image);
        return sdb.insert(TABLE, null, cv);
    }
    public static byte[] getBytes(Bitmap bitmap) {
          ByteArrayOutputStream stream = new ByteArrayOutputStream();
          bitmap.compress(CompressFormat.PNG, 0, stream);
          return stream.toByteArray();
         }

The error
enter image description here

Image 2 enter image description here

where is the lower case "price" / "description" coming from? global constants? Also you need a String key for image. You appear to be using lower case "image" as both key and value. — NameSpace
– NameSpace, Commented Feb 7, 2014 at 2:16
well look at where you are putting image, you have the same variable twice. The first one needs to be the string key, the second the byte array. — NameSpace
– NameSpace, Commented Feb 7, 2014 at 2:22
Could you extend the error stack trace to "Cause by: blabla" from your LogCat? The current LogCat doesn't really help. — Andrew T.
– Andrew T., Commented Feb 7, 2014 at 2:33
Your database variable (sdb) is null. That's the problem. You need to post the code where your opening the database if you need further help. p.s. you'll run into null pointers and similar problems a ton, look on the logcat for the line that relates to code in your program (e.g. line 82 of DatabaseHandler), to find these errors. just double click it, and it will take you right to that line. — NameSpace
– NameSpace, Commented Feb 7, 2014 at 2:45

NameSpace · Accepted Answer · 2014-02-07 03:01:19Z

1

OP just needed to post a longer stack trace, to see he was trying to insert to a null database. Credit to Andrew T. for asking user to post the longer trace.

answered Feb 7, 2014 at 3:01

NameSpace

10.2k3 gold badges42 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android insert image into DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related