Please make sure that your build.gradle structure is similar to the file shared in this link (Android default libraries and versions can be different).

(Please do not share the link in comment, because if you delete the project later from the uploaded place, your comment will become unusable for others), Hello.. Can you please assist me with importing the database from sdcard? Here is mine; 11-21 16:48:20.883 8996-8996/com.amgad.hayy E/AndroidRuntime: FATAL EXCEPTION: main Process: com.amgad.hayy, PID: 8996 java.lang.RuntimeException: Unable to start activity ComponentInfo{com.amgad.hayy/com.amgad.hayy.MainActivity}: java.lang.NullPointerException: Attempt to invoke virtual method 'int android.database.sqlite.SQLiteDatabase.getVersion()' on a null object reference at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3319) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3415) at android.app.ActivityThread.access$1100(ActivityThread.java:229) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1821) at android.os.Handler.dispatchMessage(Handler.java:102) at android.os.Looper.loop(Looper.java:148) at android.app.ActivityThread.main(ActivityThread.java:7331) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120) Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'int android.database.sqlite.SQLiteDatabase.getVersion()' on a null object reference at com.readystatesoftware.sqliteasset.SQLiteAssetHelper.getWritableDatabase(SQLiteAssetHelper.java:178) at com.amgad.hayy.data.DatabaseAccess.open(DatabaseAccess.java:47) at com.amgad.hayy.MainActivity.onCreate(MainActivity.java:40) at android.app.Activity.performCreate(Activity.java:6904) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1136) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3266) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3415) at android.app.ActivityThread.access$1100(ActivityThread.java:229) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1821) at android.os.Handler.dispatchMessage(Handler.java:102) at android.os.Looper.loop(Looper.java:148) at android.app.ActivityThread.main(ActivityThread.java:7331) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120), Hi,Sorry for the late response. thanks. Why are not all list view data rows showing in the scroll view layout - Can you advise?The relevant section of code int he ScrollActivity.java file is as follows:public class ScrollingActivity extends AppCompatActivity { private ListView listView; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_scrolling); Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar); setSupportActionBar(toolbar); FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab); fab.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG) .setAction("Action", null).show(); } });// database access code from .MainActivity example used in .ScrollActivity this.listView = (ListView) findViewById(R.id.listView); DatabaseAccess databaseAccess = DatabaseAccess.getInstance(this); databaseAccess.open(); List colleges = databaseAccess.getColleges(); databaseAccess.close(); ArrayAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, colleges); this.listView.setAdapter(adapter); }The method in the DatabaseAccess.java file is as follows:public List getColleges() { List list = new ArrayList<>(); Cursor cursor = database.rawQuery("SELECT institution_name FROM titleix WHERE state_cd = \"CA\" " , null); cursor.moveToFirst(); while (!cursor.isAfterLast()) { list.add(cursor.getString(0)); cursor.moveToNext(); } cursor.close(); return list;}, I have tried to declare a global variable in the OnCreate() method so that I can assign it the value of the a local variable declared in the for loop scope; but Android error notice states the variable must be declared final, then if I do that it cannot be assigned the local for loop variable value. It is not efficient but should resolve your problem. Because i have more than hundred images, and how to do that? Could you please share your logcat error log so that I can figure out the exact problem. Make sure that you have the file. Trending is based off of the highest score sort and falls back to it if no posts are trending. Passing data using IntentIf you still, have issues, feel free to comment below. Hi Marko,Could you please share the logcat error message here? Hi,Your sign_user method uses rawQuery method to insert the into the database. Thank you, and i added user input to add a new record thats work. Hi,Sqliteassethelper cannot help for your problem. Run the application again. why this happen?! So the first time the application runs it should copy the db from online location??? I don't know what i'v done wrong, but i remade all project and its working now, greath example, and good support, thank you friend!!! Thank You.

