firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Connection Open Error

[Dick C. <rc...@mo...>]

Carlos Guzm=E1n =C1lvarez wrote:

> Hello:
>=20
>> What conditions would cause the connection.Open() method to fail with=20
>> the exception message: "Invalid PInvoke metadata format"?
>=20
>=20
> Usually gives on bad installations of .NET, or using an 1.1 assembly=20
> with the 1.0 .NET Framework, can give to by a bad compilation of the=20
> assembly, just try to built it from the sources and test it.
>=20
>> I'm also sure that my .NET Provider (RC3)=20
>=20
>=20
> Huuummm ... may be RC1 ??


You suggest that I return to RC1?  I seem to recall reading from the=20
list previously that RC3 is for 1.1 .NET Framework, while RC1 is for=20
1.0.  My system has Visual Studio with 1.0 .NET Framework, but I also=20
manually installed the 1.1 .NET Framework Runtime.

Dick

[Firebird-net-provider] Announce: Firebird .NET Data Provider 1.5 Release Candidate 2 released

[<car...@te...>]

Hello:

Firebird .NET Data Provider 1.5 Release Candidate 2 available for download.

Release Changes:

- Bug fixes.

         ---------------------------------------------------


You can read the Changelog at:

http://sourceforge.net/project/shownotes.php?release_id=206431


You can download binarys for .NET 1.0 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC2-NET1.0.exe?download


You can download binarys for .NET 1.1 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC2-NET1.1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC2-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC2-Doc.zip?download


CVS Tag: NP_1_5_RC2



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Open Error

[<car...@te...>]

Hello:

> What conditions would cause the connection.Open() method to fail with 
> the exception message: "Invalid PInvoke metadata format"?

Usually gives on bad installations of .NET, or using an 1.1 assembly 
with the 1.0 .NET Framework, can give to by a bad compilation of the 
assembly, just try to built it from the sources and test it.

> I'm also sure that my .NET Provider (RC3) 

Huuummm ... may be RC1 ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Connection Open Error

[Dick C. <rc...@mo...>]

Hello,

What conditions would cause the connection.Open() method to fail with 
the exception message: "Invalid PInvoke metadata format"?

I'm pretty sure my Firebird server is running fine (because I have other 
apps using it without any problems).  I'm also sure that my .NET 
Provider (RC3) is ok because I have other apps running on the same 
machine that works fine.  My database (GDB) also seems ok because I have 
no problems directly manipulating it using ISQL.  But whenever I open 
the database programmatically, I'm getting that PInvoke error.

Dick

Re: [Firebird-net-provider] A few major questions

[<car...@te...>]

Hello:

> All the columns are Integer except the "Company" which is blob!

It's Binary Blob or Text blob ?? if it's binary blob you need to give as 
parameter value an array of bytes.

> 2) When can we have the 1.6 version if .net provider?

I can tell only that the first alpha version will be released after the 
1.5 final release ;)

> 3) Can I have the answer of my third question too please?

I have not answered it because i don't know about a tool like you need, 
review here:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1072365966:33158&page=ibp_contrib_download





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] A few major questions

[<car...@te...>]

Hello:

> Can I use the embedded server’s libraries with .net provider?

Not using 1.5 version, but 1.6 version, that is under development yet, 
will work with the embedded server too.

> If yes where can I set which libraries the .net provider 
> should use?

In the 1.6 you can tell to which type of server you are going to 
connect, using the ServerType element in the connectionString:

	ServerType = 0	// Classic or SuperServer
	ServerType = 1	// Embedded server

>             If no, is .net provider a good choice in my case? Will it 
> work as a stand alone application which needs no other servers or 
> services to be installed on client’s machine?

As i tell before it's not possible using 1.5 version of the .net data 
provider.

> Where and how can I make a new firebird account?

Did you mean a new user account for connect to the database ??

