Thread: [Firebird-net-provider] BeginTransaction problem??

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Now and then we get an exception in "BeginTrancaction".

When I call BeginTransaction(), then I get this error:

at FirebirdSql.Data.Firebird.Gds.GdsTransaction.BeginTransaction()
   at FirebirdSql.Data.Firebird.FbTransaction.BeginTransaction()
   at FirebirdSql.Data.Firebird.FbConnection.BeginTransaction()

(That is all the info that I get)

Some times the exception arise after 5 minutes, and some times the =
exception arise after 30 hours.
Very very random.

It is very hard to re-create the error, but it is 100% sure that the =
error arise at some point.

In my program, I call "myConnection.BeginTransaction()" once every 3 =
second.
(Many hours).

We use:
WinXP SP1
FirebirdSql.Data.Firebird.dll v. 1.5.1437.22333 (.NET 1.1)
Firebird-1.5.0.4027-RC7, running af Super Server.
Microsoft .NET Framework 1.1 v. 1.1.4322

Hope that you can help me with this problem.

Thanks

Regards
Thomas

/// Code snip//////

(It is impossible to send the full code)

My Connection Class that is a singleton:

........................
private FbConnection myConnection;

public static Connection Instance
  {
   get
   {             =20
    if(instance =3D=3D null)
    {
     instance =3D new Connection();    =20
    }//if
    return instance;
   }//get property
  }//property get instance of Connection
 =20

   //constructor
    private Connection()
    {
     try
     {
      myConnectionString =3D getURLToDB();
      myConnection =3D new FbConnection(myConnectionString);      =20
      openConnection();
     }//try
     catch (Exception ex)
     {
      string t =3D ex.Message;
      string t2 =3D ex.StackTrace;
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=

     }//try/catch
  }//constructor
 =20
 =20
 =20
 public bool updateTransaction(string myUpdateQuery)
  {
   try
   {
    myConnection =3D MyConnection;
    transaction =3D myConnection.BeginTransaction();

    myCommandOne =3D new FbCommand(myUpdateQuery, myConnection, =
transaction);=20
    myCommandOne.ExecuteNonQuery();

    transaction.Commit();
    myCommandOne.Dispose();
   }
   catch(Exception eb)
   {  =20
  =20
    =
BusinessComponents.LogToFile.Instance.logALineToFile(eb.StackTrace,true);=

    BusinessComponents.LogToFile.Instance.logALineToFile("This =
SQL-statement was not saved in the database: " + myUpdateQuery,false);
    string t =3D eb.StackTrace;
    transaction.Rollback();
    transaction.Dispose();
    closeConnection();
    openConnection();
    throw eb;
   }//try/catch
   return true;
  }//updateTransaction
 =20
 =20
 =20
  public void closeConnection()
    {
     try
     {
      if (myConnection.State !=3D System.Data.ConnectionState.Closed)
      {
       myConnection.Close();  =20
      }//if
     }//try
     catch (Exception ex)
     { =20
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
=20
      Console.WriteLine(ex.Message);
      Console.WriteLine(ex.StackTrace);
     }//try/catch
  }//closeConnection
 =20
 =20

    public void openConnection()
    {
     try
     {
      if (myConnection.State !=3D System.Data.ConnectionState.Open)
      {
       myConnection.Open();
      }//if
     }//try
     catch(Exception ex)
     { =20
      =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
=20
      Console.WriteLine(ex.Message);
      Console.WriteLine(ex.StackTrace);
     }//try/catch
  }//openConnection
 =20
 =20
   public FbConnection MyConnection
    {
     get
     {  =20
      try
      {
       if (this.connectionCounter > 500)
       {
        if (this.myConnection !=3D null)
        {
         myConnection.Dispose();
         myConnection =3D new FbConnection(myConnectionString);
         openConnection();
         this.connectionCounter =3D 0;
        }//if
       }//if    =20
       else
       {              =20
        if (this.myConnection !=3D null)
        {
         closeConnection();
        }//if
        openConnection();
        this.connectionCounter =3D this.connectionCounter+1;
       }//else    =20
      }//try
      catch (Exception ex)
      {    =20
       =
BusinessComponents.LogToFile.Instance.logALineToFile(ex.ToString(),true);=
    =20
      }//try/catch
      return this.myConnection;
     }//get =20
  }//property myConnection
 =20
 =20
 =20

Thread: [Firebird-net-provider] BeginTransaction problem??

A powerful, cross platform, SQL database system

firebird-net-provider