If it does not work, please share the screenshot of the error log with the assets folder. Thanks. Making statements based on opinion; back them up with references or personal experience. Thats weird. Even Google now recommends to use splash screen during time taking initialization. CRUD operations are explained in the following article.http://www.javahelps.com/2015/03/advanced-android-database.html. slaam sir.i have an error "configuration default not found" while importing the library can u solve it plzzz.i wiil be thankful :), Hi, i still facing this issue, i attached the snapshot of my android studio structure screenshot, also the build,gradle (Module App).Kindly need your help. I don't have any error. Thanks for your time, Hi,If you prefer to store the images in the application itself, store the image name in the database and open it at the runtime using those names. Is there a political faction in Russia publicly advocating for an immediate ceasefire? The problem is the application open and it automatically close with a message"Unfortunately Mydatabase has stopped".How to fix this error?Mydatabase is the name of the app. If you want to insert the images into the database, check my new tutorial on importing database with images[1]. Hi,Please check the database and the getColleges method. Hi,Follow these two steps:Step 1: Add the following dependency and multiDexEnabled true in module level build.gradle.android { defaultConfig { // Enabling multidex support. Please double check the Step 4 and ensure the library is imported. Uninstall the existing app from your emulator or device.2. Hi,Sorry for the late response. The problem was when I first ran it I made the name of the table quote instead of quotes and when I changed it to quotes I never uninstalled the app on the emulator. This tutorial shows you the way to add the latest MySQL JDBC driver to Eclipse. If your problem still remains, please share your code (and logcat outputs if there are any errors). Sorry for the late reply. slaam..sir plz can u tell me how to show more than one fields in list view.for example quotes and also author names from second field from sqlite, Hi,You have to use customized ListView with more than one TextViews. Create DatabaseAccess class as in Step 9 and write all the CRUD operations in that class.3. If it does not resolve your problem, please share your build.gradle file. Hi, thanks for the tutorial you realy help me a lot!I just have one question:how i can put the data in the cardview? I want to know that can I use 2 tables in my database and use one table in one method of DatabaseAccess and another table in another method in DatabaseAccess. package kyle.peaktracker; You can now choose to sort by Trending, which boosts votes that have happened recently, helping to surface more up-to-date answers. There is nothing special in modifying a database which is imported in this way except the OpenHelper implementation. What would be the ideal way to do this? Thank you. After importing the databases, I am working on other functions like merge in Android. Hi,Thanks you. I never in the code put the Data Base path (in assets folder). Hi,If you deployed an empty database earlier, it may happen. Can you create a code such as this and post the tutorial.It is a calendar app with events as well.https://inducesmile.com/android/how-to-create-android-custom-calendar-view-with-events/#comment-2508i love your explanations!! But look, I have quotes.db in my assets folder. [1] http://www.javahelps.com/2015/03/advanced-android-database.html, Hi Gobinath,that's a good tutorial but as it mentioned before on the comments by Bemby Aditya my database doesn't update after the Insert query i added to DatabaseAccess class. Remove the multiDexEnabled support which I asked to add earlier (Not needed)3. How to lazy load images in ListView in Android, How to get screen dimensions as pixels in Android. For your reference, check this article about CRUD operations in Android: Advanced Android Database (Follow from Step 6 since you already have the DatabaseOpenHelper and DatabaseAccess), Hi,I hope this is what you have to do:1. I opened the database and it is not corrupted. How I can search in DB External SQlit .My DB SQlite Contain texts that showed in many fragments, , For that I need to make search for any word in my all data base and view all result in list view, all fragments have this word.Please Help me. How can I verify RAM in my emulator and set it to its highest value? Notice that "SELECT * FROM quotes" is the only place, I refer the table name. Adding to Leonid Ustenko,If you do not have any such mismatches, another possible reason could be that you haven't uninstall the app before deploying it with new database. [1] http://stackoverflow.com/a/20582538/4382663[2] http://stackoverflow.com/a/7325248/4382663. If you mean reading lot of data from database as "initializing the application", you need a splash screen.If you still have doubts on it, feel free to comment below.

I would suggest an external MySQL database in a web server to store your data and use web services to access it. Just create the database, insert into the application and do what ever you want :-), The db has over a thousand rows and five tables. Make sure that you have uninstalled the app manually from the device and instal it again after each and every modifications you made in the database. Import and Use External Database in Android, Deploy and Upgrade Android Database From External Directory. Thank you very much for all your help! Below is my extension of SQLiteOpenHelper: This is my MainActivity: (If this not what you are expecting, feel free to comment below). how to update database anyway. Hi Ami,Could you comment below the Logcat error message when your application terminates? For example if you are developing a static application which is used to display some tourist spots in your country, probably you need to release the database with predefined details about the tourist places inside it. There should be something wrong in the application or emulator. Hi thanks for the answer, i have an hundreed images with size average 1.5mb, so can u give an example for retrieve data from sqlite and images too from asset folder? If you mean extracting the zip file as "initializing the database", no need for splash screen (Because it happens only one time). I would appreciate you help. Database in assets folder must be a zip file containing quotes.db with a name quotes.db.zipAlso I have updated the Android SDK versions to 23 since I don't have the updated SDK version. thanks for yours tutorials. For more details about this library, visit to its. hello sir.i apply this code,there is no error but my application crashes again and againcan u help me plz??????? This library also allows you to upgrade the database using an external SQL script. I'm trying to send an ArrayList. You can generalize the data loading if all the tables are in the same structure. Could you please check whether you are passing a valid context to the DatabaseAccess constructor. I will run and test it in my system. In a recent article: Microservices in a minute , I introduced a lightweight microservice framework: WSO2 MSF4J.

But loading data from database to memory may take time.

I have tried to put some line to understand where the programm is blocked, and i think the problem is after i call open method in the mainActivity. Please make sure that you have the quotes table in the database. Here the problem is: your previous application was installed with a different table name or no table at all. However, in the context of Android, you cannot do that.

[1] http://www.javahelps.com/2016/04/import-database-with-images-in-android.html, OMG, you're really awesome sir. How do I get this to work? hi, does not matter I understand my mistake.

