[Mono-bugs] [Bug 579292] New: DataAdapter seems to report a column does not exist when attempting to fill a datatable

[bugzilla_noreply at novell.com]

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: gnorton at novell.com
        ReportedBy: wallacebmcclure at wallym.com
         QAContact: mono-bugs at 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.