http://bugzilla.novell.com/show_bug.cgi?id=579292
http://bugzilla.novell.com/show_bug.cgi?id=579292#c0 Summary: DataAdapter seems to report a column does not exist when attempting to fill a datatable Classification: Mono Product: MonoTouch Version: unspecified Platform: Other OS/Version: Mac OS X 10.6 Status: NEW Severity: Normal Priority: P5 - None Component: Class Libraries AssignedTo: gnor...@novell.com ReportedBy: wallacebmccl...@wallym.com QAContact: mono-bugs@lists.ximian.com Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10 When running the code below, an error is generated on the call to data adapter Fill() method. var documents = Environment.GetFolderPath (Environment.SpecialFolder.Personal); string db = Path.Combine (documents, DatabaseName); string strSql = "select TWITTERID from TwitterData"; var conn = new SqliteConnection("Data Source=" + db); var dt = new DataTable(); var da = new SqliteDataAdapter(strSql, conn); da.Fill(dt); Reproducible: Always Steps to Reproduce: With the included source file. 1. Add in your twitter user id and password. They are currently marked as xxxxx and yyyyy 2. Run the application in the simulator. I am using Apple SDK 3.2 beta 2 and MT 1.9 alpha. 3. within the application, click on "Setup App" button to setup tables, indexes and such. 4. within the application, click on "Get Data" button to retrieve data from twitter and store it in the TwitterData table. 5. within the application, click on the "Current Status" button. the error should now occur. Actual Results: Once I do step 5 above, I get the following error within MonoDevelop from the iPhone simulator. Unhandled Exception: System.EntryPointNotFoundException: sqlite3_column_origin_name at (wrapper managed-to-native) Mono.Data.Sqlite.UnsafeNativeMethods:sqlite3_column_origin_name (intptr,int) at Mono.Data.Sqlite.SQLite3.ColumnOriginalName (Mono.Data.Sqlite.SqliteStatement stmt, Int32 index) [0x00000] in /Developer/MonoTouch/Source/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLite3.cs:493 at Mono.Data.Sqlite.SqliteDataReader.GetSchemaTable (Boolean wantUniqueInfo, Boolean wantDefaultValue) [0x0042d] in /Developer/MonoTouch/Source/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteDataReader.cs:618 at Mono.Data.Sqlite.SqliteDataReader.GetSchemaTable () [0x00000] in /Developer/MonoTouch/Source/mcs/class/Mono.Data.Sqlite/Mono.Data.Sqlite_2.0/SQLiteDataReader.cs:550 at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction missingSchAction, MissingMappingAction missingMapAction, System.Data.Common.DataTableMappingCollection dtMapping) [0x0003b] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:284 at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType) [0x00000] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:257 at System.Data.Common.DataAdapter.FillTable (System.Data.DataTable dataTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32& counter) [0x00011] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:428 at System.Data.Common.DataAdapter.FillInternal (System.Data.DataTable dataTable, IDataReader dataReader) [0x00030] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:242 at System.Data.Common.DataAdapter.Fill (System.Data.DataTable dataTable, IDataReader dataReader) [0x00000] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DataAdapter.cs:558 at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable, IDbCommand command, CommandBehavior behavior) [0x00022] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DbDataAdapter.cs:265 at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable) [0x00011] in /Developer/MonoTouch/Source/mcs/class/System.Data/System.Data.Common/DbDataAdapter.cs:241 at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataTable) at Sqlite.AppDelegate.HandleCurrentStatusTouchUpInside (System.Object sender, System.EventArgs e) [0x0003b] in /Users/wallymcclure/Projects/Sqlite/Sqlite/Main.cs:55 at MonoTouch.UIKit.UIControlEventProxy.Activated () [0x00000] in /Users/plasma/Source/iphone/monotouch/UIKit/UIControl.cs:29 at (wrapper managed-to-native) MonoTouch.UIKit.UIApplication:UIApplicationMain (int,string[],intptr,intptr) at MonoTouch.UIKit.UIApplication.Main (System.String[] args, System.String principalClassName, System.String delegateClassName) [0x00038] in /Users/plasma/Source/iphone/monotouch/UIKit/UIApplication.cs:26 at MonoTouch.UIKit.UIApplication.Main (System.String[] args) [0x00000] in /Users/plasma/Source/iphone/monotouch/UIKit/UIApplication.cs:31 at Sqlite.Application.Main (System.String[] args) [0x00000] in /Users/wallymcclure/Projects/Sqlite/Sqlite/Main.cs:22 Expected Results: I should get a datatable back. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. _______________________________________________ mono-bugs maillist - mono-bugs@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-bugs