Re: [Mono-list] Fwd: Re: [Mono-devel-list] Problem with DbDataAdapter...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexandr Sorokin wrote: I have the same problemm on my .NET application with postgresql. On MS .NET all code work good, but then i start project on Mono, i get the same error System.IndexOutOfRangeException: Array index is out of range. on fill method. Redhat 9.0 Mono 1.1.7 postgresql 8.0, latest npgsql from postgres site. Hi Alexandr! Sorry for late response... Could you try a fix Hubert did today in the message: Re: [Mono-devel-list] Problem with DbDataAdapter... RESOLVED and check if you still get this problem with Npgsql? Please, let us know if you get any other problem. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - Science without religion is lame; religion without science is blind. ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQo3yQv7iFmsNzeXfAQJD5wgApLQWIorDk3lsxpyMDo3PkIrXazbHAQcW rAKbu2sG9Ui8OJW+qUSKVC0toYlRg+Kdact09YrXrFZMkwn0VLyl6IWlNJZgHD6j tyxZhkT8lQHQ07ymIHIh6Z+e6hPMx2fACWB7ct1gyodffZkZJGasYE3ViHL/4pTX 8rT62vWbVgVEReofnsGCSW3ZwQxGauSfUi9v7GxrvJERF5hUCgzHDHZbSId202Lq RdzTlMsFGPzZTOOuH+PgIzVbu2FCPO//mr2BA4Wlb4chQHdr3HAqBh+Jw5Xb4u2z FjNYQBx6wlM4R9eW9hs1lSUVpp6AjFA2WvmihgbqRkeEeFI+67dq5g== =wd7Z -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Fwd: Re: [Mono-devel-list] Problem with DbDataAdapter...
I have the same problemm on my .NET application with postgresql. On MS .NET all code work good, but then i start project on Mono, i get the same error System.IndexOutOfRangeException: Array index is out of range. on fill method. Redhat 9.0 Mono 1.1.7 postgresql 8.0, latest npgsql from postgres site. ... string sqlCmd = ..; DataSet ds = new DataSet(); IDbCommand command = connection.CreateCommand(); command.CommandText = sqlCmd; IDbDataAdapter adapter = new NpgsqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(ds); . I try to check the problemm. This error appear then the sqlCmd contain more then 1 result set (2 or more sql select command), but not in all cases. I have 5 select command, and all of them individually working good. And then i combine the 5 select in 1 sqlCmd, the Fill method of IDbDataAdapter get this error. For testing i try to to trade places selects in sqlCmd, and error is gone!!! But only 4 tables returned to dataset. Then i comment any of 5 select, anyway 4 tables has returned. But then i get others 3,4 or 5 select command, all working good. I don't understand this bug. - Original Message - From: Hubert FONGARNAND [EMAIL PROTECTED] To: mono-devel-list@lists.ximian.com; mono-list@lists.ximian.com Sent: Tuesday, May 17, 2005 5:45 PM Subject: [Mono-list] Fwd: Re: [Mono-devel-list] Problem with DbDataAdapter... -- Message transmis -- Subject: Re: [Mono-devel-list] Problem with DbDataAdapter... Date: Mardi 17 Mai 2005 14:26 From: Hubert FONGARNAND [EMAIL PROTECTED] To: mono-devel-list@lists.ximian.com I've applied your patch... It corrects the problem with my postgresql app... but i get always an error with the same app with oracle : System.IndexOutOfRangeException: Array index is out of range. in 0x00067 System.Data.DataRow:get_Item (System.String columnName, DataRowVersion version) in 0x00015 System.Data.DataRow:get_Item (System.String columnName) in 0x00495 System.Data.Common.DbDataAdapter:BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction missingSchAction, MissingMappingAction missingMapAction, System.Data.Common.DataTableMappingCollection dtMapping) in 0x00059 System.Data.Common.DbDataAdapter:BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:BuildSchema (System.Data.IDataReader,System.Data.DataTable,System.Data.SchemaType) in 0x00087 System.Data.Common.DbDataAdapter:FillTable (System.Data.DataTable dataTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32 counter) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:FillTable (System.Data.DataTable,System.Data.IDataReader,int,int,int) in 0x00117 System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, System.String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) in 0x000ce System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, Int32 startRecord, Int32 maxRecords, System.String srcTable, IDbCommand command, CommandBehavior behavior) in 0x00036 System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, System.String srcTable) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet,string) in 0x00121 MoteurCRM.CProfil:RetourneGroupeCommercial (System.String cnxstring, System.String televendeur_Id) in 0x007e7 FicheClient.Logon:btnValider_Click (System.Object sender, System.EventArgs e) in (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs) Thanks... Le Mardi 17 Mai 2005 12:09, Konstantin Triger a écrit : Agreed, but in fact the provider should set the defaults, not the DataAdapter :-). Regards, Konstantin Triger Sureshkumar T wrote: + bool allowDBNull = value is bool ? (bool)value : false; default allowDBNull should be true ;-) suresh. --- ___ Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir le supprimer et en aviser immédiatement l'expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement interdite. Les communications sur internet n'étant pas sécurisées, l'intégrité de ce message n'est pas assurée et la société émettrice ne peut être tenue pour responsable de son contenu. ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Fwd: Re: [Mono-devel-list] Problem with DbDataAdapter...
-- Message transmis -- Subject: Re: [Mono-devel-list] Problem with DbDataAdapter... Date: Mardi 17 Mai 2005 14:26 From: Hubert FONGARNAND [EMAIL PROTECTED] To: mono-devel-list@lists.ximian.com I've applied your patch... It corrects the problem with my postgresql app... but i get always an error with the same app with oracle : System.IndexOutOfRangeException: Array index is out of range. in 0x00067 System.Data.DataRow:get_Item (System.String columnName, DataRowVersion version) in 0x00015 System.Data.DataRow:get_Item (System.String columnName) in 0x00495 System.Data.Common.DbDataAdapter:BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction missingSchAction, MissingMappingAction missingMapAction, System.Data.Common.DataTableMappingCollection dtMapping) in 0x00059 System.Data.Common.DbDataAdapter:BuildSchema (IDataReader reader, System.Data.DataTable table, SchemaType schemaType) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:BuildSchema (System.Data.IDataReader,System.Data.DataTable,System.Data.SchemaType) in 0x00087 System.Data.Common.DbDataAdapter:FillTable (System.Data.DataTable dataTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32 counter) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:FillTable (System.Data.DataTable,System.Data.IDataReader,int,int,int) in 0x00117 System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, System.String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) in 0x000ce System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, Int32 startRecord, Int32 maxRecords, System.String srcTable, IDbCommand command, CommandBehavior behavior) in 0x00036 System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet dataSet, System.String srcTable) in (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet,string) in 0x00121 MoteurCRM.CProfil:RetourneGroupeCommercial (System.String cnxstring, System.String televendeur_Id) in 0x007e7 FicheClient.Logon:btnValider_Click (System.Object sender, System.EventArgs e) in (wrapper delegate-invoke) System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs) Thanks... Le Mardi 17 Mai 2005 12:09, Konstantin Triger a écrit : Agreed, but in fact the provider should set the defaults, not the DataAdapter :-). Regards, Konstantin Triger Sureshkumar T wrote: + bool allowDBNull = value is bool ? (bool)value : false; default allowDBNull should be true ;-) suresh. --- ___ Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir le supprimer et en aviser immédiatement l'expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement interdite. Les communications sur internet n'étant pas sécurisées, l'intégrité de ce message n'est pas assurée et la société émettrice ne peut être tenue pour responsable de son contenu. ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list