if yes you can try to add it using the FbSecurity class of the .NET 
provider, or a Firebird administration tool like IBExpert or Database 
Workbench.

> What could be the problem?

Can you send to me the table structure please ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] A few major questions

[Jeff <in...@we...>]

Hi there.

=20

I=E2=80=99m a vb.net programmer.

=20

I wanted to develop a fast database driven distributable application =
which could be installed on a computer from a cd without installing any =
servers or extra applications

I chose FireBird, and I=E2=80=99m not sure if it=E2=80=99s the best =
choice yet.

=20

I=E2=80=99m using FireBird 1.5 and .net provider Release Candidate 1 ( =
2003-12-07 ) under windows XP Service Pack 1

I know that for my purpose I must use =E2=80=9CThe embedded =
server=E2=80=9D=20

=20

My first question is=20

Can I use the embedded server=E2=80=99s libraries with .net provider?

            If yes where can I set which libraries the .net provider =
should use?

            If no, is .net provider a good choice in my case? Will it =
work as a stand alone application which needs no other servers or =
services to be installed on client=E2=80=99s machine?

=20

=20

My second question is

Where and how can I make a new firebird account?

=20

My third question is

Does firebird provide a tool that acts like =E2=80=9Cprofiler=E2=80=9D =
in Microsoft sql server? I tool that you can see what messages are being =
exchanged from the server to the client? This is very useful for =
debugging.

=20

=20

=20

I=E2=80=99m using the following code to enter data to a table

=20

        Dim connection_string As String =3D =
"Database=3DC:\mydb\AAA.FDB;User=3DSYSDBA;Password=3Dmasterkey;Dialect=3D=
3;Server=3Dlocalhost"

        Dim mainconnection As New FbConnection

        mainconnection =3D New FbConnection(connection_string)

        mainconnection.Open()

=20

        Dim transaction As FbTransaction =3D =
mainconnection.BeginTransaction()

        Dim command As FbCommand =3D New FbCommand("insert into =
TELEPHONENUMBERS =
(NAME,LASTNAME,COMPANY,TELEPHONENUMBER,FAXNUMBER,TELEXNUMBER,EMAILADDRESS=
,WEBSITE,MOBILENUMBER) =
values(@NAME,@LASTNAME,@COMPANY,@TELEPHONENUMBER,@FAXNUMBER,@TELEXNUMBER,=
@EMAILADDRESS,@WEBSITE,@MOBILENUMBER)", mainconnection, transaction)

=20

=20

        command.Parameters.Add("@NAME", 1)

        command.Parameters.Add("@LASTNAME", 2)

        command.Parameters.Add("@COMPANY", "dd")

        command.Parameters.Add("@TELEPHONENUMBER", 41)

        command.Parameters.Add("@FAXNUMBER", 54)

        command.Parameters.Add("@TELEXNUMBER", 2343)

        command.Parameters.Add("@EMAILADDRESS", 123)

        command.Parameters.Add("@WEBSITE", 231)

        command.Parameters.Add("@MOBILENUMBER", 12342)

=20

=20

=20

        command.ExecuteNonQuery()

=20

        transaction.Commit()

=20

But I=E2=80=99m getting the following error:

=20

An unhandled exception of type 'System.InvalidCastException' occurred in =
firebirdsql.data.firebird.dll

Additional information: Specified cast is not valid.

=20

What could be the problem?

Thanks, and happy new year to you all!

Re: [Firebird-net-provider] Command line compile problem

[<car...@te...>]

Hello:

> and the web.config has this:
> <add assembly="FirebirdSql.Data.Firebird, Version=1.5.1437.22333, Culture=neutral, 
> PublicKeyToken=e1b4f92304d7b12f" />

The Version and PublicTokenRing are the same as the assembly has in the 
GAC ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] asp.net example problem

[<car...@te...>]

Hello:

> I am trying to install the provider and use the asp.net example.
> 
> This is in the web.config file:
> 
> Version=1.5.1334.34352, 
> Culture=neutral, 
> PublicKeyToken=e1b4f92304d7b12f"
> 
> But the version does not match the assembly version, which is:
> 
>   1.1.1266.28704

You need to modify the Version and PublicKeyToken with the ones the 
assembly has in your GAC.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Problem: connection with Firebird for Linux

[<car...@te...>]

Hello:

> In this point I have exception:
> An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException' 
> occurred in firebirdsql.data.firebird.dll
> 
> Additional information: I/O error during "open" operation for file 
> "/root/bases/cat.FDB"
> Error while trying to open file.

Are you sure the database filename is correct ?? it's cat.FDB or cat.fdb ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Problem: connection with Firebird for Linux

[Fedor E. S. <FSh...@sp...>]

I have Firebird 1.5 RC7 in Linux Red Hat server. 
Client - Windows XP SP1. 
Provider - Firebird .Net Data Provider 1.5 RC1 for .Net 1.1.

Code:

FbConnection con=new FbConnection("Database=/root/bases/cat.FDB;User=SYSDBA;Dialect=3;"+
 "Charset=UNICODE_FSS;Server=Fire;Password=KgBDRfcU");
con.Open();

In this point I have exception:
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException' 
occurred in firebirdsql.data.firebird.dll

Additional information: I/O error during "open" operation for file 
"/root/bases/cat.FDB"
Error while trying to open file.

But when I try to connect using IBExpert with same parameters I have no 
problems.

Sorry for bad English.
Best regards Fedor,
Moscow Russia 
 

Re: [Firebird-net-provider] Problem with rdb$ tables - possible bug in rc1

[<car...@te...>]

Hello:

> With a Provider 1.1 build: 1.0.1241.28320 the results are ok:

Fixed in CVS, the problem was in a change i have done for try to adjust 
the string readed to the number of real chars in the field character 
set, but this is not valid in the case of System Tables that are 
supposed to be UNICODE_FSS but they report a bad number of bytes (1 per 
character instead of 3 per character).

> btw. How to use restrictions in FbConnection.GetDbSchemaTable?

They works in very similar way to the OleDB provider ones, an example:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

// Retrieve the list of SYSTEM TABLES
// Restrictions allowed:
//	TABLE_NAME
//	TABLE_TYPE
//	SYSTEM TABLE
DataTable schema = connection.GetDbSchemaTable(
	FbDbSchemaType.Tables,
	new object[] {null, null, 1});

foreach (DataRow row in schema.Rows)
{
	foreach (DataColumn column in schema.Columns)
	{
		Console.Write("{0} \t", row[column.ColumnName]);
	}
	Console.WriteLine("");
}

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Problem with rdb$ tables - possible bug in rc1

[Tomasz B. <t.b...@cb...>]

Hi,

I found a bug in Provider 1.5 RC1 version.
I seems to affect only queries to system tables.
The following code:
<code>
using System;
using System.Data;
//Provider 1.1 build: 1.0.1241.28320 - ok
//Provider 1.5 RC1 build: 1.5.1437.22333 - bug
using FirebirdSql.Data.Firebird;
namespace BugInProvider
{
  class Class1
    {
	static void Main(string[] args)
	{
	string ConnectionString = "connectionstring"

     //query taken from DbSchemaFactory 
     string strSql = "SELECT rdb$relation_name AS TABLE_NAME, rdb$view_blr
AS TABLE_TYPE, rdb$system_flag AS SYSTEM_TABLE, rdb$owner_name AS
OWNER_NAME, rdb$description AS DESCRIPTION FROM rdb$relations ORDER BY
rdb$system_flag, rdb$owner_name, rdb$relation_name";

	FbConnection cn = new FbConnection(ConnectionString);
	cn.Open();
	FbCommand cmd = new FbCommand(strSql,cn,cn.BeginTransaction());
	FbDataReader rdr = cmd.ExecuteReader();
	while (rdr.Read())
	{
	   System.Console.WriteLine("Table_name: {0}",rdr.GetValue(0));
	}
	rdr.Close();
	cmd.Transaction.Rollback();
	cn.Close();
	System.Console.ReadLine();
		
}
}
 }
