sqlite in the xamarin android player

Question

I have clicked on Tools -> Android -> Android Device Monitor in VS 2015 and got the following error, but my xamarin android player works fine.

Is there a way to access to local database (sqlite) in the xamarin android player simulator not on the physical device?

Update:

I am using adb and getting the following error

Answer 1

Solution 1:

I run tools->android-> android adb command prompt in visual studio

I have followed the followings to access the database

step1. >adb shell

step2. >cd data/data

step3. >ls -l|grep "com.xxxx"

step4. >cd "com.xxxx"

Then I used the following to copy sql file to my workstation

adb shell "run-as com.xxxx chmod 666 /data/data/com.xxxx/files"
adb pull /data/data/com.xxxx/files/xx.sql
adb shell "run-as com.xxxx chmod 600 /data/data/com.xxxx/files"

Then I have downloaded sqlite browser to open the file and see the tables.

Solution 2:

Alternatively, you can go to following directory and double click the exe file

C:\Users\XXXXX\AppData\Local\Android\ANDROI~1\tools\lib\monitor-x86_64\monitor.exe

Answer 2

Failed to load the JNI shared library "C:/XXXXX/jvm.dll"`.

This is a sign of a mixed 32/64 Java bit Java install and/or the wrong version is installed.

Xamarin on Windows requires a Windows x86 version of v1.7

It is essential to install the 32-bit version of the Java JDK even if you're using 64-bit Windows. It is also important that v1.7 of the Java JDK is installed (although it is fine to have 1.8 or newer installed at the same time).

So I would start by installing Java v1.7, since the error is pointing to v1.6 and retrying to open the Android Device Monitor.

Installing the Java SDK (JDK)

The JDK can be downloaded from any browser by visiting Oracle’s website and browsing to the section with the heading Java SE Development Kit 7u79

Ref: https://developer.xamarin.com/guides/android/getting_started/installation/windows/manual_installation/#Installing_the_Java_SDK_JDK