Problem in my application

[Sarra Sakka]

I used a database "Login" in my application android. This application must work in my tablette, but when i install .apk in my tablette all the data of my data base dissapear !!!
I don't know what's the problem exactly, i need your help
here's my code for database:

package com.application.login;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;


import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;


public class DataBaseLoginHelper  extends SQLiteOpenHelper {
	
	
	//le tableau 
	private static final String TABLE_IDENTIFIANT="table_identifiant";
	

	private static final String COL_ID = "id_";
	private static final String COL_NAME = "name";
	private static final String COL_PASSWORD = "password";
	
	private static final String CREATE_BD_IDENTIFIANT="CREATE TABLE "
		    + TABLE_IDENTIFIANT + " (" +
		    COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
		    COL_NAME + " TEXT NOT NULL, " +
		    COL_PASSWORD + " REAL NOT NULL );" ;

	 private static String DB_PATH = "/data/data/com.application.activity/databases/";
	 
	    private static String DB_NAME = "Login";
	 
	    private SQLiteDatabase myDataBase; 
	 
	    private final Context myContext;
	    
	    private static DataBaseLoginHelper DBHelper;
	    
	    public DataBaseLoginHelper(Context c) {
            super(c, DB_NAME, null,1);
            myContext = c;
        }
	    public void createDataBase() throws IOException{
	   	 
	    	boolean dbExist = checkDataBase();
	 
	    	if(dbExist){
	    		//do nothing - database already exist
	    	}else{
	 
	    		//By calling this method and empty database will be created into the default system path
	               //of your application so we are gonna be able to overwrite that database with our database.
	        	this.getReadableDatabase();
	 
	        	try {
	 
	    			copyDataBase();
	 
	    		} catch (IOException e) {
	 
	        		throw new Error("Error copying database");
	 
	        	}
	    	}
	 
	    }
	 
	    /**
	     * Check if the database already exist to avoid re-copying the file each time you open the application.
	     * @return true if it exists, false if it doesn't
	     */
	    private boolean checkDataBase(){
	 
	    	SQLiteDatabase checkDB = null;
	 
	    	try{
	    		String myPath = DB_PATH + DB_NAME;
	    		checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
	 
	    	}catch(SQLiteException e){
	 
	    		//database does't exist yet.
	 
	    	}
	 
	    	if(checkDB != null){
	 
	    		checkDB.close();
	 
	    	}
	 
	    	return checkDB != null ? true : false;
	    }
	 
	    /**
	     * Copies your database from your local assets-folder to the just created empty database in the
	     * system folder, from where it can be accessed and handled.
	     * This is done by transfering bytestream.
	     * */
	    private void copyDataBase() throws IOException{
	 
	    	//Open your local db as the input stream
	    	InputStream myInput = myContext.getAssets().open(DB_NAME);
	 
	    	// Path to the just created empty db
	    	String outFileName = DB_PATH + DB_NAME;
	 
	    	//Open the empty db as the output stream
	    	OutputStream myOutput = new FileOutputStream(outFileName);
	 
	    	//transfer bytes from the inputfile to the outputfile
	    	byte[] buffer = new byte[1024];
	    	int length;
	    	while ((length = myInput.read(buffer))>0){
	    		myOutput.write(buffer, 0, length);
	    	}
	 
	    	//Close the streams
	    	myOutput.flush();
	    	myOutput.close();
	    	myInput.close();
	 
	    }
	 
	    public void open() throws SQLException{
	 
	    	//Open the database
	        String myPath = DB_PATH + DB_NAME;
	    	myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
	 
	    }
	 