</code>
Produces output like this:

Table_name: RDB$FILTER
Table_name: RDB$FORMAT
Table_name: RDB$FUNCTI
Table_name: RDB$FUNCTI
Table_name: RDB$GENERA
Table_name: RDB$INDEX_
Table_name: RDB$INDICE

The size is trimmed to 10 chars

With a Provider 1.1 build: 1.0.1241.28320 the results are ok:

Table_name: RDB$FILTERS
Table_name: RDB$FORMATS
Table_name: RDB$FUNCTIONS
Table_name: RDB$FUNCTION_ARGUMENTS
Table_name: RDB$GENERATORS
Table_name: RDB$INDEX_SEGMENTS
Table_name: RDB$INDICES

btw. How to use restrictions in FbConnection.GetDbSchemaTable?

Best regards
PS. Sorry for English.
--
Tomasz (Tom) Bogucki 
Fundacja CBOS
Warsaw,Poland

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

[<car...@te...>]

Hello:

 > Now I have re-created the problem.

Thanks very much.

At the end of this email is the sample i am going to use for test this, 
based on the test case you have sent, tell to me if you think that it's 
not correct.

Note that i have added this code:

	finally
	{
		if (myCommand != null)
		{
			myCommand.Dispose();
			myCommand = null;
		}
	}

to loadAllScaleHavePipe() for Dispose the command resources.

I have noticed too that in loadAllScaleHavePipe() when an exception 
occurs you closing and opening the connection, any special reason for 
this ?? ( i am curious :) )


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain


using System;
using System.Collections;
using System.Data;

using FirebirdSql.Data.Firebird;

namespace FirebirdSql.Data.Firebird
{
	public class Test
	{
		private int				connectionCounter;
		private string			myConnectionString;
		private FbConnection	myConnection;
		private FbTransaction	transaction;
		private FbDataReader	myReader;
		private FbCommand	myCommand;

		public Test()
		{
			myConnectionString =
				@"Database=localhost/3050:TEST.FDB;" +
				"User=SYSDBA;" +
				"Password=masterkey;" +
				"Dialect=3;" +
				"Charset=NONE;" +
				"Pooling=true;" +
				"Connection Lifetime=30;" +
				"Role=;";
		}

		public static void Main(string[] args)
		{
			Test t = new Test();

			for (int i = 0; i < 10000; i++)
			{
				t.loadAllScaleHavePipe();
			}
		}	

