ListView inside scroll view android

1. Create a class named "VerticalScroller.java"
2. Copy the following code and paste into class.

   package com.example.utils;
   
   import android.content.Context;
   import android.util.AttributeSet;
   import android.util.Log;
   import android.view.MotionEvent;
   import android.widget.ScrollView;
   
   public class VerticalScroller extends ScrollView{
   
       public VerticalScroller(Context context) {
           super(context);
       }
   
        public VerticalScroller(Context context, AttributeSet attrs) {
               super(context, attrs);
           }
   
           public VerticalScroller(Context context, AttributeSet attrs, int defStyle) {
               super(context, attrs, defStyle);
           }
   
       @Override
       public boolean onInterceptTouchEvent(MotionEvent ev) {
           final int action = ev.getAction();
           switch (action)
           {
               case MotionEvent.ACTION_DOWN:
                       Log.i("VerticalScroller", "onInterceptTouchEvent: DOWN super false" );
                       super.onTouchEvent(ev);
                       break;
   
               case MotionEvent.ACTION_MOVE:
                       return false; // redirect MotionEvents to ourself
   
               case MotionEvent.ACTION_CANCEL:
                       Log.i("VerticalScroller", "onInterceptTouchEvent: CANCEL super false" );
                       super.onTouchEvent(ev);
                       break;
   
               case MotionEvent.ACTION_UP:
                       Log.i("VerticalScroller", "onInterceptTouchEvent: UP super false" );
                       return false;
   
               default: Log.i("VerticalScroller", "onInterceptTouchEvent: " + action ); break;
           }
   
           return false;
       }
   
       @Override
       public boolean onTouchEvent(MotionEvent ev) {
           super.onTouchEvent(ev);
           Log.i("VerticalScroller", "onTouchEvent. action: " + ev.getAction() );
            return true;
       }
   }

3. Go to xml file replace your <scrollview></scrollview> with <com.example.utils.VerticalScroller></com.example.utils.VerticalScroller>
4. Done

How to call database onUpgrade method Android

just open your SQLiteHelper class and change the DATABASE_VERSION. (increase its value from previous one)
Run your app again.