Liam, I've been meaning to test on 2.1 as well, but in some of the earlier posts (the much-missed) Jon Pryor said:
"Regardless, the problem is that you're running this on a platform earlier than Android 2.2. Only Android 2.2 has a SQLite recent enough for Mono.Data.Sqlite to properly interact with it (as previous versions are lacking necessary exports, as shown by all the EntryPointNotFoundExceptions)." Somebody else suggested: " Or you can bundle a libsqlite3 with the product as it's done on Mono/Desktop." I haven't tried that but it might be worth investigating. Cheers, Andy -----Original Message----- From: monodroid-boun...@lists.ximian.com [mailto:monodroid-boun...@lists.ximian.com] On Behalf Of Liam Sent: 02 June 2011 11:43 To: Discussions related to Mono for Android Subject: [mono-android] sqliteconnection.close () in Android 2.1 thows exception Hi I am having trouble using sqliteconnection with Android 2.1. I have tested it with two different devices running Android 2.1 and both throw exceptions. So I am guessing that there must be a bug in the way Sqlite has been implemented in Android for 2.1 (similar to the DataTable.Fill bug). If this is a bug then I know it won't get fixed. However if I am wrong and somebody knows about this and how to fix it then please let me know. Here is the stack trace: {System.EntryPointNotFoundException: sqlite3_next_stmt at (wrapper managed-to-native) Mono.Data.Sqlite.UnsafeNativeMethods:sqlite3_next_stmt (intptr,intptr) at Mono.Data.Sqlite.SQLiteBase.ResetConnection (Mono.Data.Sqlite.SqliteConnectionHandle db) [0x00016] in /home/mkestner/monogit/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/ SQLiteBase.cs:224 at Mono.Data.Sqlite.SQLiteBase.CloseConnection (Mono.Data.Sqlite.SqliteConnectionHandle db) [0x00010] in /home/mkestner/monogit/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/ SQLiteBase.cs:209 at Mono.Data.Sqlite.SqliteConnectionHandle.ReleaseHandle () [0x00000] in /home/mkestner/monogit/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/ UnsafeNativeMethods.cs:792 at System.Runtime.InteropServices.CriticalHandle.Dispose (Boolean disposing) [0x00017] in /home/mkestner/monogit/mono/mcs/class/corlib/System.Runtime.InteropServices/ CriticalHandle.cs:51 at System.Runtime.InteropServices.CriticalHandle.Dispose () [0x00000] in /home/mkestner/monogit/mono/mcs/class/corlib/System.Runtime.InteropServices/ CriticalHandle.cs:41 at Mono.Data.Sqlite.SQLite3.Close () [0x0003d] in /home/mkestner/monogit/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/ SQLite3.cs:62 at Mono.Data.Sqlite.SqliteConnection.Close () [0x0008e] in /home/mkestner/monogit/mono/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/ SQLiteConnection.cs:474 Thanks Liam _______________________________________________ Monodroid mailing list Monodroid@lists.ximian.com UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid _______________________________________________ Monodroid mailing list Monodroid@lists.ximian.com UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid
