"Unable to re-open an already closed object", when reading data from sqlite android -

-

itemprop = "text">

In my Android app, I am using SQLite database but when I use a query to read data from SQLite So, I get an error. This is my code to create the table. 

  package com.example.mydb; Public class Dbadapter {Private static final string DATABASE_NAME = "mydb"; Personal Static FINAL END DATABASE_VERSION = 5; Private static final string DATABASE_TABLE18 = "modalation_medicine_table"; Private static final string MOD_ID = "modalation_previousss_id"; Private static final string MOD_MED_ID = "modalation_medicine_id"; Private static final string MOD_MEDICINE = "modalation_medicine"; Private static final String CREATE_DATABASE_TABLE18 = "Table does not exist to create" + DATABASE_TABLEl8 + "(" + MOD_MED_ID + "integer primary key autoincrement," + MOD_MEDICINE + "text" + MOD_ID + "integer" + "foreign key ( '+ MOD_ID + ") reference" "+ DATABASE_TABLE5 +" ( "+ MODALATION_KEY_ID +));"; private DbHelper our Heller; private final terms of our model, private SQLiteDatabase ourDatabase; private static class DbHelper SQLiteOpenHelper {public DbHelper (references) {max ( Reference, DATABASE_NAME, blank, DATABASE_VERSION) extends; // Tudo Auto-Generated Console Trctor stub} @ Override public Whaid on Create (SQLiteDatabase db) {db.execSQL (CREATE_DATABASE_TABLE18); materials price modalation_medicine = new content value (); Modalation_medicine.put (MOD_MEDICINE, "Ntrram Muriyatikm"); Modalation_medicine.put (MOD_ID, 1 ); Db.insert (DATABASE_TABLE18, tap, modalation_medicine); Modalation_medicine.put (MOD_MEDICINE, "Kalivera carbonica"); Modalation_medicine.put (MOD_ID, 1); Db.insert (DATABASE_TABLE18, tap, modalation_medicine); Modalation_medicine.put (MOD_MEDICINE, "Phosphorus"); Modalation_medicine.put (MOD_ID, 1); Db.insert (DATABASE_TABLE18, faucet, modalation_medicine); } @Override public void onUpgrade (SQLiteDatabase db, int oldVersion, integer NewVersion) {// TODO Auto-generated method stub db.execSQL ( "drop table if one exists" + DATABASE_TABLE18); }} Public Dbadapter (reference c) {ourContext = c; } Public Dbadapter throws open () SQLException {ourHelper = new DBHelper (ourContext); OurDatabase = ourHelper.getWritableDatabase (); This return; } Public Zero Closure () {ourHelper.close (); }

Now, when my method is using this method to read the data from sqlite db, then give me an error "unable to open the previously closed object again" 

  public boolean mod_app_symps (string l, string modfinalMed) {String [] modalation = new string [] {MOD_ID, MOD_MEDICINE}; Cursor C24; Boolean iscontain = false; C24 = ourDatabase.query (DATABASE_TABLE18, modalation, "modalation_previousss_id = and modalation_medicine =?", New String [] {L, modfinalMed}, null, null, null); If (c24.getCount ()> gt; {iscontain = true; } Return iscontain; }

I tried to solve this problem through Google but did not help anything! PS: I have read many other ways that are doing the same thing from I SQLite db, and all of these work fine. The error is only coming to this method.

Edit: This method works well 

  public string [] getmodMed (long L) {string [] modalation_med = new string [] {MOD_ID, MOD_MEDICINE} ; Cursor C19 = ourDatabase.query (DATABASE_TABLE18, modalation_med, MOD_ID + '=' + + + l + "'', zero, null, null, null); String mod_medicine [] = new string [c19.getCount ()]; Int Imodedicine = C19 .get Cologum Index (MOD_medicin); If (c19! = Null) {c19.moveToFirst (); While (! C19.isAfterLast ()) {for (int i = 0; i & lt; c19.getcount (); i ++) {mod_medicine [i] = c19.getString (emod medicine); C19.moveToNext (); }}} Return mod_medicine; }

This is caused by this line of code: 

  Public Zero Closure () {ourHelper.close (); }

You close a database and then want to log in again.


Comments

Post a Comment

Popular posts from this blog

HTML/CSS - Automatically set height width from background image? -

-
Long time ... I do not think it's possible, but I'm shocked before! I tag anchor tags, all of which are background images, all 300px wide but their height is all the difference, is it really set to do without typing altitude? Is it to set the dimensions of BG URL? Thank you! I do not think people understand - my mistake is to hurry the question. Here is the code as an example: # ago -1 {width: 300px; Height: 410px; Background: url ('/ image-1.jpg');} # East -2 {width: 300px; Height: 420px; Background: url ('/ image-2.jpg');} # Pre-3 {width: 300px; Height: 430px; Background: url ('/ image-3.jpg');} # Pre-4 {width: 300px; Height: 440px; Background: url ('/ image-3.jpg');} & lt; A href = "#" id = "ex-1" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "ex-2" & gt; & Lt; / A & gt; & Lt; A href = "#" id = "pre-3" & gt; & Lt; / A & gt...
Read more

php - Mysql Show Process - Sleep Commands and what to do -

-
I am thinking that there is something that I can do better so that my process list should start with the command with MySQL Be clear Currently I am looking for a lot: 17325 user_a localhost db_1 sleep 1132 NULL 17464 user_a localhost db_1 sleep 1124 NULL 17983 user_a localhost db_1 sleep 1078 null 18113 user_a localhost db_1 sleep 1068 NULL 18207 user_a localhost db_1 sleep 1060 NULL 18231 user_a localhost db_1 sleep 1058 NULL 18353 user_a localhost db_1 sleep 1047 NULL 18447 user_a localhost db_1 sleep 1040 null 18489 user_a localhost db_1 sleep 1036 NULL 23408 user_a localhost db_1 sleep 637 NULL Something in my phpscript is that I want to clean it Can i The script looks like: Select the ID from $ q = 'db_1 where fkId = 2'; $ Ar = mysql_query ($ q); ($ Line = mysql_fetch_array ($ qr)) {echo ($ row ['id'];} Thanks in advance! I'm guessing that when you have 10 threads, you're constantly using the connectio...
Read more

c - What is the address of buf (the local variable in the main function)? -

-
I had exercise with programming in c or classes and I followed the question: Is Buf (local variable in main function)? Either enter the answer in hexadecimal format (like 0x 8 "digits" 0-9 or A-F, 0xbfff0014) or in decimal format. Note here that we want the address of the buff, not its content. The code looks like this: int main (int argc, char * argv []) {while (1) {four buff [1024] = {0}; Int r; .... I then started the code and put the built code in the buff [1024] line and in Typed Gdb p & amp; Buf and it gives me results: 0xbffff0f0 But when I use it in this quiz it gives me the result that this value is wrong. My question is this: Is this the name of the Buff variable (P & E)? Or if not, why not? Exercise is done on the virtualbox machine, so I think everyone should be the same address There is no correct numerical answer, the address may vary from one time to another, it is a programming drill that you say the following three...
Read more