Android SQLite database cursor iteration error -


i have sqlite database , when try loop through of records, error during iteration. have 900 records or in database , when gets record 217, (the integer gets 217, debugging purposes) error cursorwindow tag stating:

"failed read row 0, column 1 cursorwindow has 0 rows, 7 columns."

here code iteration through records:

string selectquery = "select * " + song_table_name; cursor c = null; try {     sqlitedatabase db = this.getreadabledatabase();     c = db.rawquery(selectquery, null);      //loop through rows , add list     if (c!= null) {         c.movetofirst();         int = 0;         {             system.out.println(i);             i++;              //do stuff...            } while (c.movetonext());       }   } {       if (c != null)           c.close();   }

thank you.

update: data song information. song name, artist, album stored strings. album art stored byte array (blob in database). 

songno=210 albumname=long live kings songname=proud stoner artistname=kottonmouth kings art=[b@42236c50 songno=211 albumname=koast ii koast songname=party artistname=kottonmouth kings art=[b@422ae498 songno=212 albumname=koast ii koast songname=where's weed @ artistname=kottonmouth kings art=[b@4231ac18 songno=213 albumname=high society songname=first class artistname=kottonmouth kings art=[b@422ae498 songno=214 albumname=cloud 9 songname=pass around artistname=kottonmouth kings art=[b@422d7be8 songno=215 albumname=rollin' stoned songname=rest of life artistname=kottonmouth kings art=[b@423451c0 songno=216 albumname=rollin' stoned songname=tangerine sky artistname=kottonmouth kings art=[b@42378ef8 songno=217 albumname=hidden stash iii [disc 1] songname=still smokin artistname=kottonmouth kings art=[b@423acc30 songno=218 albumname=get buck in here songname=get buck in here artistname=dj felli fel art=[b@422ae498 songno=219 albumname=best day ever songname=get up! artistname=mac miller art=[b@422f3138 songno=220 albumname=k.i.d.s songname=knock knock artistname=mac miller art=[b@4231ba98

now when ran it, got error on getting record 218. here relevant logcat.

03-24 12:57:22.799: i/system.out(15710): 210 03-24 12:57:22.809: d/dalvikvm(15710): gc_for_alloc freed 497k, 17% free 9941k/11928k, paused 14ms, total 15ms 03-24 12:57:22.809: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:22.809: i/system.out(15710): 211 03-24 12:57:22.829: d/dalvikvm(15710): gc_for_alloc freed 236k, 17% free 9941k/11928k, paused 15ms, total 15ms 03-24 12:57:22.839: d/dalvikvm(15710): gc_for_alloc freed 478k, 17% free 9941k/11928k, paused 15ms, total 15ms 03-24 12:57:22.839: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:22.919: w/cursorwindow(15710): window full: requested allocation 169783 bytes, free space 72617 bytes, window size 2097152 bytes 03-24 12:57:22.919: i/system.out(15710): 212 03-24 12:57:22.929: d/dalvikvm(15710): gc_for_alloc freed 478k, 17% free 9941k/11928k, paused 14ms, total 14ms 03-24 12:57:22.949: d/dalvikvm(15710): gc_for_alloc freed 433k, 17% free 9941k/11928k, paused 14ms, total 14ms 03-24 12:57:22.949: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:22.949: i/system.out(15710): 213 03-24 12:57:22.959: d/dalvikvm(15710): gc_for_alloc freed 434k, 17% free 9942k/11928k, paused 14ms, total 14ms 03-24 12:57:22.979: d/dalvikvm(15710): gc_for_alloc freed 448k, 17% free 9942k/11928k, paused 14ms, total 14ms 03-24 12:57:22.979: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:23.049: w/cursorwindow(15710): window full: requested allocation 447936 bytes, free space 172276 bytes, window size 2097152 bytes 03-24 12:57:23.049: i/system.out(15710): 214 03-24 12:57:23.069: d/dalvikvm(15710): gc_for_alloc freed 449k, 17% free 9942k/11928k, paused 14ms, total 14ms 03-24 12:57:23.069: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:23.139: w/cursorwindow(15710): window full: requested allocation 447936 bytes, free space 411808 bytes, window size 2097152 bytes 03-24 12:57:23.159: w/cursorwindow(15710): window full: requested allocation 2974082 bytes, free space 1223747 bytes, window size 2097152 bytes 03-24 12:57:41.767: i/system.out(15710): record number: 215215 03-24 12:57:44.460: d/dalvikvm(15710): gc_for_alloc freed 332k, 17% free 9942k/11928k, paused 25ms, total 26ms 03-24 12:57:46.342: d/dalvikvm(15710): gc_for_alloc freed 437k, 17% free 9942k/11928k, paused 25ms, total 26ms 03-24 12:57:46.572: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:48.224: i/system.out(15710): 216 03-24 12:57:52.478: d/dalvikvm(15710): gc_for_alloc freed 437k, 17% free 9943k/11928k, paused 24ms, total 25ms 03-24 12:57:54.290: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:57:57.333: i/system.out(15710): 217 03-24 12:58:05.340: d/dalvikvm(15710): gc_for_alloc freed 415k, 17% free 9943k/11928k, paused 24ms, total 25ms 03-24 12:58:08.363: d/skia(15710): --- skimagedecoder::factory returned null 03-24 12:58:12.087: w/cursorwindow(15710): window full: requested allocation 2974082 bytes, free space 594167 bytes, window size 2097152 bytes 03-24 12:58:12.087: w/cursorwindow(15710): window full: requested allocation 2974082 bytes, free space 2096591 bytes, window size 2097152 bytes 03-24 12:58:13.338: i/system.out(15710): 218 03-24 12:58:15.120: e/cursorwindow(15710): failed read row 0, column 1 cursorwindow has 0 rows, 7 columns. 03-24 12:58:16.772: e/cursorwindow(15710): failed read row 0, column 3 cursorwindow has 0 rows, 7 columns. 03-24 12:58:24.679: e/cursorwindow(15710): failed read row 0, column 2 cursorwindow has 0 rows, 7 columns. 03-24 12:59:15.048: e/cursorwindow(15710): failed read row 0, column 6 cursorwindow has 0 rows, 7 columns. 03-24 12:59:16.390: e/cursorwindow(15710): failed read row 0, column 5 cursorwindow has 0 rows, 7 columns. 03-24 12:59:40.583: w/dalvikvm(15710): threadid=11: thread exiting uncaught exception (group=0x4189cba8) 03-24 12:59:40.663: e/androidruntime(15710): fatal exception: asynctask #1 03-24 12:59:40.663: e/androidruntime(15710): process: com.allengauch.mediaplayer, pid: 15710 03-24 12:59:40.663: e/androidruntime(15710): java.lang.runtimeexception: error occured while executing doinbackground() 03-24 12:59:40.663: e/androidruntime(15710): @ android.os.asynctask$3.done(asynctask.java:300) 03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.futuretask.finishcompletion(futuretask.java:355) 03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.futuretask.setexception(futuretask.java:222) 03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.futuretask.run(futuretask.java:242) 03-24 12:59:40.663: e/androidruntime(15710): @ android.os.asynctask$serialexecutor$1.run(asynctask.java:231) 03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1112)  03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:587) 03-24 12:59:40.663: e/androidruntime(15710): @ java.lang.thread.run(thread.java:841) 03-24 12:59:40.663: e/androidruntime(15710): caused by: java.lang.illegalstateexception: couldn't read row 0, col 5 cursorwindow.  make sure cursor initialized correctly before accessing data it. 03-24 12:59:40.663: e/androidruntime(15710): @ android.database.cursorwindow.nativegetblob(native method) 03-24 12:59:40.663: e/androidruntime(15710): @ android.database.cursorwindow.getblob(cursorwindow.java:399)  03-24 12:59:40.663: e/androidruntime(15710): @ android.database.abstractwindowedcursor.getblob(abstractwindowedcursor.java:45) 03-24 12:59:40.663: e/androidruntime(15710): @ com.allengauch.mediaplayer.songsdatabase.getallsongs(songsdatabase.java:225)  03-24 12:59:40.663: e/androidruntime(15710): @ com.allengauch.mediaplayer.songsactivity$workerthread.doinbackground(songsactivity.java:252) 03-24 12:59:40.663: e/androidruntime(15710): @ com.allengauch.mediaplayer.songsactivity$workerthread.doinbackground(songsactivity.java:1)  03-24 12:59:40.663: e/androidruntime(15710): @ android.os.asynctask$2.call(asynctask.java:288) 03-24 12:59:40.663: e/androidruntime(15710): @ java.util.concurrent.futuretask.run(futuretask.java:237) 03-24 12:59:40.663: e/androidruntime(15710): ... 4 more


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more