Insert into SQLITE TABLE inside FOR loop using Java in Android getting NPE error?

Question

i am getting data from my Service and when trying to insert into TABLE i am getting exception....While my first row is correctly printing on Log and just after that error : error is on this LOC: db.execSQL(query); public class ProgramDBHelperActivity extends Activity {

Context context;
SQLiteDatabase db;


    private void getParametersData(String parameter)
            {
                try
            {
                String getParametersData_String  = ServerRequest1.sendRequest(url,parameter);
                String[] getParametersData_Str_Array = getParametersData_String.split("<br />");

                 for(int i=0;i<getParametersData_Str_Array.length;i++)
                 {
        Log.i("getParametersData_Str_Array :",getParametersData_Str_Array[i]);

    String query =  "INSERT  INTO parameterTable(ID,param_type,cash_code,param_description) " +  "VALUES ("+getParametersData_Str_Array[i]+");";
    Log.i("query result",""+query);
    db.execSQL(query);
    Log.i("news Save", "" + db);
   }
   }
   catch (JSONException e) 
   {
    errorMessage = getString(R.string.ExceptionGeneral);
  ExceptionHandler.logException(e);
  e.printStackTrace();
   }
   catch (SocketException e) {
   errorMessage = getString(R.string.ExceptionNetworkProblem);
   ExceptionHandler.logException(e);
   e.printStackTrace();
            } catch (IOException e) {
                errorMessage = getString(R.string.ExceptionGeneral);
                ExceptionHandler.logException(e);
                e.printStackTrace();
            } catch (Exception e) {
                errorMessage = getString(R.string.ExceptionGeneral);
                ExceptionHandler.logException(e);
                e.printStackTrace();
            }

            }

HERE IS THE LOG:

12-19 04:39:42.234: I/query result(4772): INSERT 12-19 04:39:42.234: W/System.err(4772): 12-19 04:39:42.234: W/System.err(4772): 12-19 04:39:42.234: W/System.err(4772): 12-19 04:39:42.234: W/System.err(4772): 12-19 04:39:42.234: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.239: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): 12-19 04:39:42.244: W/System.err(4772): INTO parameterTable(ID,param_type,cash_code,param_description) VALUES (1,"product group","12345","Service Spares"); java.lang.NullPointerException at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.getParametersData(ProgramDBHelperActivity.java:146) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:128) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:1) at android.os.AsyncTask$2.call(AsyncTask.java:287) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305) at java.util.concurrent.FutureTask.run(FutureTask.java:137) at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569) at java.lang.Thread.run(Thread.java:856) java.io.FileNotFoundException: /storage/sdcard0/taplaw.log: open failed: EACCES (Permission denied) at libcore.io.IoBridge.open(IoBridge.java:416) at java.io.FileOutputStream.(FileOutputStream.java:88) at com.survey.management.util.ExceptionHandler.logException(ExceptionHandler.java:55) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.getParametersData(ProgramDBHelperActivity.java:167) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:128) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:1) at android.os.AsyncTask$2.call(AsyncTask.java:287) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305) at java.util.concurrent.FutureTask.run(FutureTask.java:137) at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569) at java.lang.Thread.run(Thread.java:856) Caused by: libcore.io.ErrnoException: open failed: EACCES (Permission denied) at libcore.io.Posix.open(Native Method) at libcore.io.BlockGuardOs.open(BlockGuardOs.java:110) at libcore.io.IoBridge.open(IoBridge.java:400) ... 12 more java.lang.NullPointerException at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.getParametersData(ProgramDBHelperActivity.java:146) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:128) at com.survey.management.activity.ProgramDBHelperActivity$ReqGetParameter.doInBackground(ProgramDBHelperActivity.java:1) at android.os.AsyncTask$2.call(AsyncTask.java:287) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305) at java.util.concurrent.FutureTask.run(FutureTask.java:137) at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569) at java.lang.Thread.run(Thread.java:856)

Likely db is null - the code doesn't show where it is declared/initialized. — laalto
– laalto, Commented Dec 18, 2013 at 12:48
Don't use execSQL, use insert instead. > developer.android.com/reference/android/database/sqlite/… — LS_ᴅᴇᴠ
– LS_ᴅᴇᴠ, Commented Dec 18, 2013 at 14:47

laalto · Accepted Answer · 2013-12-18 12:55:22Z

2

Your db is not initialized and therefore null. If you're using the usual SQLiteOpenHelper pattern, initialize it with

db = helper.getWritableDatabase();

answered Dec 18, 2013 at 12:55

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Collectives™ on Stack Overflow

Insert into SQLITE TABLE inside FOR loop using Java in Android getting NPE error?

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