If you still have the problem, share your gradle.build file. Hello this my gradle :apply plugin: 'com.android.application'android { compileSdkVersion 23 buildToolsVersion "23.0.3" defaultConfig { applicationId "konya.hasan.kpssquiz" minSdkVersion 14 targetSdkVersion 23 versionCode 1 versionName "1.0" } buildTypes { release { minifyEnabled false proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro' } }}dependencies { compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' compile fileTree(include: ['*.jar'], dir: 'libs') testCompile 'junit:junit:4.12' compile 'com.android.support:appcompat-v7:23.4.0' compile project(':android-sqlite-asset-helper') compile 'com.google.android.gms:play-services-appindexing:8.1.0' compile files('libs/GenAsync.jar')}, Remove the following line from Gradle build and try to rebuild the project.compile project(':android-sqlite-asset-helper'). If you are asking about new version release(with a new column in the database), have a look at https://github.com/jgilfelt/android-sqlite-asset-helper. Do you have any suggest?

( for example quotes,author & )i see ur "customize list view" learning in "url:http://www.javahelps.com/2015/02/android-customized-listview.html".. thank u for that . Sir,I have another issues.May I get CRUD operations tutorial for database in this assets folder?I want to know about inserting or deleting column value.Sorry for my bad English.Thank's! When you use sqliteassethelper, it will extract the zip file into the default database location if the database is not available. Hi , if I added new column to the qoutes table and named it "Bitim" , and I added Some strings to it (like he "qoute" column) when I try to retrive this column strings with "list.add(cursor.getString(1))"the cursor doesnt recognize this column ,what should I do ? Any pointers?Thank You, Hi,1) Redeploy an Android application does not overwrite the existing database. Exception!! You cannot attach the project in this blog itself. (You may required to change the Android perspective to Project perspective to see the libs folder)If you still have any issues, please comment below. I keep getting the error message " android.database.sqlite.SQLiteFullException: database or disk is full."

If you still get the error, share the logcat error message. The error says "no such table: quotes". It happens only one time so don't worry about the delay. how to use custom listview with this eksampel ? (SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery. I'm trying to update the database (after the initial usuage, so basically upgrading it with a new database).

For more details, go through this tutorial: http://www.javahelps.com/2015/02/android-customized-listview.html. Hi,Could you please check whether you have proper internet connection (If you are behind proxy, need to configure it in Android Studio.). Somewhere I found JDK 8 might be a problem for this multidex related error. Hi,I guess that your previous application with single column database is in the emulator, while you are deploying your updated application. I've followed your tutorial, but I cant seem to update older cells. You can have any number of queries and any type of queries. i will try this exmple.click in lisview then next page display textview.drag and drop to button next and privous.how to this code complete in sqlite database in extrnal database, hi, i tried this code on an intent activity but it says following error: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.hppc.mood/com.example.hppc.mood.Eatry}: com.readystatesoftware.sqliteasset.SQLiteAssetHelper$SQLiteAssetException: Missing databases/quotes.db file (or .zip, .gz archive) in assets, or target folder not writable. Create a custom list view as given in customized list view tutorial. How to close/hide the Android soft keyboard programmatically? I am trying to load the database from a sdcard(My input database always has the same schema but the records keep changing - so I cannot load the database in assets folder) .. @Gobinath, hi Gobinath, i have send the dropbox link using contact form, kindly need your help to review ituthanks and appreciate it. Could you please check your code to add new record and also make sure that you haven't overwrite anything during startup. Asking for help, clarification, or responding to other answers. As such it does have quite extensive logging and is a little long-winded :-. Thank you for your answer. Can you please walk me through on how I can do the same? Now i'd like to do all this process in background, using an IntentService or a Service. You are right. The problem is when i "clear data" on my phone to get a new fresh database from this app it works fine and all databases load as usually like before i costumize it with a new record, but when i inserted a new record , the app is force close . You can pick your db file by using any file picker. I have a database with more that 1000 rows and 5 different tables. I tried as you said.

If so then a little help with the code. so databasehandler goes to onUpgrade method and drop the table.well, where can i see the version of database or manipulate it? Connect and share knowledge within a single location that is structured and easy to search. If I have more function with some query in DatabaseAccess class and I want to call them more than once, do I need to open and close the connection? I think you skipped a part in this tutorials, How do I add download library from GitHub to my project. Hi Gobinath,it is wonderfull, very helpful, i will recomend this to my community.thanks a lot.

Is that possible? Also make sure that you have enough RAM (Start from highest possible memory) allocated for the emulator.

The error says "Missing databases/newdb.sqlite file (or .zip, .gz archive) in assets" . Thank you for reply, when i plug in my phone into computer to find error in the logcat, the problem is missing.

https://uploads.disquscdn.com/images/364bfcd243139dce0724b427c5512082a0103c6e773850116ddf9fa60a32c09d.jpg Hello, Thanks for the External Database tutorial, I followed instructions exactly, except I chose to use a different database of 1,600 colleges selected by state residence and use a ScrollActivity app so that I could scroll through all list view college data rows.My problem is that I can only view only the first college data row in the scroll view activity (see attached image). However, it has nothing to do with your problem.

:) , im so thankfull for your help so ill try using your example for store image, and if i have some problem, ill ask again :) thanks, if you has easiest way to contact you please email your contact on me ty, Hello.