[Mono-list] Mono.Data.MySQL
Daniel Morgan
danmorg@sc.rr.com
Tue, 5 Nov 2002 06:56:37 -0500
Hi Ben,
What platform are you building and running this on? Windows or Linux?
What debugger are you using?
Are you using mono mcs to build?
-----Original Message-----
From: Ben Clewett [mailto:Ben@roadrunner.uk.com]
Sent: Tuesday, November 05, 2002 6:47 AM
To: Daniel Morgan
Cc: mono-list@ximian.com
Subject: Re: [Mono-list] Mono.Data.MySQL
Daniel,
Sorry, same result.
Running you 'MySqlTest', this failes at your
Console.WriteLine("Select Values From the Database:");
Everything before this works.
Some of the variables the Debug enviroment report: (Any more, I can get
them...)
- schemaRow {System.Data.DataRow} System.Data.DataRow
System.Object {System.Data.DataRow} System.Object
oldRecord -1 int
newRecord -1 int
tempRecord 0 int
rowID -1 int
inChangingEvent false bool
inDeletingEvent false bool
inCascade false bool
error null System.Data.DataError
_element null System.Xml.XmlBoundElement
- _Table {System.Data.DataTable} System.Data.DataTable
+ System.ComponentModel.MarshalByValueComponent {System.Data.DataTable}
System.ComponentModel.MarshalByValueComponent
KEY_XMLSCHEMA "XmlSchema" string
KEY_XMLDIFFGRAM "XmlDiffGram" string
KEY_NAME "TableName" string
dataSet null System.Data.DataSet
defaultView null System.Data.DataView
nextRowID 1 int
+ rowCollection {System.Data.DataRowCollection}
System.Data.DataRowCollection
+ columnCollection {System.Data.DataColumnCollection}
System.Data.DataColumnCollection
+ constraintCollection {System.Data.ConstraintCollection}
System.Data.ConstraintCollection
elementColumnCount 22 int
+ parentRelationsCollection
{System.Data.DataRelationCollection.DataTableRelationCollection}
System.Data.DataRelationCollection
+ childRelationsCollection
{System.Data.DataRelationCollection.DataTableRelationCollection}
System.Data.DataRelationCollection
+ recordManager {System.Data.RecordManager} System.Data.RecordManager
+ indexes {Count=0} System.Collections.ArrayList
extendedProperties null System.Data.PropertyCollection
tableName "" string
tableNamespace null string
tablePrefix "" string
caseSensitive false bool
caseSensitiveAmbient true bool
culture null System.Globalization.CultureInfo
displayExpression null System.Data.DataFilter
+ compareInfo {System.Globalization.CompareInfo}
System.Globalization.CompareInfo
compareFlags 25 System.Globalization.CompareOptions
fNestedInDataset true bool
encodedTableName null string
xmlText null System.Data.DataColumn
_colUnique null System.Data.DataColumn
textOnly false bool
+ minOccurs 1 System.Decimal
+ maxOccurs 1 System.Decimal
repeatableElement false bool
+ typeName {System.Xml.XmlQualifiedName} System.Xml.XmlQualifiedName
zeroIntegers {Length=0} int[]
zeroColumns {Length=0} System.Data.DataColumn[]
primaryKey null System.Data.UniqueConstraint
primaryIndex {Length=0} int[]
delayedSetPrimaryKey null System.Data.DataColumn[]
saveIndexes null System.Collections.ArrayList
loadIndex null System.Data.Index
savedEnforceConstraints false bool
inDataLoad false bool
initialLoad false bool
schemaLoading false bool
fComputedColumns true bool
enforceConstraints true bool
+ propertyDescriptorCollectionCache
{System.ComponentModel.PropertyDescriptorCollection}
System.ComponentModel.PropertyDescriptorCollection
fInitInProgress false bool
_nestedParentRelation null System.Data.DataRelation
mergingData false bool
onRowChangedDelegate null System.Data.DataRowChangeEventHandler
onRowChangingDelegate null System.Data.DataRowChangeEventHandler
onRowDeletingDelegate null System.Data.DataRowChangeEventHandler
onRowDeletedDelegate null System.Data.DataRowChangeEventHandler
onColumnChangedDelegate null System.Data.DataColumnChangeEventHandler
onColumnChangingDelegate null System.Data.DataColumnChangeEventHandler
onPropertyChangingDelegate null
System.ComponentModel.PropertyChangedEventHandler
+ rowBuilder {System.Data.DataRowBuilder} System.Data.DataRowBuilder
+ delayedViews {Count=0} System.Collections.ArrayList
+ dvListeners {Count=0} System.Collections.ArrayList
+ LiveIndexes {Count=0} System.Collections.ArrayList
CaseSensitive false bool
+ ChildRelations
{System.Data.DataRelationCollection.DataTableRelationCollection}
System.Data.DataRelationCollection
+ Columns {System.Data.DataColumnCollection}
System.Data.DataColumnCollection
+ Constraints {System.Data.ConstraintCollection}
System.Data.ConstraintCollection
DataSet null System.Data.DataSet
+ DefaultView {System.Data.DataView} System.Data.DataView
DisplayExpression "" string
EnforceConstraints true bool
+ ExtendedProperties {System.Data.PropertyCollection}
System.Data.PropertyCollection
HasErrors false bool
+ Locale {System.Globalization.CultureInfo} System.Globalization.CultureInfo
MinimumCapacity 50 int
RecordCapacity 128 int
ElementColumnCount 22 int
+ ParentRelations
{System.Data.DataRelationCollection.DataTableRelationCollection}
System.Data.DataRelationCollection
MergingData false bool
nestedParentRelation null System.Data.DataRelation
SchemaLoading false bool
PrimaryKey {Length=0} System.Data.DataColumn[]
+ Rows {System.Data.DataRowCollection} System.Data.DataRowCollection
TableName "" string
EncodedTableName "" string
Namespace "" string
Prefix "" string
XmlText null System.Data.DataColumn
+ MaxOccurs 1 System.Decimal
+ MinOccurs 1 System.Decimal
Site null System.ComponentModel.ISite
zeroRows {Length=0} System.Data.DataRow[]
zeroColumns {Length=0} System.Data.DataColumn[]
Element null System.Xml.XmlBoundElement
RowError "" string
RowState Detached System.Data.DataRowState
+ Table {System.Data.DataTable} System.Data.DataTable
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
+ ItemArray {Length=22} System.Object[]
HasErrors false bool
- this {Mono.Data.MySql.MySqlDataReader} Mono.Data.MySql.MySqlDataReader
- System.MarshalByRefObject {Mono.Data.MySql.MySqlDataReader}
System.MarshalByRefObject
System.Object {Mono.Data.MySql.MySqlDataReader} System.Object
__identity null System.Object
- cmd {Mono.Data.MySql.MySqlCommand} Mono.Data.MySql.MySqlCommand
+ System.ComponentModel.Component {Mono.Data.MySql.MySqlCommand}
System.ComponentModel.Component
sql "SELECT * FROM mono_mysql_test" string
timeout 30 int
+ conn {Mono.Data.MySql.MySqlConnection} Mono.Data.MySql.MySqlConnection
trans null Mono.Data.MySql.MySqlTransaction
cmdType Text System.Data.CommandType
designTime false bool
+ commands {Length=1} string[]
currentQuery 0 int
cmdBehavior Default System.Data.CommandBehavior
disposed false bool
CommandText "SELECT * FROM mono_mysql_test" string
CommandTimeout 30 int
CommandType Text System.Data.CommandType
+ Connection {Mono.Data.MySql.MySqlConnection}
Mono.Data.MySql.MySqlConnection
DesignTimeVisible false bool
Transaction null Mono.Data.MySql.MySqlTransaction
UpdatedRowSource <error: an exception of type:
{System.NotImplementedException} occurred> System.Data.UpdateRowSource
- fieldName {Length=27} string[]
[0] "tinyint_value" string
[1] "smallint_value" string
[2] "mediumint_value" string
[3] "int_value" string
[4] "integer_value" string
[5] "bigint_value" string
[6] "real_value" string
[7] "double_value" string
[8] "float_value" string
[9] "decimal_value" string
[10] "numeric_value" string
[11] "char_value" string
[12] "varchar_value" string
[13] "date_value" string
[14] "time_value" string
[15] "timestamp_value" string
[16] "datetime_value" string
[17] "tinyblob_value" string
[18] "blob_value" string
[19] "mediumblob_value" string
[20] "longblob_value" string
[21] "tinytext_value" string
[22] "text_value" string
[23] "mediumtext_value" string
[24] "longtext_value" string
[25] "enum_value" string
[26] "set_value" string
- fieldType {Length=27} int[]
[0] 1 int
[1] 2 int
[2] 9 int
[3] 3 int
[4] 3 int
[5] 8 int
[6] 5 int
[7] 5 int
[8] 4 int
[9] 0 int
[10] 0 int
[11] 254 int
[12] 253 int
[13] 10 int
[14] 11 int
[15] 7 int
[16] 12 int
[17] 252 int
[18] 252 int
[19] 252 int
[20] 252 int
[21] 252 int
[22] 252 int
[23] 252 int
[24] 252 int
[25] 254 int
[26] 254 int
+ fieldDbType {Length=27} System.Data.DbType[]
- fieldLength {Length=27} uint[]
[0] 4 uint
[1] 6 uint
[2] 9 uint
[3] 11 uint
[4] 11 uint
[5] 20 uint
[6] 22 uint
[7] 22 uint
[8] 12 uint
[9] 10 uint
[10] 17 uint
[11] 2 uint
[12] 5 uint
[13] 10 uint
[14] 8 uint
[15] 14 uint
[16] 19 uint
[17] 255 uint
[18] 65535 uint
[19] 16777215 uint
[20] 16777215 uint
[21] 255 uint
[22] 65535 uint
[23] 16777215 uint
[24] 16777215 uint
[25] 4 uint
[26] 27 uint
- fieldMaxLength {Length=27} uint[]
[0] 1 uint
[1] 1 uint
[2] 1 uint
[3] 3 uint
[4] 1 uint
[5] 1 uint
[6] 3 uint
[7] 3 uint
[8] 3 uint
[9] 5 uint
[10] 5 uint
[11] 2 uint
[12] 4 uint
[13] 10 uint
[14] 8 uint
[15] 14 uint
[16] 19 uint
[17] 2 uint
[18] 2 uint
[19] 2 uint
[20] 5 uint
[21] 1 uint
[22] 5 uint
[23] 4 uint
[24] 4 uint
[25] 3 uint
[26] 13 uint
- fieldFlags {Length=27} uint[]
[0] 32768 uint
[1] 32768 uint
[2] 32768 uint
[3] 32768 uint
[4] 32768 uint
[5] 32768 uint
[6] 32768 uint
[7] 32768 uint
[8] 32768 uint
[9] 32768 uint
[10] 32768 uint
[11] 0 uint
[12] 0 uint
[13] 0 uint
[14] 0 uint
[15] 33889 uint
[16] 0 uint
[17] 144 uint
[18] 144 uint
[19] 144 uint
[20] 144 uint
[21] 16 uint
[22] 16 uint
[23] 16 uint
[24] 16 uint
[25] 256 uint
[26] 2048 uint
dataValue null System.Object[]
open true bool
recordsAffected -1 int
currentQuery 0 int
currentRow -1 int
res 53091472 int
row 0 int
numFields 27 int
numRows 2 int
cmdBehavior Default System.Data.CommandBehavior
disposed false bool
Depth 0 int
IsClosed false bool
RecordsAffected -1 int
FieldCount 27 int
Item <cannot view indexed property> System.Object
Item <cannot view indexed property> System.Object
Ben
Daniel Morgan wrote:
> Hi Ben
>
> I tried looking into the problem. I was not able to duplicate.
> However, I
> do have a suggestion for you to try.
>
> Comment line 174 in MySqlDataReader.cs and see if that works for you.
>
> //schemaRow.AcceptChanges();
>
> -----Original Message-----
> From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
> Behalf Of Ben Clewett
> Sent: Tuesday, November 05, 2002 5:19 AM
> To: mono-list@ximian.com
> Subject: [Mono-list] Mono.Data.MySQL
>
>
>
> Mono,
>
> Been trying to use Mono.Data.MySQL from yesterdays snapshot.
>
> Using both my own code, and that provided in the 'test' directory, I
> keep getting: (Win2000)
>
> "An unhandled exception of type 'System.Data.RowNotInTableException'
> occurred in system.data.dll"
>
> At Line 176 of MySqlDataReader.cs:
>
> " dataTableSchema.Rows.Add (schemaRow); "
>
> Any ideas?
>
>
> ---------------------------------------------------------------------
> Ben Clewett, B.Clewett@roadrunner.uk.com
>
>
> _______________________________________________
> Mono-list maillist - Mono-list@ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
--
---------------------------------------------------------------------
Ben Clewett, B.Clewett@roadrunner.uk.com