	    @Override
		public synchronized void close() {
	 
	    	    if(myDataBase != null)
	    		    myDataBase.close();
	 
	    	    super.close();
	 
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			// TODO Auto-generated method stub
			db.execSQL(CREATE_BD_IDENTIFIANT);

		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			// TODO Auto-generated method stub
			db.execSQL("DROP TABLE IF EXISTS "+ TABLE_IDENTIFIANT);
			onCreate(db);
		}
		 //détermine l'identifiant du serveur  
	    public ArrayList <Integer> getIdentifiant() 
	    {
	    	ArrayList <Integer> tab = new ArrayList <Integer>();
	    	myDataBase = DBHelper.getReadableDatabase();
	    	
	    	try
	    	{	
	    	Cursor c =null;
	    	c = myDataBase.rawQuery("SELECT " + COL_ID + " FROM "
	    	    	+ TABLE_IDENTIFIANT, null);
	    	       
	    	if(c.moveToFirst()){
	    	        
	    		for(int i=0;i<c.getCount();i++)
	    	        {
	    			
	    			int x= c.getInt(c.getColumnIndex(COL_ID)) ;
	    			tab.add(x);
	    	            c.moveToNext();
	    	          }
	    	        c.close();
	    	        myDataBase.close();
	                }
	    	}
	    	catch(Exception e)
	        {
	            e.printStackTrace();
	        }

	            return tab;
	    	}
	    
	    //determine le password 

	    public ArrayList <Double> getPassword() 
	    {
	    	ArrayList <Double> tab = new ArrayList <Double>();
	    	myDataBase = DBHelper.getReadableDatabase();
	    	
	    	try
	    	{	
	    	Cursor c =null;
	    	c = myDataBase.rawQuery("SELECT " + COL_PASSWORD + " FROM "
	    	    	+ TABLE_IDENTIFIANT, null);
	    	       
	    	if(c.moveToFirst()){
	    	        
	    		for(int i=0;i<c.getCount();i++)
	    	        {
	    			
	    			double x= c.getDouble(c.getColumnIndex(COL_PASSWORD)) ;
	    			tab.add(x);
	    	            c.moveToNext();
	    	          }
	    	        c.close();
	    	        myDataBase.close();
	                }
	    	}
	    	catch(Exception e)
	        {
	            e.printStackTrace();
	        }

	            return tab;
	    	}
	    

}

and here's the activity :

package com.application.login;

import java.io.IOException;
import java.util.ArrayList;

import android.app.ActionBar;
import android.app.Activity;
import android.app.Dialog;
import android.content.Intent;
import android.database.SQLException;
import android.graphics.Typeface;
import android.os.Bundle;
import android.view.MotionEvent;
import android.view.View;
import android.view.View.OnTouchListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.TextView;

import com.application.activity.R;

public class Login extends Activity  implements View.OnClickListener{
	
	ArrayList<Integer> tabid = new ArrayList <Integer>();
	ArrayList <Double> tabpass = new ArrayList <Double>();
	Button login;
	Button cancel;
	EditText id;
	EditText pass;
	int n= tabid.size();
	int m= tabpass.size();

	ImageView ivConnection = null;
	Typeface font = null;
	
	
	
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.login);

    

		DataBaseLoginHelper db = new DataBaseLoginHelper(this);
        
		 try {
			 
	        	db.createDataBase();
	 
	 	} catch (IOException ioe) {
	 
	 		throw new Error("Unable to create database");
	 
	 	}
	 
	 	try {
	 
	 		db.open();
	 
	 	}catch(SQLException sqle){
	 
	 		throw sqle;
	 
	 	}

		tabid = db.getIdentifiant();//tableau contient de tout les identifiant 
		tabpass = db.getPassword();//tableau contient tout les mot de passe
	
		initialize();

		login.setOnClickListener(this);
		cancel.setOnClickListener(this);
		
		db.close();
		manageActionBar();
	}

	private void initialize() {
		// TODO Auto-generated method stub
		login =(Button) findViewById(R.id.blogin);
		cancel =(Button) findViewById(R.id.bcancel);
		id = (EditText) findViewById(R.id.edtid);
		pass = (EditText) findViewById(R.id.edtpassword);

	}
	
	private void manageActionBar() {
		final ActionBar actionBar = getActionBar();
		actionBar.setCustomView(R.layout.header);
		actionBar.setDisplayShowTitleEnabled(false);
		actionBar.setDisplayShowCustomEnabled(true);
		actionBar.setDisplayShowHomeEnabled(false);
		ivConnection = (ImageView) findViewById(R.id.ivConnection);
		ivConnection.setOnTouchListener(new OnTouchListener() {
			@Override
			public boolean onTouch(View arg0, MotionEvent arg1) {
				ivConnection.setSelected(arg1.getAction() == MotionEvent.ACTION_DOWN);
				return true;
			}
		});
	}
	

	@Override
	public void onClick(View v) {
		// TODO Auto-generated method stub
		switch(v.getId())
		{
		case R.id.blogin:
			

			boolean didItWork=true;
			
			
				String editid = id.getText().toString();
				String editpass = pass.getText().toString();
				didItWork = Verif(editid,editpass);
				if (didItWork)
				{
					
					Intent i = new Intent("com.application.activity.MainActivity");
					startActivity(i);
				}
			
				else {
					Dialog d = new Dialog(this);
					d.setTitle("Error!");
					TextView tv = new TextView(this);
					tv.setText("Error !! check your data");
					d.setContentView(tv);
					d.show();
				}
			
			break;
			
		case R.id.bcancel:
			
			id.setText("");
			pass.setText("");
			
			break;
		
		}
	}
public boolean Verif(String editid,String editpass){
		
		boolean verif = false ;
		double id =Double.parseDouble(editid);
		double pass =Double.parseDouble(editpass);

		for(int i=0; i<tabid.size(); i++)
		{
			if ((id == tabid.get(i)) &&(pass == tabpass.get(i)))
			{
				verif = true;
				break;
			
		}
			}
		return verif;
	}
}

[Sarra Sakka]

Sorry, i put another code which i change it
the problem is when i debug or i run the application doesn't work

[Sarra Sakka]

here's the logcat what's display :

09-11 15:34:55.731: E/AndroidRuntime(2469): FATAL EXCEPTION: main
09-11 15:34:55.731: E/AndroidRuntime(2469): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.application.activity/com.application.login.Login}: java.lang.NullPointerException
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.os.Handler.dispatchMessage(Handler.java:99)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.os.Looper.loop(Looper.java:137)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread.main(ActivityThread.java:5039)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at java.lang.reflect.Method.invokeNative(Native Method)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at java.lang.reflect.Method.invoke(Method.java:511)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at dalvik.system.NativeStart.main(Native Method)
09-11 15:34:55.731: E/AndroidRuntime(2469): Caused by: java.lang.NullPointerException
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at com.application.login.DataBaseLoginHelper.getIdentifiant(DataBaseLoginHelper.java:166)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at com.application.login.Login.onCreate(Login.java:67)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.Activity.performCreate(Activity.java:5104)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
09-11 15:34:55.731: E/AndroidRuntime(2469): 	... 11 more

[Ulf Dittmer]

It seems that there is only a single object in line 166 of DataBaseLoginHelper which could be null. Where in the code are you assigning it a value?

[Sarra Sakka]

I change the line 166 by

	    	myDataBase = getReadableDatabase();

The interface display, but there's always an error
here's the logcat :

09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread.access$600(ActivityThread.java:141)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.os.Handler.dispatchMessage(Handler.java:99)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.os.Looper.loop(Looper.java:137)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread.main(ActivityThread.java:5039)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at java.lang.reflect.Method.invokeNative(Native Method)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at java.lang.reflect.Method.invoke(Method.java:511)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at dalvik.system.NativeStart.main(Native Method)
09-12 00:30:30.178: E/AndroidRuntime(722): Caused by: java.lang.NullPointerException
09-12 00:30:30.178: E/AndroidRuntime(722): 	at com.application.database.DataBaseHelper.getPathImage(DataBaseHelper.java:362)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at com.application.activity.MainActivity.putLinearLayoutCategory(MainActivity.java:160)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at com.application.activity.MainActivity.onCreate(MainActivity.java:79)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.Activity.performCreate(Activity.java:5104)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
09-12 00:30:30.178: E/AndroidRuntime(722): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
09-12 00:30:30.178: E/AndroidRuntime(722): 	... 11 more

[Ulf Dittmer]

NullPointerExceptions are relatively easy to debug - they even tell you the line number on which you're trying to invoke a method on a null object reference. With that knowledge, it shouldn't be hard to figure out which object is null. You can either use a debugger, or do some logcat logging at relevant locations throughout the code.

