I’m currently trying to pre-populate a ROOM database from a database file within assets using .createFromAsset. While running my application, I get "Caused by: java.lang.RuntimeException: Unable to copy database file." error. My db file path assets/database/cardb.db E/AndroidRuntime: FATAL EXCEPTION: arch_disk_io_0 Process: com.example.myapplication, PID: 8068 java.lang.RuntimeException: Exception while computing database live data. at androidx.room.RoomTrackingLiveData.refreshRunnable$lambda-0(RoomTrackingLiveData.kt:74) at androidx.room.RoomTrackingLiveData.$r8$lambda$UkyPj-RMUoTXOMbUuy5NWSwmo0E(Unknown… Read More Pre-Populating ROOM Database results in "java.lang.RuntimeException: Unable to copy database file."

I’m trying to get a count of a one-to-many ralationship in my query. My data class: data class CustomerWithCounts( @Embedded val customer: Customer, @Embedded val address: Address, val orderCount: Int, val paymentCount: Int ) I’m struggling to figure out how I can get the counts. My current Query: SELECT *, COUNT(SELECT * FROM tblOrder WHERE… Read More Room DB SQLite query to get counts of one-to-many relationships from different tables

so i have a database that is filled with data about teachers, and when i try to open a fragment that has a recyclerView inside of it that displays all of the teachers in the database it crashes! and what makes this a bit more illogical is when i tries to make a toast that… Read More I keep on getting "on a null object reference" while the object clearly isn't null

I’m trying to do a check in my apps Room DB. I want to check if a pin code has been used by querying the DB to find any results with that pin. My DAO function: @Query("SELECT * FROM tblUser WHERE userPin = :pin LIMIT 1") fun checkIfUserPinIsUsed(pin: String): UserTable? I want to do this… Read More Android Room Database Query without using Flow or LiveData (no observing)

How do I have default values for a table? For example table Permissions with ID and Name column to have these rows when the app is installed: ID Name 1 Edit Product 2 Add Product 3 Delete Product etc. >Solution : This is called Pre-Populate Room Database, you can achieve that by creating a new… Read More Default table rows/data

I use Room for work with database. When I save data to the database, they are saved to the .db-wal file and not to the database. How can I make me see the data visible in the database? When I fill the db, I see that volume of wal file is increasing but bd –… Read More How to make the data visible in DB

I am building an Android application with MVVM Architecture. Table A has an Auto-Generated Primary Key column which is a Foreign Key into Table B. When the user clicks a button on the main fragment a row is inserted into Table A. As part of this button’s onClickListener, I’d like to retrieve the Auto-Generated Primary… Read More How to get Auto Generated ID after Insert in Android RoomDB App

So I am trying to save a list of string pairs into my database but having some issues with the TypeConverter, I tried following guides ans other SO posts but can’t figure out whats wrong… My Entity: @Entity data class Credential( @PrimaryKey() val id: String, @ColumnInfo(name = "name") val name: String, @ColumnInfo(name = "url") val… Read More TypeConverter not working for android Room DB

I am learning Kotlin and am trying to filter some data coming straight from a (room) database into my adapter to display them. Here’s my code (from within the fragment, containing a recycleview with adapter): override fun onViewCreated(view: View, savedInstanceState: Bundle?) { super.onViewCreated(view, savedInstanceState) val adapter = LatestReleaseListAdapter { } binding.recyclerView.layoutManager = LinearLayoutManager(this.context) binding.recyclerView.adapter =… Read More Android – filter data from database in an adapter

I know in sqlite we can define column decimal precision with DECIMAL(10,2) How can this be achieved with Android Room Eg. I want room table column to store 1000.33, when I insert 1000.3333333333 >Solution : You cannot define the precision. All REAL (the storage class used for decimal/float/double values) values are stored in SQLite as… Read More How to define float decimal precision in Android Room table column