KiOrKY wrote:
wan someone help to run npgsql with mono. in fact datareader work fine but not dataapdeter and so dataset!
here is the report: debian sid kernel 2.4.26 mcs 095 mono 20040603 gecko-sharp-0.4 gtksourceview-sharp-0.3 winelib-0.3 gtk-sharp-0.93 libgdiplus-0.8 wine20040505
the base is postgresql and is not on the same machine
the result; out of memory error
DB BASE SHEMA: base postgresql provider: npgsql table popo column: C1: int C2: string
code: try { cout.WriteLine("\t\t---------------------------------------------"); cout.WriteLine("\t\t--- DEBUT APPLICATION -----"); cout.WriteLine("\t\t---------------------------------------------"); string srequet =@"delete from popo;"; srequet+=@"insert into popo(sssss,xdsd)"; srequet+=@"values('59','aaaaa');"; srequet+=@"insert into popo(sssss,xdsd)"; srequet+=@"values('519','aaaaa');"; srequet+=@"insert into popo(sssss,xdsd)"; srequet+=@"values('529','aaaaa');"; srequet+=@"insert into popo(sssss,xdsd)"; srequet+=@"values('359','aaaaa');"; srequet+=@"insert into popo(sssss,xdsd)"; srequet+=@"values('459','aaaaa');"; srequet+=@"SELECT * FROM popo"; string srequet3=@"Server=126.10.0.1;Port=5432;User Id=Pasquet;Database="; srequet3+=@"Marrot;Password=kiorky"; Npgsql.NpgsqlConnection toto = new Npgsql.NpgsqlConnection(srequet3); toto.Open(); Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(srequet,toto); Npgsql.NpgsqlDataAdapter DaAd = new Npgsql.NpgsqlDataAdapter(cmd); DataSet Dsdset = new DataSet(); DaAd.Fill(Dsdset); Dsdset.AcceptChanges(); DataTableCollection dtccol = Dsdset.Tables; foreach(DataTable dtta in dtccol) { cout.WriteLine( dtta.TableName); foreach(DataRow drro in dtta.Rows) { cout.WriteLine("c1: {0} <-> c2: {1} <-> \n",(Int32)drro.ItemArray[0],drro.ItemArray[1]); } } toto.Close();
exectuion report
doldit100:/home/kiorky/bin/jeveux# mono toto.exe ---------------------------------------------
--- DEBUT APPLICATION -----
---------------------------------------------
execption levee: Out of memory
doldit100:/home/kiorky/bin/jeveux# mono --debug toto.exe
** (toto.exe:24747): WARNING **: Symbol file /usr//lib/mono/gac/Accessibility/1.0.5000.0__b03f5f7f11d50a3a/Accessibility.dll has incorrect version (expected 37, got 36)
** (toto.exe:24747): WARNING **: Symbol file /usr//lib/mono/gac/System.Windows.Forms/1.0.5000.0__b77a5c561934e089/System.Windows.Forms.dll has incorrect version (expected 37, got 36)
** (toto.exe:24747): WARNING **: Symbol file /usr//lib/mono/gac/System.Design/1.0.5000.0__b03f5f7f11d50a3a/System.Design.dll has incorrect version (expected 37, got 36)
** (toto.exe:24747): WARNING **: Symbol file /usr//lib/mono/gac/Npgsql/1.0.5000.0__5d8b90d52f46fda7/Npgsql.dll has incorrect version (expected 37, got 36) --------------------------------------------- --- DEBUT APPLICATION ----- --------------------------------------------- ** (toto.exe:24751): WARNING **: Symbol file /usr//lib/mono/gac/Mono.Posix/1.0.5000.0__0738eb9f132ed756/Mono.Posix.dll has incorrect version (expected 37, got 36)
-------------------> execption levee: Out of memory
version:
doldit100:/home/kiorky/bin/jeveux# monodis --assembly
/usr/lib/mono/gac/Npgsql/1.0.5000.0__5d8b90d52f46fda7/Npgsql.dll Assembly Table
Name: Npgsql
Hash Algoritm: 0x00008004
Version: 1.0.5000.0
Flags: 0x00000000
PublicKey: BlobPtr (0x000004b8)
Dump:
0x00000000: 00 24 00 00 04 80 00 00 94 00 00 00 06 02 00 00 0x00000010: 00 24 00 00 52 53 41 31 00 04 00 00 01 00 01 00 0x00000020: 2B 3C 59 0B 2A 4E 3D 34 7E 68 78 DC 0F F4 D2 1E 0x00000030: B0 56 A5 04 20 25 0C 66 17 04 43 30 70 1D 35 C9 0x00000040: 80 78 A5 DF 97 A6 2D 83 C9 A2 DB 2D 07 25 23 A8 0x00000050: FC 49 13 98 25 4C 6B 89 32 9B 8C 1D CE F4 3A 1E 0x00000060: 7A A1 61 53 BC EA 2A E9 A4 71 14 56 24 82 6F 60 0x00000070: D7 C8 E7 1C D0 25 B5 54 A0 17 7B D9 35 A7 80 96 0x00000080: 29 F0 A7 AF C7 78 EB B4 AD 03 3E 1B F5 12 C1 A9 0x00000090: C6 CE EA 26 B0 77 BC 46 CA C9 38 00 43 5E 77 EE Culture:
Hi Kiorky.
Sorry for late response... I was in a conference here in my country and couldn't answer you in time :)
I'm at my job right now and I don't have the complete devel environment setup here...
I will try your example when I get home to see if I get the same results...
I see that you are passing the delete, inserts and select to dataadapter...
could you try to send the delete and inserts first, with NpgsqlCommand.ExecuteNonQuery() and later try to use the dataadapter with select only?
I hope it helps.
Regards,
Francisco Figueiredo Jr.
_______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
