Eureka!!!! After a (sleepy) week I finally got the obvious and great idea of to compile the svn last commit on Mono and my code worked fine. I had compiled the previously assembly on VS2008 with MONO;LINUX directives.
Correct me if necessary, but I think that is a bug to Mono project; PS: Jiri, please, verify this on provider's code. There are another charsets incompatible with mono, like euc-jp and some others that unfortunately I can't to verify to post it. I set the #if (!MONO) #endif to all charsets excepting the Win1252 on my assembly Thanks for help guys! 2010/1/5 João Dias de Carvalho Neto <jdias.bjsoftw...@gmail.com> > Sorry, > > I don't referenced the fd object on my code. > > fd is an instance of FederationUnit Class and this instance isn't null > > the fd Object calls instances FederationUnitDAO class and calls the > PersistObject Method passing it selfs. > > It's funny to see that cause I saw the same code works fine on .Net some > time ago. > > I runned this code on MonoDevelop in Debug mode and I could to browse the > values of fd object and the values of Parameters Collection when the line 3 > runs. I try to alternate the parameter's order but this exception always > raises when the second one Add() method is called > > PS: I am calling this code with explicit transactions causes I don't knew > that it can run without this; > > > 2010/1/5 Luigi Piccinni <luigi.picci...@computeraid.it> > >> Are you sure that “fd” object is not null in line 4? >> >> >> >> Luigi. >> >> >> >> p.s. (Why are you beginning a transaction only to call ExcuteNonQuery on >> the command? The code works just fine even without line 8 and 10) >> >> >> ------------------------------ >> >> *Da:* João Dias de Carvalho Neto [mailto:jdias.bjsoftw...@gmail.com] >> *Inviato:* martedì 5 gennaio 2010 12.40 >> *A:* For users and developers of the Firebird .NET providers >> *Oggetto:* [Firebird-net-provider] Command.Parameters property >> >> >> >> Hi, >> >> I'm using stored procedures in Firebird to do my DAO layer with Active >> Record Pattern. >> >> In this case, I have one stored procedure called SP_UNUFDAO, >> >> Using the Command Object, when I do this code to Persist my Object on FB: >> >> 1 - FbCommand cmd = new FbCommand("SP_UNUFDAO",Connection); >> 2 - cmd.CommandType = CommandType.StoredProcedure; >> 3 - cmd.Parameters.Add("P_ACTION",FbDbType.Smallint).Value = >> CrudAction.Persist.GetHashCode(); >> 4 - cmd.Parameters.Add("P_ACRN",FbDbType.Char,2).Value = fd.Acronym; >> 5 - cmd.Parameters.Add("P_DESC",FbDbType.VarChar,50).Value = >> fd.Description; >> 6 - try >> 7 - { >> 8 - cmd.Transaction = Connection.BeginTransaction(); >> 9 - cmd.ExecuteNonQuery(); >> 10 - cmd.Transaction.Commit(); >> 11 - } >> 12 - catch(Exception e) >> 13 - { >> 14 - throw new Exception(e.Message); >> 15 - } >> >> One Exception raises at line 4, something like "Object Reference not set >> to an instance of object" >> >> What's wrong on my code? >> >> I'm using Firebird 2.1, Mono, and .Net provider 2.51 >> >> thanks >> >> -- >> João Dias de Carvalho Neto >> >> http://www.jdiasneto.blogspot.com >> jdias.bjsoftw...@gmail.com >> >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature database 4744 (20100105) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.eset.com >> >> >> ------------------------------------------------------------------------------ >> This SF.Net email is sponsored by the Verizon Developer Community >> Take advantage of Verizon's best-in-class app development support >> A streamlined, 14 day to market process makes app distribution fast and >> easy >> Join now and get one step closer to millions of Verizon customers >> http://p.sf.net/sfu/verizon-dev2dev >> _______________________________________________ >> Firebird-net-provider mailing list >> Firebird-net-provider@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >> >> > > > -- > João Dias de Carvalho Neto > > http://www.jdiasneto.blogspot.com > jdias.bjsoftw...@gmail.com > -- João Dias de Carvalho Neto http://www.jdiasneto.blogspot.com jdias.bjsoftw...@gmail.com
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
