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

Re: [Firebird-net-provider] Using IsolationLevel.RepeatableRead transaction

[Carlos G. A. <car...@te...>]

Hello:

> Is it working? Because when I start transaction with 
> IsolationLevel.RepeatableRead, it doesn't put any lock on the records 
> (it should put a lock on updating, allows inserting). If I'm using 
> IsolationLevel.Serializable, it works fine (locks from updating and 
> inserting).


RepeteableRead isolation level in the .NET provider is configured using:

	isc_tpb_write
	isc_tpb_wait
	isc_tpb_concurrency


-- 
Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] VS Studio Error Message (Assembly could not be loaded)

[Carlos G. A. <car...@te...>]

Hello:

> Again, documentaion support for newbies is soooooooo
> poor! :)

RC2 and RC3 binares was built using .NET Framework 1.1, if you are using 
VS 2002 you need to build the provider sources using .NET Framework 1.0, 
for this you need to download NAnt ( nant.sourceforge.net )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Firebird Services API implementation.

[Carlos G. A. <car...@te...>]

Hello:

> its better to do for each function own class, becouse if you want to 
> implement FbPermissions you will need this...

Thanks


-- 
Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] VS Studio Error Message (Assembly could not be loaded)

[Paul D. <pau...@ya...>]

Hello all!

I'm kind a newbie to Dot Net. I've done some
programming with Visual Basic 6 connecting to Firebird
trough serveral OLEBD Prividers. Now I've decided to
switch to Dot Net, trough Visual Basic.Net from VS.NET
2002, and I've got also the Firebird Net Provider.

First: I've searched the mailing list, trying to
figure out if Firebird will be showed in the Server
Explorer in Visual Studio, but I couldn't find a
reference to that. I still don't know. Wouldn't it be
nice if this would be shown somewhere in the
documentation?

Second: I've just reinstalled my computer from
scratch. Windows 2000 Professional SP3, Firebird 1.02
Client, Visual Studio.NET 2002,
FirebirdNetProvider-1.0-RC3. When I'm trying to
reference the provider (Right-click on the Data Tab ->
Customize Toolbox... -> .NET Framwork Components Tab
-> Browse to FirebirdSql.Data.Firebird.dll) I got an
error message saying "The assembly 'C:\Program
Files\FirebirdNetProvider\FirebirdSql.Data.Firebird.dll'
could not be loaded. Check that any dependencies the
file requires are installed." What is missing, what
should I do? Or I am doing the wrong way?

Again, documentaion support for newbies is soooooooo
poor! :)

Best regards,
Paul




__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Re: [Firebird-net-provider] Firebird Services API implementation.

[Pavol S. <pa...@st...>]

Hi,

its better to do for each function own class, becouse if you want to 
implement FbPermissions you will need this...

p.

Re: [Firebird-net-provider] Firebird Services API implementation.

[Carlos G. A. <car...@te...>]

Hello:

> Are you going to provide 2 different assemblies or only 1?
> I think having 2 assemblies would provide the option of installing only the
> needed set.

My first idea is to release only one assembly but depending on resulting 
Services class hierarchy can be better to provide two assemblys.

> Thanks for this wonderful piece of software. It works very well, I'm going
> to use it in a large project.

Thanks to you :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Firebird Services API implementation.

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3EB...@te......
> Hello:
>
>
> I'm implementing in the C# GDS implementation methods for handle
> Services API of Firebird, now i want to know people thoughts on some
> questions:
>
> 1. It's interesting or not to make a set or clasess wrapping the
> Services API ??
>
> 2. If asnwer to the first question is Yes, how we can implement it:
> 2.1 As a single public class called FbServices and let people to wrap it.
>
> 2.2 Make a set of classes wrapping the Services funcionaluty, for
> example FbBackup, FbRestore, FbXXXXX, and here we need to think if we
> want to wrap all the funcionaly or only some things and how to expose
> the funcionality ( like Services API constants ).
>
> 2.3 Other ??
>
>
> My answers are:
>
> 1. Yes.

Agree.

> 2. I think method 2.2 it's better.

Agree.

Are you going to provide 2 different assemblies or only 1?
I think having 2 assemblies would provide the option of installing only the
needed set.

Thanks for this wonderful piece of software. It works very well, I'm going
to use it in a large project.

Regards,
Alessandro Petrelli.

Re: [Firebird-net-provider] Array support in 1.1

[Carlos G. A. <car...@te...>]

Hello:

> I think i have it fixed in my local tree, i will commit it into CVS when 
> i have made the Nunit tests.

Commited, if you can please test it.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Using IsolationLevel.RepeatableRead transaction

[Danieius J. <ju...@ka...>]

Is it working? Because when I start transaction with 
IsolationLevel.RepeatableRead, it doesn't put any lock on the records 
(it should put a lock on updating, allows inserting). If I'm using 
IsolationLevel.Serializable, it works fine (locks from updating and 
inserting).
Maybe Firebird doesn't support such a lock?
-- 
Danieius Jurna
ju...@ka...

Re: [Firebird-net-provider] Array support in 1.1

[Carlos G. A. <car...@te...>]

Hello:

> I have an array column of 12000 integers because is the maximum number of
> elements.
> The problem is that not always my arrays contain the 12000 values. Can I
> insert a new
> row with less values without generating an exception? What about partial
> updates?

I think i have it fixed in my local tree, i will commit it into CVS when 
i have made the Nunit tests.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Array support in 1.1

[Jesus A. <ja...@er...>]

Hi all,

I am playing with the capabilities of the array data type with the
development version 1.1.
I need it because I would like to retrieve data segments using the indexes
instead of using
blobs and relying on the offset.

I have an array column of 12000 integers because is the maximum number of
elements.
The problem is that not always my arrays contain the 12000 values. Can I
insert a new
row with less values without generating an exception? What about partial
updates?

Anybody else is playing with arrays?

Regards,
Jesus

Re: [Firebird-net-provider] Command Builder with Concurrency support

[Carlos G. A. <car...@te...>]

HEllo:

> I'm using sql statment, to check for concurrency as suggested in .NET 
> documentation:
> "update table set ID=?, Item=? where (ID=?) and (Item=?)"
> And 2 last parameters with System.Data.DataRowVersion.Original option.
> Everything works fine. But it would be nice if command builder would 
> build a similal update command. Now it builds a plain update command 
> without concurrency implementation.
> Or maybe there is some other way to implement concurrency?

I will try to see that.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Command Builder with Concurrency support

[Danieius J. <ju...@ka...>]

I'm using sql statment, to check for concurrency as suggested in .NET 
documentation:
"update table set ID=?, Item=? where (ID=?) and (Item=?)"
And 2 last parameters with System.Data.DataRowVersion.Original option.
Everything works fine. But it would be nice if command builder would 
build a similal update command. Now it builds a plain update command 
without concurrency implementation.
Or maybe there is some other way to implement concurrency?
-- 
Danieius Jurna
ju...@ka...

[Firebird-net-provider] Firebird Services API implementation.

[Carlos G. A. <car...@te...>]

Hello:


I'm implementing in the C# GDS implementation methods for handle 
Services API of Firebird, now i want to know people thoughts on some 
questions:

	1. It's interesting or not to make a set or clasess wrapping the 
Services API ??

	2. If asnwer to the first question is Yes, how we can implement it:
	2.1 As a single public class called FbServices and let people to wrap it.

	2.2 Make a set of classes wrapping the Services funcionaluty, for 
example FbBackup, FbRestore, FbXXXXX, and here we need to think if we 
want to wrap all the funcionaly or only some things and how to expose 
the funcionality ( like Services API constants ).

	2.3 Other ??


My answers are:

	1. Yes.

	2. I think method 2.2 it's better.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Problem with Connection

[Christopher W. <chr...@ad...>]

Hi Carlos,

I had problems logging into CVS earlier, but I was able to connect a few
minutes ago.  I recompiled the dll for framework 1.0 and was able to
verify that the problem I was having is now fixed.

Thanks a lot!

Chris Whelan


On Thu, 2003-05-08 at 05:55, Carlos Guzman Alvarez wrote:
> Hello:
> 
> > How should I handle this problem as it seems that I cannot close or free
> > this connection because it is in limbo?
> 
> I have commited a fix for this into the CVS if you can please test it.
> 

Re: [Firebird-net-provider] Problem with Connection

[Carlos G. A. <car...@te...>]

Hello:

> How should I handle this problem as it seems that I cannot close or free
> this connection because it is in limbo?

I have commited a fix for this into the CVS if you can please test it.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Problem with Connection

[Christopher W. <chr...@ad...>]

Hi-

I am having the following problem with the FbConnection class:

For testing purposes, I intentionally call fbConn.Open() with a
connection string that contains an invalid user or password.  It is also
set not to pool.  The invalid user/password causes an exception to be
thrown that I catch. 

In the catch block I call fbConn.Close().  I then change the
user/password and try again.  This time when fbConn.Open() is called on
the same instance, a different exception is
thrown that says the connection is already open.  The ConnectionState on
the connection appears to be permanently stuck on "Connecting".  

I looked at the source code for FbConnection.Close() and it appears that
it ignores any ConnectionState other than "Open".

If I change the source in FbConnection.Close() initial if() statement to
include ConnectionState.Connecting, I get an invalid database handle
exception.

How should I handle this problem as it seems that I cannot close or free
this connection because it is in limbo?

Thanks.

Chris Whelan

Re: [Firebird-net-provider] 'System.TypeLoadException' with RC3

[Carlos G. A. <car...@te...>]

Hello:

 > I am getting the same System.TypeLoad exception with RC3 as someone 
else did previously with RC2.  I compiled the .Net Provider from source 
forcing NAnt to compile using the 1.1 version of the framework.  I am 
using visual studio 2002, but I have not encountered this problem with 
any other programs that are using PInvoke under the covers.
 >
 > Any assistance with this problem would be greatly appreciated.  Thanks.


If you are using VS 2002 you need to build the provider sources using 
.NET Framework 1.0 ( as i know VS 2002 works only with .NET Framework 1.0 )





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] 'System.TypeLoadException' with RC3

[Chris W. <chr...@ad...>]

Hi-

I am getting the same System.TypeLoad exception with RC3 as someone else =
did previously with RC2.  I compiled the .Net Provider from source =
forcing NAnt to compile using the 1.1 version of the framework.  I am =
using visual studio 2002, but I have not encountered this problem with =
any other programs that are using PInvoke under the covers.

Any assistance with this problem would be greatly appreciated.  Thanks.


-Chris Whelan

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Carlos G. A. <car...@te...>]

Hello:

> Does anyone see what I am doing wrong here?

I'm trying to reproduce it ( without luck at this moment ), can you send 
the message and stack trace of the exception ??, please.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] [ANN] Firebird .NET Data Provider Release Candidate 3 available for download.

[Carlos G. A. <car...@te...>]

Hello:

Firebird .NET Data Provider Release Candidate 3 available for download.


You can view the changelog at:

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


You can download binarys at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC3.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC3-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNetProvider-1.0-RC3-Doc.zip?download




CVS Tag:

NP1_0_RC3




-- 
Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Using Firebird embed win32

[Carlos G. A. <car...@te...>]

Hello:

> I have made no test with the embedded server and the .NET Provider, i 
> will try to do that next week.

I'm reading the README file of the embedded server and i think the NET 
Provider will not work with it, because NET provider has his own 
implementation of the GDS ( Firebird API ).





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Using Firebird embed win32

[Carlos G. A. <car...@te...>]

Hello:

> Hello, I get the same exception when trying to connect to the database. Can
> the .Net Data Provider connect to the embedded server?

I have made no test with the embedded server and the .NET Provider, i 
will try to do that next week.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

[Carlos G. A. <car...@te...>]

Hello:


I'm making test without problems, can you tell me if this is correct 
test case, please:


public static void Main(string[] args)
{			
	string connectionString =
		@"Database=D:\TESTDB.GDB;" +			
		"User=SYSDBA;"		+
		"Password=masterkey;";

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

	FbTransaction transaction = connection.BeginTransaction();		

	string commandText = "select * from TEST_TABLE_01 where int_field 
= @ID";				

	FbCommand command = new FbCommand(commandText, connection,transaction);

	command.Parameters.Add("@ID", FbType.Integer);

	getNodeData(command, 1);
	getNodeData(command, 2);
	getNodeData(command, 3);
			
	connection.Close();
}				

public static void getNodeData(FbCommand command, int id) 		{
	command.Parameters["@ID"].Value = id;			
	try
	{
		FbDataReader reader = 
command.ExecuteReader(System.Data.CommandBehavior.SingleRow);

		try 				
		{
			if (!reader.Read())
			{
			throw new Exception("Node not found")");
			}
		}
	    	finally 			
		{
			reader.Close();
	    	}
	}
	catch
	{
		throw;
	}						
}






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] ExecuteReader and "Attempt to reopen an open cursor"

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

Hello:

> Does anyone see what I am doing wrong here?

I'm going to try to see it today, wich version of the NET provider are 
you using ?? RC2 ??


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.