Orchid related data in SQLite DB format attached in Asset folder with Android Application and application work only upto Android 8 (API level 26) but the inbuilt Database is not visible in Android 9 (API level 28) . What's the reason behind this?
Application built in Eclipse Juno Framework
hi.,
refer this link:
https://developer.android.com/reference/android/database/sqlite/package-summary
Thank you for your answer but Inbuilt SQLite Database is not visible in android phones of targetSdkVersion=28 means data is not shown properly in version 9 android phones. It works in SdkVersion= 16 to 26 (4.1-8.0 version) android smartphones
Thank you Mohammed Deeb for your valuable reply but I already view this concept and its not helpful to me.
because this problem is different and my Application is offline and SQLite DB stored in asset folder when the application install and run then this stored DB attached with application. But due to the up-gradation in version this code is not supported and in below version it works perfectly.
Below code is used for calling/attaching that DB file (saved in asset folder) with application
public class DataBaseHandler extends SQLiteOpenHelper {
public static String DB_PATH;
public static String DB_NAME = "orchidpedia.db";
public SQLiteDatabase database;
public final Context context;
public SQLiteDatabase getDb() {
return database;
}
public DataBaseHandler(Context context, String databaseName) {
super(context, databaseName, null, 1);
this.context = context;
String packageName = context.getPackageName();
DB_PATH = String.format("/data/data/nrco.orchidopedia/databases/", packageName);
DB_NAME = databaseName;
openDataBase();
}
public void createDataBase() {
boolean dbExist = checkDataBase();
if (!dbExist) {
this.getReadableDatabase();
try {
copyDataBase();
} catch (IOException e) {
Log.e(this.getClass().toString(), "Copying error");
throw new Error("Error copying database!");
}
} else {
Log.i(this.getClass().toString(), "Database already exists");
}
}
private boolean checkDataBase() {
SQLiteDatabase checkDb = null;
try {
String path = DB_PATH + DB_NAME;
checkDb = SQLiteDatabase.openDatabase(path, null,
SQLiteDatabase.OPEN_READONLY);
} catch (SQLException e) {
Log.e(this.getClass().toString(), "Error while checking db");
}
if (checkDb != null) {
checkDb.close();
}
return checkDb != null;
}
private void copyDataBase() throws IOException {
assets
InputStream externalDbStream = context.getAssets().open(DB_NAME);
String outFileName = DB_PATH + DB_NAME;
OutputStream localDbStream = new FileOutputStream(outFileName);
byte[] buffer = new byte[1024];
int bytesRead;
while ((bytesRead = externalDbStream.read(buffer)) > 0) {
localDbStream.write(buffer, 0, bytesRead);
}
localDbStream.close();
externalDbStream.close();
}
public SQLiteDatabase openDataBase() throws SQLException {
String path = DB_PATH + DB_NAME;
if (database == null) {
createDataBase();
database = SQLiteDatabase.openDatabase(path, null,
SQLiteDatabase.OPEN_READWRITE);
}
return database;
}
@Override
public synchronized void close() {
if (database != null) {
database.close();
}
super.close();
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
- Badges
- Science topic
- Similar topics
- Papers