From: <oas...@ya...> - 2003-08-15 11:01:43
|
Hello, in a project which uses a Oracle or Interbase database Im using a single connection in two parallel threads. With the OracleConnection class from .NET no transaction is needed and I didnt have multitheading problems so far. As I use ExecuteNonQuery commands, I had to use transactions for the Firebird Net provider. The transaction is now fragile in the two threads. Is there a workaround except of locking the thread or using a single connection object for each thread? Is it right that the autocommit functionality for ExecuteNonQuery as you are thinking of would be threadsafe and hence be a solution? Thanks, OAS From: Carlos Guzman Alvarez <carlosga@te...> Implicit transaction support in 1.5 sources 2003-08-12 14:51 Hello: 1.5 sources has implicit transaction support for FbCommand.ExecuteScalar and FbCommand.ExecuteReader methods, i'm thinking on add it to FbCommand.ExecuteNonQuery method, but i want to know opinions before made it :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain __________________________________________________________________ Gesendet von Yahoo! Mail - http://mail.yahoo.de Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de |