This question was closed Jan 30, 2017 at 02:49 PM by Giusort for the following reason:

The question is answered, right answer was accepted

Question by Giusort · Jan 27, 2017 at 04:43 PM · android exception sqlite

SQLite exception on Android

Hi!

I use this code to open Sqlite connection to a database:

...

using Mono.Data.Sqlite; ...

     public static void OpenDB(string p) {
             string filepath = "";
     
             #if UNITY_EDITOR
                 filepath = string.Format(@"Assets/StreamingAssets/{0}", p);
             #else
                 filepath = Application.persistentDataPath + "/" + p;
                 if(!File.Exists(filepath)) {
                     Debug.LogWarning("File \"" + filepath + "\" does not exist. Attempting to create from \"" +
                                       Application.dataPath + "!/assets/" + p);

                     WWW loadDB = new WWW("jar:file://" + Application.dataPath + "!/assets/" + p);
                     while(!loadDB.isDone) {}

                     File.WriteAllBytes(filepath, loadDB.bytes);
                 }
             #endif
             
             //open db connection
             connection = "URI=file:" + filepath;
             // Debug.Log("Stablishing connection to: " + connection);
             try {
          dbcon = new SqliteConnection(connection);
          dbcon.Open();
     }
     catch (Exception exception) {
         GUITxt = exception.Message + "\n" + exception.StackTrace;
         Debug.LogError(exception.Message + "\n" + exception.StackTrace);
     }
     finally {
         dbcon.Close ();
         dbcon.Dispose ();
     }
         }

and it works fine on Windows. On Android device I've an exception:

at (wrapper managed-to-native) Mono.Data.Sqlite.UnsafeNativeMethods.sqlite3_open_v2 at Mono.Data.Sqlite3.Open(System.String strFileName, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, boolean usePool) [0x000... at Mono.Data.Sqlite.SqliteConnection.Open() [0x00000] in :0 at DBAccess.OpenDB(System.String p) [0x00000] in :0

I have the sqlite3.so file in Assets/Android/Plugins folder.

Where I'm wrong?

Many thanks!

Add comment · Show 1