[Sarra Sakka]

When i debug, it display "source not found"

[Sarra Sakka]

I can not determine the error

[Steve Luke]

If you look at the stack trace you posted, which class do you think the error comes from? What line of code?

[Maneesh Godbole]

09-12 00:30:30.178: E/AndroidRuntime(722): Caused by: java.lang.NullPointerException  
09-12 00:30:30.178: E/AndroidRuntime(722):  at com.application.database.DataBaseHelper.getPathImage(DataBaseHelper.java:362)  

Check line 362 in your DataBaseHelper. Like Ulf mentioned one of the variables is null

[Sarra Sakka]

Ok, thanks
it's work now

[Sarra Sakka]

BUt , when i install .apk in my tablet doesn't work .
according to you, why it doesn't work ?

[Ulf Dittmer]

Maybe because you didn't fix the cause of the exception?

[Sarra Sakka]

where exactly?

[Ulf Dittmer]

The NullPointerException. Did what Maneesh, Steve and I said make sense to you?

[Sarra Sakka]

I didn't understand you

[Ulf Dittmer]

OK. What *did* you understand? Did you notice that the error message tells you exactly in which class and in which line of code the problem occurred?

[Sarra Sakka]

yes, i understand that.
But, after i change my code the application works without error
here's the new code :

package com.application.login;

import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;


import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;


public class DataBaseLoginHelper  extends SQLiteOpenHelper {
	
	
	//le tableau 
	private static final String TABLE_IDENTIFIANT="table_identifiant";
	

	private static final String COL_ID = "id_";
	private static final String COL_NAME = "name";
	private static final String COL_PASSWORD = "password";
	
	private static final String CREATE_BD_IDENTIFIANT="CREATE TABLE "
		    + TABLE_IDENTIFIANT + " (" +
		    COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
		    COL_NAME + " TEXT NOT NULL, " +
		    COL_PASSWORD + " REAL NOT NULL );" ;

	 private static String DB_PATH = "/data/data/com.application.activity/databases/";
	 
	    private static String DB_NAME = "Login";
	 
	    private SQLiteDatabase myDataBase; 
	 
	    private final Context myContext;
	    
	    
	    public DataBaseLoginHelper(Context c) {
            super(c, DB_NAME, null,1);
            myContext = c;
        }
	    public void createDataBase() throws IOException{
	   	 
	    	boolean dbExist = checkDataBase();
	 
	    	if(dbExist){
	    		//do nothing - database already exist
	    	}else{
	 
	    		//By calling this method and empty database will be created into the default system path
	               //of your application so we are gonna be able to overwrite that database with our database.
	        	this.getReadableDatabase();
	 
	        	try {
	 
	    			copyDataBase();
	 
	    		} catch (IOException e) {
	 
	        		throw new Error("Error copying database");
	 
	        	}
	    	}
	 
	    }
	 
	    /**
	     * Check if the database already exist to avoid re-copying the file each time you open the application.
	     * @return true if it exists, false if it doesn't
	     */
	    private boolean checkDataBase(){
	 
	    	SQLiteDatabase checkDB = null;
	 
	    	try{
	    		String myPath = DB_PATH + DB_NAME;
	    		checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
	 
	    	}catch(SQLiteException e){
	 
	    		//database does't exist yet.
	 
	    	}
	 
	    	if(checkDB != null){
	 
	    		checkDB.close();
	 
	    	}
	 
	    	return checkDB != null ? true : false;
	    }
	 
	    /**
	     * Copies your database from your local assets-folder to the just created empty database in the
	     * system folder, from where it can be accessed and handled.
	     * This is done by transfering bytestream.
	     * */
	    private void copyDataBase() throws IOException{
	 
	    	//Open your local db as the input stream
	    	InputStream myInput = myContext.getAssets().open(DB_NAME);
	 
	    	// Path to the just created empty db
	    	String outFileName = DB_PATH + DB_NAME;
	 
	    	//Open the empty db as the output stream
	    	OutputStream myOutput = new FileOutputStream(outFileName);
	 
	    	//transfer bytes from the inputfile to the outputfile
	    	byte[] buffer = new byte[1024];
	    	int length;
	    	while ((length = myInput.read(buffer))>0){
	    		myOutput.write(buffer, 0, length);
	    	}
	 
	    	//Close the streams
	    	myOutput.flush();
	    	myOutput.close();
	    	myInput.close();
	 
	    }
	 
	    public void open() throws SQLException{
	 
	    	//Open the database
	        String myPath = DB_PATH + DB_NAME;
	    	myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
	 
	    }
	 
	    @Override
		public synchronized void close() {
	 
	    	    if(myDataBase != null)
	    		    myDataBase.close();
	 
	    	    super.close();
	 
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			// TODO Auto-generated method stub
			db.execSQL(CREATE_BD_IDENTIFIANT);

		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			// TODO Auto-generated method stub
			db.execSQL("DROP TABLE IF EXISTS "+ TABLE_IDENTIFIANT);
			onCreate(db);
		}
		 //détermine l'identifiant du serveur  
	    public ArrayList <Integer> getIdentifiant() 
	    {
	    	ArrayList <Integer> tab = new ArrayList <Integer>();
	    	myDataBase = getReadableDatabase();
	    	
	    	try
	    	{	
	    	Cursor c =null;
	    	c = myDataBase.rawQuery("SELECT " + COL_ID + " FROM "
	    	    	+ TABLE_IDENTIFIANT, null);
	    	       
	    	if(c.moveToFirst()){
	    	        
	    		for(int i=0;i<c.getCount();i++)
	    	        {
	    			
	    			int x= c.getInt(c.getColumnIndex(COL_ID)) ;
	    			tab.add(x);
	    	            c.moveToNext();
	    	          }
	    	        c.close();
	    	        myDataBase.close();
	                }
	    	}
	    	catch(Exception e)
	        {
	            e.printStackTrace();
	        }

	            return tab;
	    	}
	    
	    //determine le password 

	    public ArrayList <Double> getPassword() 
	    {
	    	ArrayList <Double> tab = new ArrayList <Double>();
	    	myDataBase = getReadableDatabase();
	    	
	    	try
	    	{	
	    	Cursor c =null;
	    	c = myDataBase.rawQuery("SELECT " + COL_PASSWORD + " FROM "
	    	    	+ TABLE_IDENTIFIANT, null);
	    	       
	    	if(c.moveToFirst()){
	    	        
	    		for(int i=0;i<c.getCount();i++)
	    	        {
	    			
	    			double x= c.getDouble(c.getColumnIndex(COL_PASSWORD)) ;
	    			tab.add(x);
	    	            c.moveToNext();
	    	          }
	    	        c.close();
	    	        myDataBase.close();
	                }
	    	}
	    	catch(Exception e)
	        {
	            e.printStackTrace();
	        }

	            return tab;
	    	}
	    

}

[Sarra Sakka]

The problem is when i install it in my tablet doesn't work

[Ulf Dittmer]

What does "doesn't work" mean? TellTheDetails.

[Sarra Sakka]

All the data of my database is lost.

[Sarra Sakka]

I think that the problem is here :

	    	myDataBase= getReadableDatabase();

in the two method.
How can i correct it ? Do you have any idea?
thanks in advance

[Steve Luke]

First, you shouldn't have to 'think' the problem is somewhere, you need to know where it is - by correctly logging errors and viewing those logs. Don't print stacktraces because you probably won't be able to see them. Instead, use Log.e(...) to log the results so you can view them in LogCat.

Second, you should read your logs so you can tell if there is something going wrong that isn't crashing the application, but still logs as an error. There will be one (and I bet it is either an IO error preventing you from writing the file or a SQL error because the table you are trying to read doesn't exist).

Finally, you copy and pasted the code from here: http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/. Did you read the comments there? There are two likely problems, both discovered on that code in 2009. One has a simple fix, and the other a not so easy fix.

[Sarra Sakka]

Thanks for you reuest Steve.
Can you help me to define this two error ?