Android/Oculus sqlite3.dll not found

[giantkiller]

The Oculus GO is a flavor of android.

Porting to the Oculus is a huge simplesql and sqlite product platform advancement. I believe I am the first to attempt this as I have not seen searches reporting anything yet.

I always go to the images link as this gives great insight into further possibilities: Images

In the Android Device Monitor filter text box I enter: sql

The log refreshes and these are the first lines reported.

This is also with my sql logic script db manager parameter set to the sql db manager object.

sqlite3.dll is in root folder on the PC just to make this clear.

SimpleSQL_runtime.dll is in the Project.apk,

but sqlite3.dll is not there it is truly missing on the android device. Looks like it did not get packaged.

I tried to get to the AndroidManifest.xml file but the pc keeps reverting to notepad to view it. I can't read it in that format.

I copied the sqlite3.dll to the Assets/Android/Plugins/ folder from the project root folder in hopes of an attempt and I get:

Multiple plugins with the same name 'sqlite3' (found at 'Assets/Ludiq/Assemblies/sqlite3.dll' and 'Assets/SimpleSQL/Plugins/sqlite3.dll'). That means one or more plugins are set to be compatible with Editor. Only one plugin at the time can be used by Editor.
UnityEditorInternal.InternalEditorUtility:ProjectWindowDrag(HierarchyProperty, Boolean)
UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr)

Ludiq is a graphical design interface for Unity. On the android: is the sqlite3.dll put in a place for communal access or each plugin uses its own?

Haven't scoped out gradle log yet. I am starting from the beginning of the build process.

01-12 11:40:37.963: D/Unity(15251): Unable to lookup library path for 'sqlite3', native render plugin support disabled.

01-12 11:40:37.964: E/Unity(15251): Unable to find sqlite3

01-12 11:40:38.000: E/Unity(15251): DllNotFoundException: sqlite3

With being logged where can I look next?

Attachments:

[giantkiller]

I realized I had unity menu/tools/simplesql/options set to win.

Changed this to unity menu/tools/simplesql/options set to android 9+ to correct the destination platform correctly to android 9+.

Didnt see a change.

I put the project back to the previous dll layout with unity menu/tools/simplesql/options set to win from android 9+.

Now I get:

XmlException: invalid data.
System.Xml.XmlStreamReader.Read (System.Char[] dest_buffer, Int32 index, Int32 count)
Mono.Xml2.XmlTextReader.ReadTextReader (Int32 remained)
Mono.Xml2.XmlTextReader.PeekChar ()
Mono.Xml2.XmlTextReader.ReadContent ()
Mono.Xml2.XmlTextReader.Read ()
System.Xml.XmlTextReader.Read ()
UnityEditor.AndroidXmlDocument..ctor (System.String path)
UnityEditor.AndroidManifest..ctor (System.String path)
UnityEditor.Android.PostProcessor.Tasks.GenerateManifest.CopyMainManifest (UnityEditor.Android.PostProcessor.PostProcessorContext context, System.String target)
UnityEditor.Android.PostProcessor.Tasks.GenerateManifest.Execute (UnityEditor.Android.PostProcessor.PostProcessorContext context)
UnityEditor.Android.PostProcessor.PostProcessRunner.RunAllTasks (UnityEditor.Android.PostProcessor.PostProcessorContext context)
UnityEditor.Android.PostProcessAndroidPlayer.PostProcess (BuildTarget target, System.String stagingAreaData, System.String stagingArea, System.String playerPackage, System.String installPath, System.String companyName, System.String productName, BuildOptions options, UnityEditor.RuntimeClassRegistry usedClassRegistry, UnityEditor.Build.Reporting.BuildReport report)
UnityEditor.Android.AndroidBuildPostprocessor.PostProcess (BuildPostProcessArgs args, UnityEditor.BuildProperties& outProperties)
UnityEditor.PostprocessBuildPlayer.Postprocess (BuildTargetGroup targetGroup, BuildTarget target, System.String installPath, System.String companyName, System.String productName, Int32 width, Int32 height, BuildOptions options, UnityEditor.RuntimeClassRegistry usedClassRegistry, UnityEditor.Build.Reporting.BuildReport report) (at C:/buildslave/unity/build/Editor/Mono/BuildPipeline/PostprocessBuildPlayer.cs:287)
UnityEngine.GUIUtility:ProcessEvent(Int32, IntPtr)

I had tried to use VS2017 to view the file which it jumped to notepad.

I then tried this:Unity xml view correction

Maybe hosed the file I don't know. Now I have to rebuild the manifest.

I deleted the manifest xml file in the windows explorer and rebuilt. xml read failure resolved.

Missing sqlite3.dll exist.

Will now go back and try the:

unity menu/tools/simplesql/options set to android 9+

[giantkiller]

After setting:

unity menu/tools/simplesql/options set to android 9+

The sqlite3.dll error went away. But the Android Device monitor shows no debug.log sql messages any more. Its like my logic script is not included in the apk.

But I do receive this now:

IndexOutOfRangeException: Array index is out of range.
UnityEditor.Android.AndroidBuildWindowExtension.GetBuildPlayerWindow ()
UnityEditor.Android.AndroidBuildWindowExtension.RepaintTargetList ()
UnityEditor.EditorApplication.Internal_CallUpdateFunctions () (at C:/buildslave/unity/build/Editor/Mono/EditorApplication.cs:191)

[giantkiller]

Odd happenings, its working!

Closed Android Device Monitor and reopened seemed to clear things up.

I can move on!

I now take the urls from the table and call the webrequest to get the page data.

[echo17]

Thanks for the follow up. I hope this helps someone else having a similar issue.