		public Hashtable loadAllScaleHavePipe()
		{
			// ScaleHavePipe scalehavepipe = null;
			Hashtable HT = new Hashtable();

			myConnection = this.MyConnection;

			string mySelectQuery = "SELECT * FROM updates";

			try
			{
				transaction = myConnection.BeginTransaction();
				myCommand = new FbCommand(
					mySelectQuery,
					myConnection,
					transaction);
				myReader = myCommand.ExecuteReader();

				while (myReader.Read())
				{
					/*
					scalehavepipe = new 
ScaleHavePipe((int)myReader["id"],(int)myReader["scaletype"],
						(int)myReader["scale_id"],(int)myReader["pipe_id"]);

					HT.Add(scalehavepipe.Id, scalehavepipe);
					*/
				}//while
				myReader.Close();
				transaction.Commit();
			}
			catch(Exception eb)
			{
				Console.WriteLine(eb.Message + " - " + eb.Source + " - " + 
eb.StackTrace + " - " + eb.InnerException);
				// BusinessComponents.LogToFile.Instance.logALineToFile(eb.Message + 
" - " + eb.Source + " - " + eb.StackTrace + " - " + eb.InnerException,true);

				if (eb is FbException)
				{
					FbException myException = (FbException)eb;
					// BusinessComponents.LogToFile.Instance.logALineToFile("This is a 
FbException: Message: "+myException.Message + " - Stacktrace: " + 
myException.StackTrace + " -  Source: " +myException.Source + " - 
InnerException:" + myException.InnerException + " - ErrorCode: " + 
myException.ErrorCode,true);
					Console.WriteLine("This is a FbException: Message: 
"+myException.Message + " - Stacktrace: " + myException.StackTrace + " - 
  Source: " +myException.Source + " - InnerException:" + 
myException.InnerException + " - ErrorCode: " + myException.ErrorCode);
					if (myException.Errors.Count == 0)
					{
						// 
BusinessComponents.LogToFile.Instance.logALineToFile("myException.Errors.Count 
is 0 ",true);
					}
					for (int i=0; i < myException.Errors.Count; i++)
					{
						// BusinessComponents.LogToFile.Instance.logALineToFile("Index #" 
+ i + "\n" +"Error: " + myException.Errors[i].ToString() + "\n",true);
					}

				}
				else
				{
					// BusinessComponents.LogToFile.Instance.logALineToFile("Message: 
"+eb.Message + " - Stacktrace: " + eb.StackTrace + " -  Source: " 
+eb.Source + " - InnerException:" + eb.InnerException,true);
					Console.WriteLine("Message: "+eb.Message + " - Stacktrace: " + 
eb.StackTrace + " -  Source: " +eb.Source + " - InnerException:" + 
eb.InnerException);
				}
				myConnection.Close();
				myConnection.Open();

				throw eb;
			}//try/catch
			finally
			{
				if (myCommand != null)
				{
					myCommand.Dispose();
					myCommand = null;
				}
			}

			return HT;
		}//loadAllScaleHavePipe

		public FbConnection MyConnection
		{
			get
			{
				try
				{
					if (this.connectionCounter > 500)
					{
						if (this.myConnection != null)
						{
							myConnection.Dispose();
							myConnection = new FbConnection(myConnectionString);
							myConnection.Open();
							this.connectionCounter = 0;
						}//if
					}//if
					else
					{
						if (this.myConnection != null)
						{
							myConnection.Close();
						}//if
						
						myConnection.Open();
						
						this.connectionCounter = this.connectionCounter+1;
					}//else
				}//try
				catch (Exception eb)
				{
					if (eb is FbException)
					{
						FbException myException = (FbException)eb;
						// BusinessComponents.LogToFile.Instance.logALineToFile("This is a 
FbException: Message: "+myException.Message + " - Stacktrace: " + 
myException.StackTrace + " -  Source: " +myException.Source + " - 
InnerException:" + myException.InnerException + " - ErrorCode: " + 
myException.ErrorCode,true);
						Console.WriteLine("This is a FbException: Message: 
"+myException.Message + " - Stacktrace: " + myException.StackTrace + " - 
  Source: " +myException.Source + " - InnerException:" + 
myException.InnerException + " - ErrorCode: " + myException.ErrorCode);
						if (myException.Errors.Count == 0)
						{
							// 
BusinessComponents.LogToFile.Instance.logALineToFile("myException.Errors.Count 
is 0 ",true);
						}
						for (int i=0; i < myException.Errors.Count; i++)
						{
							// BusinessComponents.LogToFile.Instance.logALineToFile("Index #" 
+ i + "\n" +"Error: " + myException.Errors[i].ToString() + "\n",true);
						}

					}
					else
					{
						// BusinessComponents.LogToFile.Instance.logALineToFile("Message: 
"+eb.Message + " - Stacktrace: " + eb.StackTrace + " -  Source: " 
+eb.Source + " - InnerException:" + eb.InnerException,true);
						Console.WriteLine("Message: "+eb.Message + " - Stacktrace: " + 
eb.StackTrace + " -  Source: " +eb.Source + " - InnerException:" + 
eb.InnerException);
					}
				}//try/catch

				return this.myConnection;
			}//get
		}//property myConnection
	}
}

[Firebird-net-provider] BeginTransaction problem??

[Thomas <ja...@ma...>]

Hi Carlos

Now I have re-created the problem.

This log line:=20
Console.WriteLine(eb.Message + " - " + eb.Source + " - " + eb.StackTrace =
+ " - " + eb.InnerException);

prints this message:
21:54:56.140 - Message: Object reference not set to an instance of an =
object. - Stacktrace:    at =
FirebirdSql.Data.Firebird.Gds.GdsTransaction.BeginTransaction()  at =
FirebirdSql.Data.Firebird.FbTransaction.BeginTransaction()    at =
FirebirdSql.Data.Firebird.FbConnection.BeginTransaction()    at =
Tricon.Funki.PDBServer.DataAccessLogicComponents.LoadStatements.loadAllSc=
aleHavePipe() in =
c:\vss\funki\pdbserver\tricon.funki.pdbserver\dataaccesslogiccomponents\l=
oadstatements.cs:line 2509 -  Source: FirebirdSql.Data.Firebird - =
InnerException:

(The InnerException is empty.)


In this test case, the same code runs 288 times.
In loop 289 the exception arised.



My code:

(loadAllScaleHavePipe() failed in loop no. 289.)



public Hashtable loadAllScaleHavePipe()
  {
   ScaleHavePipe scalehavepipe =3D null;
   Hashtable HT =3D new Hashtable();
  =20
   myConnection =3D Connection.Instance.MyConnection;

   mySelectQuery =3D "SELECT * FROM scalehavepipe";

   try
   {         =20
    transaction =3D myConnection.BeginTransaction();  <---- ERROR ?
    myCommand =3D new FbCommand(mySelectQuery, myConnection, =
transaction);       =20
    myReader =3D myCommand.ExecuteReader();
   =20
    while (myReader.Read())
    {
     scalehavepipe =3D new =
ScaleHavePipe((int)myReader["id"],(int)myReader["scaletype"],
      (int)myReader["scale_id"],(int)myReader["pipe_id"]);

     HT.Add(scalehavepipe.Id, scalehavepipe);
    }//while
    myReader.Close();=20
    transaction.Commit();
   }
   catch(Exception eb)
   {   =20
    Console.WriteLine(eb.Message + " - " + eb.Source + " - " + =
eb.StackTrace + " - " + eb.InnerException);
    BusinessComponents.LogToFile.Instance.logALineToFile(eb.Message + " =
- " + eb.Source + " - " + eb.StackTrace + " - " + =
eb.InnerException,true);

    if (eb is FbException)
    {
     FbException myException =3D (FbException)eb;    =20
     BusinessComponents.LogToFile.Instance.logALineToFile("This is a =
FbException: Message: "+myException.Message + " - Stacktrace: " + =
myException.StackTrace + " -  Source: " +myException.Source + " - =
InnerException:" + myException.InnerException + " - ErrorCode: " + =
myException.ErrorCode,true);
     Console.WriteLine("This is a FbException: Message: =
"+myException.Message + " - Stacktrace: " + myException.StackTrace + " - =
 Source: " +myException.Source + " - InnerException:" + =
myException.InnerException + " - ErrorCode: " + myException.ErrorCode);
     if (myException.Errors.Count =3D=3D 0)
     {
      =
BusinessComponents.LogToFile.Instance.logALineToFile("myException.Errors.=
Count is 0 ",true);
     }
     for (int i=3D0; i < myException.Errors.Count; i++)
     {     =20
      BusinessComponents.LogToFile.Instance.logALineToFile("Index #" + i =
+ "\n" +"Error: " + myException.Errors[i].ToString() + "\n",true);     =20
     }
    =20
    }
    else
    {    =20
     BusinessComponents.LogToFile.Instance.logALineToFile("Message: =
"+eb.Message + " - Stacktrace: " + eb.StackTrace + " -  Source: " =
+eb.Source + " - InnerException:" + eb.InnerException,true);
     Console.WriteLine("Message: "+eb.Message + " - Stacktrace: " + =
eb.StackTrace + " -  Source: " +eb.Source + " - InnerException:" + =
eb.InnerException);
    }
    Connection.Instance.closeConnection();
    Connection.Instance.openConnection();
    throw eb;
   }//try/catch
   return HT;
  }//loadAllScaleHavePipe
 =20
 =20
 =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 eb)
      {    =20
  =20
       if (eb is FbException)
       {
        FbException myException =3D (FbException)eb;    =20
        BusinessComponents.LogToFile.Instance.logALineToFile("This is a =
FbException: Message: "+myException.Message + " - Stacktrace: " + =
myException.StackTrace + " -  Source: " +myException.Source + " - =
InnerException:" + myException.InnerException + " - ErrorCode: " + =
myException.ErrorCode,true);
        Console.WriteLine("This is a FbException: Message: =
"+myException.Message + " - Stacktrace: " + myException.StackTrace + " - =
 Source: " +myException.Source + " - InnerException:" + =
myException.InnerException + " - ErrorCode: " + myException.ErrorCode);
        if (myException.Errors.Count =3D=3D 0)
        {
         =
BusinessComponents.LogToFile.Instance.logALineToFile("myException.Errors.=
Count is 0 ",true);
        }
        for (int i=3D0; i < myException.Errors.Count; i++)
        {     =20
         BusinessComponents.LogToFile.Instance.logALineToFile("Index #" =
+ i + "\n" +"Error: " + myException.Errors[i].ToString() + "\n",true);   =
  =20
        }
      =20
       }
       else
       {    =20
        BusinessComponents.LogToFile.Instance.logALineToFile("Message: =
"+eb.Message + " - Stacktrace: " + eb.StackTrace + " -  Source: " =
+eb.Source + " - InnerException:" + eb.InnerException,true);
        Console.WriteLine("Message: "+eb.Message + " - Stacktrace: " + =
eb.StackTrace + " -  Source: " +eb.Source + " - InnerException:" + =
eb.InnerException);
       }
 =20
      }//try/catch
      return this.myConnection;
     }//get =20
  }//property myConnection



