[Mono-list] POSGRESQL / NPGSQL / MONO / DATASET
KiOrKY
KiOrKY <kiorky@goddess-gate.com>
Tue, 8 Jun 2004 14:54:41 +0200
In fact dont help, the goal is to migrate entirely an windows application into mono environnment and the base opf this application is to
dataadpter.fill(dataset)
in anyway, i have tested datareader which work fine !
just a litlle precision :)
mono is a dream, its the last error i have at the moment !
all the classses we need at enterprise are working well !
Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br> a écrit :
> 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.
--
----------------------------
I{ i () r |{ Y
Debian User
---------------------------------------------
-- Mathieu PASQUET
-- Testeur Debian SID
-- irc: #debian-fr / irc.freenode.net port: 6667
-- Site: www.fr.debian.org
---------------------------------------------