[android-developers] Image doesn't appear from sqlite

Hi all.

I would like to save an image from Internet to database, I've tried to
convert images into bytearray and store them in a database.

Here my code:

this is to created table:
myDB.execSQL("CREATE TABLE IF NOT EXISTS News (Title VARCHAR(20),
imageUrl BLOB, publishDate TIMESTAMP, expiredDate TIMESTAMP);");

and this is my Method to Insert table:

public void insertlistNews(String city,byte[] newsImageUrl, String
publishDate, String expiredDate){
try {
myDB.execSQL("INSERT INTO News
(title,imageUrl,publishDate,expiredDate)"
+ " VALUES ('" + city + "','" + imageUrl + "','" + publishDate+
"','" + expiredDate"');");
Log.i("Android", "Table created");
} catch (Exception e) {
Log.i("Android", "No Table created" + e.getMessage());
}
//for check bytearray in database
Log.i("Android", "Image saved in database: "+ urlFrontImage);
}

The last my method for getNews from db:

public ArrayList getAllNews() {
ArrayList news = new ArrayList<News>();
Cursor c = myDB.rawQuery("SELECT
title,imageUrl,publishDate,expiredDate
FROM News WHERE publishedDate <= DATETIME() and expiredDate >=
DATETIME() ORDER BY publishedDate DESC;", null);
if (c != null) {
c.moveToFirst();
int count = 0;
while (c.moveToNext()) {
if (count == 0)
c.moveToFirst();
String title = c.getString(0);
byte[] image = c.getBlob(1);
String publishDate = c.getString(2);
String expiredDate = c.getString(3);

NewsItem nl = new NewsItem(title, image, publishDate, expiredDate);

Log.i("Android", "Image get from db: "+image);
news.add(nl);
count++;
}
}
return news;
}

when I run it the newsimage not appear and the Log like this:

12-22 00:11:49.362: INFO/Android(307): Image saved in database:
[B@437cbdb8
12-22 00:11:51.052: INFO/Android(307): Image saved in database:
[B@437db710
12-22 00:11:51.862: INFO/Android(307): Image saved in database:
[B@437c1338

12-22 00:12:07.962: INFO/Android(307): Image get from db: [B@4382d370
12-22 00:12:07.982: INFO/Android(307): Image get from db db:
[B@4382d9c0
12-22 00:12:07.992: INFO/Android(307): Image get from db: [B@4382e0e0

why results can vary between insert and getNews?

--
Best Regards

=====
Amiral

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en