I cannot see why a "Object reference not set to an instance of an =
object" should come after 288 loops.



Thanks

Regards
Thomas

-------------------------------------------------------------------------=
-------------------------------------------------------------------------=
--------------------------------------------------------


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

Re: [Firebird-net-provider] How to use FbCommand with parameters ?

[<car...@te...>]

Hello:

> I get an Array out of Bounds Exception. What am I doing wrong ?

I have tested your code with success, which version of the .NET Provider 
are you using ?? Can you send the Stack trace of the Exception ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

P.S: FbDbType.Text is for ascii blobs, for varchar fields you
can use FbDbType.VarChar that is more correct given the field datatype.

[Firebird-net-provider] How to use FbCommand with parameters ?

[Oliver E. <oe...@en...>]

Hi,
 
I tried to use a FbCommand to insert a single row into my database.
 
My DB is
 
CREATE TABLE (
   A_DISTRIBUTOR_ID Integer NOT NULL,
  A_salutation varchar(10),
  Primary key A_DISTRIBUTOR_ID
)
 
And my C#-Code is:
                  _cmdText = "INSERT INTO
T_DISTRIBUTOR(A_DISTRIBUTOR_ID,A_SALUTATION) ";
                  _cmdText += " VALUES(32,?) ";
 
                  _connection = new
FirebirdSql.Data.Firebird.FbConnection(m_ConnectString);
                  _command = new
FirebirdSql.Data.Firebird.FbCommand(_cmdText,_connection);
           
 
_command.Parameters.Add("salutation",FirebirdSql.Data.Firebird.FbDbType.Text
).Value = "blah";
      
                  _connection.Open();
                  _command.ExecuteNonQuery();
                  _connection.Close();
 
 
I get an Array out of Bounds Exception. What am I doing wrong ?
 
 

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> I'm thinking on rework the connection pool in 1.6 for allow max and min 
> pool sizes, ...

I have added an initial implementation of this on 1.6 CVS sources, i 
have done only some basic tests, i will try to do some tests this weekend ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> I also noticed that the connection pool is not application-wide.. connecting
> from different classes results in having different connections. Is this as
> designed (or probably my fault-design)?

Different connection strings will result in different connections, if 
finally i change the Connection Pool in the 1.6 sources different 
connection string will result in different Connection Pools as in 
SqlClient provider ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

""Alessandro Petrelli"" <pet...@in...> wrote in message
news:brv0ud$7lf$1...@ne......
> ""Alessandro Petrelli"" <pet...@in...> wrote in message
> news:brv0hd$7ha$1...@ne......
> > "Carlos Guzmán Álvarez" <car...@te...> wrote in message
> > news:3FE...@te......
> >
> > > Can you retry with latest CVS sources i think it will work correctly
now
> > > :) if not let me know, please.
> >
> > It seems it is not working, using IBExpert I see the user under active
> > users.
>
> I also noticed that the connection pool is not application-wide..
connecting
> from different classes results in having different connections. Is this as
> designed (or probably my fault-design)?

I feel a bit stupid... sorry, I was not disposing the connection :-)...
don't know the reason, I hope to find one asap :-))))

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

""Alessandro Petrelli"" <pet...@in...> wrote in message
news:brv0hd$7ha$1...@ne......
> "Carlos Guzmán Álvarez" <car...@te...> wrote in message
> news:3FE...@te......
>
> > Can you retry with latest CVS sources i think it will work correctly now
> > :) if not let me know, please.
>
> It seems it is not working, using IBExpert I see the user under active
> users.

I also noticed that the connection pool is not application-wide.. connecting
from different classes results in having different connections. Is this as
designed (or probably my fault-design)?

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FE...@te......

> Can you retry with latest CVS sources i think it will work correctly now
> :) if not let me know, please.

It seems it is not working, using IBExpert I see the user under active
users.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Connection Pooling questions

[<car...@te...>]

Hello:

> Not at all, because the applications I'm referring to have been built with
> the 1.0 version of the provider. Maybe I'll try with that version.

1.0 needs to work ok :) the bug was added by me in 1.5 version, when i 
moved the lifetime stuff to GdsAttachParams :(




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Pooling questions

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FE...@te......
>
> Connection Lifetime is specified in seconds, there are a cleanup thread
> that is running at every 10 seconds.

Perfect!

> I'm thinking on rework the connection pool in 1.6 for allow max and min
> pool sizes, ...
>
> Can you retry with latest CVS sources i think it will work correctly now
> :) if not let me know, please.

Not at all, because the applications I'm referring to have been built with
the 1.0 version of the provider. Maybe I'll try with that version.

Thanks.

Ciao,
Alessandro Petrelli.

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

[<car...@te...>]

Hello:

> 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()

What is the Exception message :) ??

Can you change your log code for anything like this:

BusinessComponents.LogToFile.Instance.logALineToFile(ex.Message,true);

or

BusinessComponents.LogToFile.Instance.logALineToFile(
	ex.Message + "\r\n" + ex.StackTrace + "\r\n" + ex.Source, true);

FbException class has two properties that can be of help:

	- ErrorCode ( main error code sent by the Firebird Server if the inner 
exception is GdsException )

	- Errors ( list of individual errors received from the Firebird Server 
if inner exception is GdsException )



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain