You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Recently we have problem on our aplication when generation long sql
inside transactions like the sample, the problem is the memory
increase and them got a error "Unable to alocate memory from operation
system"
The process fbserver.exe increase his memory use until finish all the
memory from the computer and them the error apears
But if i Dispose de componente DbCommand like is comment on the code
the problem dont hapen,
Code Sample
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using System.Configuration;
using FirebirdSql.Data.FirebirdClient;
namespace WinTestTransaction
{
public partial class Form1 : Form
{
private DbProviderFactory _dbpfactory;
public DbProviderFactory Dbpfactory
{
get { return _dbpfactory; }
set { _dbpfactory = value; }
}
private DbConnection \_dbconn;
public DbConnection Dbconn
\{
get \{ return \_dbconn; \}
set \{ \_dbconn = value; \}
\}
private DbTransaction \_dbtrans;
public DbTransaction Dbtrans
\{
get \{ return \_dbtrans; \}
set \{ \_dbtrans = value; \}
\}
private DbCommand \_dbcmd;
public DbCommand Dbcmd
\{
get \{ return \_dbcmd; \}
set \{ \_dbcmd = value; \}
\}
private DbCommand \_dbcmd2;
public DbCommand Dbcmd2
\{
get \{ return \_dbcmd2; \}
set \{ \_dbcmd2 = value; \}
\}
public Form1\(\)
\{
InitializeComponent\(\);
\}
private void button1\_Click\(object sender, EventArgs e\)
\{
try
\{
Dbpfactory =
Submitted by: Nicolas T (nftimmers)
Hello,
Recently we have problem on our aplication when generation long sql
inside transactions like the sample, the problem is the memory
increase and them got a error "Unable to alocate memory from operation
system"
The process fbserver.exe increase his memory use until finish all the
memory from the computer and them the error apears
But if i Dispose de componente DbCommand like is comment on the code
the problem dont hapen,
Code Sample
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using System.Configuration;
using FirebirdSql.Data.FirebirdClient;
namespace WinTestTransaction
{
public partial class Form1 : Form
{
private DbProviderFactory _dbpfactory;
public DbProviderFactory Dbpfactory
{
get { return _dbpfactory; }
set { _dbpfactory = value; }
}
DbProviderFactories.GetFactory(ConfigurationManager.AppSettings.Get("provider").ToString());
Dbconn = Dbpfactory.CreateConnection();
ConfigurationManager.AppSettings.Get("conexao").ToString();
Dbconn.Open();
TEST(IDCODIGO,TESTE) VALUES ('" + i.ToString() + "','" + i.ToString()
+ "') ";
}
}
The text was updated successfully, but these errors were encountered: