Re: [Firebird-net-provider] Firebird crash due to .Net provider?

[André Jager]

I used "multiple commands". My first thought was to call the dispose as well. So I did, but it did not change the behaviour on the server side. I will try the prepare and see if anything changes. Maybe I did not understand the on-line help and I am doing something wrong. Another side effect is not only the rapidly increasing memory requirement of the Firebird server but as well as the 100% CPU time fbserver.exe consumes.   . . .                        if (Counter > 1)                         {                             Command =                                 "execute procedure ADD_FIELD_SET_DATA('"+SessionId+"', '"+FieldSetName+"', '"+Header[j]+"', '" + Data + "', '"+ObjectId+"')";                         }                         FirebirdSql.Data.Firebird.FbCommand cm =                             new FirebirdSql.Data.Firebird.FbCommand(                             Command, c.Connection, t                             );                         cm.ExecuteNonQuery(); . . . André Jager Carlos Guzmán Álvarez wrote: Hello: I am using an explicit transaction. I tried to insert all data using one transaction and I tried to commit after each insert. Are you using "multiple commands" to do the inserts or a single one that is prepared ?? If you are using "multiple commands" are you calling Dispose ?? Can you post a sample showing how are you doing ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider