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

Re: [Firebird-net-provider] Use GetBytes() to get BLOB data

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

Hello:

> Is this a defect in the .NET provider

Yes, i will fix it tomorrow, thanks very much.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Use GetBytes() to get BLOB data

[Derek M. A. Lee-W. <de...@fa...>]

I'm trying to read a BLOB by doing the following:

            string sql = 
                "SELECT id, added_on, taken_on, caption, description,
                width, height, data " +
                "FROM image " +
                "WHERE id = " + id ;

                [snip]

                int imageLen = (int) r.GetBytes(7, 0, null, 0, 0) ;
                Log.Debug("imageLen=" + imageLen + " bytes") ;

                data = new byte [imageLen] ;
                r.GetBytes(7, 0, this.data, 0, imageLen) ;


The first call is supposed to give me the size of the BLOB (when the
buffer is null), based on the docs, and this is what I also do when
working with DB2 and SAPDB.

FireBird is ALWAYS returning 8 as the image length.

Is this a defect in the .NET provider, or am I supposed to do this
differently with FireBird?

I saw an example in the archives where someone simply allocated a HUGE
buffer, and I suppose I _could_ do that, but it seems to be a bit of a
waste.

Derek
-- 
Derek M. A. Lee-Wo
Email: (Home) de...@le...  (Work) dl...@vo...
Fax:     (US) 413-826-0641      (UK) 08701 338414

    "Those who will not risk cannot win" - John Paul Jones

Re: [Firebird-net-provider] CREATE TABLE with Embedded server

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

Hello:

> When I then try to create a table using the Embedded server, I get an 
> FBException "unsuccessful metadata updateTABLEA".

I have done a little test and i got the exception only if the table 
already exists.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] General sql question

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

Hello:

> ArrayList _list = new ArrayList();
> 
> while (_reader.Read()) 
> {
>     _list.Add(_reader.GetInt32(1));
> }
> 
> _list.ToArray(typeof(float[]));
> 
> that will add 1000 values to an arraylist and after cast it to an float
> array. There is nothing more eficient?

In first i think that no, but why are you reading data as an integer and 
casting them to float at the end ?? ( i mean why you are not reading it 
directly as float ?? )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] General sql question

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

Hi experts=2C

it=27s a general database question and I am sure you have an answer=3A

I have an array field (although it could be any kind of field) and I
want to retrieve
1000 rows=2E There is something more efficient than this code=3A

ArrayList =5Flist =3D new ArrayList()=3B

while (=5Freader=2ERead()) =

=7B
    =5Flist=2EAdd(=5Freader=2EGetInt32(1))=3B
=7D

=5Flist=2EToArray(typeof(float=5B=5D))=3B

that will add 1000 values to an arraylist and after cast it to an float
array=2E There is nothing more eficient=3F

Thanks=2E
Jesus

-----------------------------------------------------------------------
Edici=F3n Limitada del nuevo disco de David Bisbal=3A Buler=EDa=2E Cons=ED=
guelo
con un 18=25 de decuento=2C solo por 15=2C50 =80
http=3A//www=2Eeresmas=2Ecom/banners/promo=2Ehtml=3Fzanox

Re: [Firebird-net-provider] CREATE TABLE with Embedded server

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

Hello:

> Any ideas?

Can you send a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] CREATE TABLE with Embedded server

[Tobias G. <tob...@ca...>]

Hi!

When I then try to create a table using the Embedded server, I get an 
FBException "unsuccessful metadata updateTABLEA".

The same code, just with ServerType=1 replaced by ServerType=0 works.

Any ideas?

There is nothing unusual in the SQL code:

       'CREATE TABLE ' + Name + '(' +
       'field1 integer not null,' +
       'field2 varchar(10),' +
       'field3 varchar(100),' +
       'PRIMARY KEY (field1)'+
     ')';


Tobias

PS: working with the current CVS version of 1.6

Re: [Firebird-net-provider] Firebird in Delphi .NET

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

Hello:

> I will ask about this in a Borland newsgroup, maybe this is a problem 
> with other provieders too.

Thanks :) , let me know the answers if you can :)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird in Delphi .NET

[Tobias G. <tob...@ca...>]

Carlos Guzmán Álvarez wrote:

> ) , maybe these designers doesn't work with providers outside Microsoft 
> and Borland :P

I will ask about this in a Borland newsgroup, maybe this is a problem 
with other provieders too.

Re: [Firebird-net-provider] Firebird in Delphi .NET

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

Hello:

> The only problem is, that you can't create a Dataset using the table 
> mappings property of FbDataAdapter. For some reason 
> Borland.Studio.TypeMappings.DataTableMappingCollectionDialog raises an 
> exception complaining about a Null reference.
> Maybe someone has an idea if this is a problem with the 
> firebird-net-provider or with Borland?

Another user some time ago reported a similiar problem in Visual Studio 
2003 ( it sows an invalid datatype conversion message if i remember well 
) , maybe these designers doesn't work with providers outside Microsoft 
and Borland :P





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET for Delphi 8

[Tobias G. <tob...@ca...>]

Hi,

Rodrigo Abreu Oliveira wrote:

> I'm using delphi 8 for .NET, but I do not obtain to
> find a form to connection.

Just select components/installed .NET components, enter "Firebird" as 
Category, press "Select Assembly" and add FirebirdSql.Data.Firebird.dll.
Now you can drop the Firebird components on a WinForm (!) using the form 
designer.

The only problem is, that you can't create a Dataset using the table 
mappings property of FbDataAdapter. So you have to fill your Dataset 
"manually".

Tobias

Re: [Firebird-net-provider] Firebird in Delphi .NET

[Tobias G. <tob...@ca...>]

Hi,

Jáder wrote:

> I need register the components FB of yours assembly
> 
> FirebirdSql.Data.Firebird.UnitTest.dll. How I do this?

Just select components/installed .NET components, enter "Firebird" as 
Category, press "Select Assembly" and add FirebirdSql.Data.Firebird.dll.
Now you can drop teh Firebird components on a WinForm using the form 
designer.

The only problem is, that you can't create a Dataset using the table 
mappings property of FbDataAdapter. For some reason 
Borland.Studio.TypeMappings.DataTableMappingCollectionDialog raises an 
exception complaining about a Null reference.
Maybe someone has an idea if this is a problem with the 
firebird-net-provider or with Borland?

Regards,

Tobias

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

> Thanks for answer. I understand what happened :)
> But a still have problem :(

Huummmm .... the problem is:

1. DbDataAdapter.Update calls ExecuteReader.

2. In ExecuteReader the provider transforms the command text as SELECT * 
FROM TEST_DELETE

3. DbDataAdapter.Update closes the data reader without calls to 
FbDataReader.Read and Firebird doesn't perform the row deletes.


Now the tip is how to solve this, we can add, to the FbDataReader.Close 
method, a pice of code like this:

if (this.position == STARTPOS && this.command.CommandType == 
CommandType.StoredProcedure)
{
	this.Read();
}



And it will work.


Opinions ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

> Thanks for answer. I understand what happened :)
> But a still have problem :(

Ok i will try to review it later.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

[olegmad <ol...@ya...>]

> Ask microsoft ;), the only reasin i see for this is that they use
> FbDatareader.NextResult to process batch commands ;)

Thanks for answer. I understand what happened :)
But a still have problem :(

I changes my TEST_DELETE stored procedure (return integer 345):
------------------------
SET TERM ^ ;

CREATE PROCEDURE TEST_DELETE (
    ID BIGINT)
RETURNS (
    "OUTPUT" INTEGER)
AS
BEGIN
    delete from test where :ID = ID;
    OUTPUT = 345;
    suspend;
END^

SET TERM ; ^
------------------------

Exception gone, all ok, but changes not commited :(

/~~~~~/
// Delete first row.

DataRow row = table.Rows[0];

row.Delete();

FbCommand deleteCommand = new FbCommand("\"TEST_DELETE\"", connection,
transaction);

deleteCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(deleteCommand);

deleteCommand.Parameters[0].SourceColumn = "ID";

adapter.DeleteCommand = deleteCommand;

// row.RowState = Deleted     !!!!!!!!!!!!!!!!!!!!!!!!!!!

adapter.Update(table);

// row.RowState = Detached !!!!!!!!!!!!!!!!!!!!!!!!!!

transaction.Commit();

/~~~~~/
When i see table in my database - i see this row, it not deleted.

Why?

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

>> In my example i use deleteCommand for call stored procedure which delete
>> data. How provider may call select * from "TEST_DELETE"???
> 
> Ask microsoft ;), the only reasin i see for this is that they use 
> FbDatareader.NextResult to process batch commands ;)

To clarify this, the provider transforms the TEST_DELETE to select * 
from TEST_DELETE because DbDataAdapter.Update is making a call to 
ExecuteReader ;)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

> In my example i use deleteCommand for call stored procedure which delete
> data. How provider may call select * from "TEST_DELETE"???

Ask microsoft ;), the only reasin i see for this is that they use 
FbDatareader.NextResult to process batch commands ;)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

[olegmad <ol...@ya...>]

> > adapter.Update(table);         // EXCEPTION HERE !!!!!!!!!!!!!!!!
>
> This will call FbCommand.ExecuteReader method, the provider will
> transform the command text into:
>
> select * from "TEST_DELETE"
>
> As TEST_DELETE has no return values firebird will throw an exception.
>
> You can try using EXECUTE PROCEDURE sintax, or returning at least one
> value ( for example the number of rows affected ;) )

In my example i use deleteCommand for call stored procedure which delete
data. How provider may call select * from "TEST_DELETE"???

------------------
FbCommand deleteCommand = new FbCommand("\"TEST_DELETE\"", connection,
transaction);
deleteCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(deleteCommand);

deleteCommand.Parameters[0].SourceColumn = "ID";

adapter.DeleteCommand = deleteCommand; /// !!!!!!!!!! it's NOT select stored
procedure !!!!!!!!!!

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

I am waiting your feedback. :)

Re: [Firebird-net-provider] FbParameter type definition error

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

Hello:

> Hi Carlos! Iglad see u again! :)

:)

> Please fix it.

Fixed in both 1.5 and 1.6 sources, thanks very much.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbDataAdater.Update()

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

Hello:

> adapter.Update(table);         // EXCEPTION HERE !!!!!!!!!!!!!!!!

This will call FbCommand.ExecuteReader method, the provider will 
transform the command text into:

	select * from "TEST_DELETE"

As TEST_DELETE has no return values firebird will throw an exception.

You can try using EXECUTE PROCEDURE sintax, or returning at least one 
value ( for example the number of rows affected ;) )





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbDataAdater.Update()

[olegmad <ol...@ya...>]

Hi!

When i try update data in database (i use data adapter for this), i catch
exception :(
What i do wrong???

Here my example:
using (FbConnection connection = new FbConnection(ConnectionString))

{

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand selectCommand = new FbCommand("\"TEST_SELECT\"", connection,
transaction);

selectCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(selectCommand);

// Get data table.

FbDataAdapter adapter = new FbDataAdapter(selectCommand);

DataTable table = new DataTable();

adapter.Fill(table);

// Delete first row.

table.Rows[0].Delete();

FbCommand deleteCommand = new FbCommand("\"TEST_DELETE\"", connection,
transaction);

deleteCommand.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(deleteCommand);

deleteCommand.Parameters[0].SourceColumn = "ID";

adapter.DeleteCommand = deleteCommand;

adapter.Update(table);         // EXCEPTION HERE !!!!!!!!!!!!!!!!

transaction.Commit();

}

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

Exception text:
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
occurred in system.data.dll

Additional information: Dynamic SQL Error
SQL error code = -84
procedure TEST_DELETE does not return any values
At line 1, column 10.
-----------------

I create table and two stored procedure like this:

SET TERM ^ ;

/***************************************************************************
***/
/***                           Stored Procedures
***/
/***************************************************************************
***/

CREATE PROCEDURE TEST_DELETE (
    ID BIGINT)
AS
BEGIN
  EXIT;
END^

CREATE PROCEDURE TEST_SELECT
RETURNS (
    ID BIGINT,
    NAME VARCHAR(64))
AS
BEGIN
  EXIT;
END^

SET TERM ; ^

/***************************************************************************
***/
/***                                 Tables
***/
/***************************************************************************
***/

CREATE TABLE TEST (
    ID    BIGINT NOT NULL,
    NAME  VARCHAR(64) NOT NULL
);

/***************************************************************************
***/
/***                              Primary Keys
***/
/***************************************************************************
***/

ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (ID);

/***************************************************************************
***/
/***                           Stored Procedures
***/
/***************************************************************************
***/

SET TERM ^ ;

ALTER PROCEDURE TEST_DELETE (
    ID BIGINT)
AS
begin
    delete from test where :ID = ID;
end
^

ALTER PROCEDURE TEST_SELECT
RETURNS (
    ID BIGINT,
    NAME VARCHAR(64))
AS
begin
    for select ID, NAME from test into :ID, :NAME
    do suspend;
end
^

SET TERM ; ^

[Firebird-net-provider] FbParameter type definition error

[olegmad <ol...@ya...>]

Hi Carlos! Iglad see u again! :)

I had problem when i create FbParameter. Look here:

1) When i create parameter, his FbDbType = VarChar

FbParameter parameter1 = new FbParameter("param", DateTime.Now);

2) But when i create parameter in this example, his FbDbType = TimeStamp

FbParameter parameter2 = new FbParameter();

parameter2.ParameterName = "param";

parameter2.Value = DateTime.Now;



Please fix it.

Thanks!

Bye.

RE: [Firebird-net-provider] sweeping

[JS.staff <jsp...@ec...>]

SSBkaXNhZ3JlZSEgRG9lc24ndCBJQlBob2VuaXggLyBJQkMgLyBCb3JsYW5kJ3Mgb3duIGRvY3Mg
KGdvaW5nIGJhY2sgYmVmb3JlIHRoZSBzcGxpdCkgc2F5ICJhdXRvbWF0aWMgc3dlZXBpbmcgaXMg
bm90IG9wdGltYWwgYmVoYXZpb3VyIj8/PyBUaGV5IHJlY29tbWVuZCBzd2VlcGluZyBtYW51YWxs
eSAoaWUgeW91ciBvd24gY29kZSkgd2hlbiB5b3VyIHN5c3RlbSBpcyBpZGxlLCBub3Qgd2hlbmV2
ZXIgeW91IHBhc3MgeDAsMDAwIHRyYW5zYWN0aW9ucy4NCiANCklmIHlvdSd2ZSBmb3IgbG9uZ2lz
aCBkdXJhdGlvbiB0cmFuc2FjdGlvbnMgdGhhdCBlbmQgaW4gcm9sbGJhY2sgLSB5b3VyIGdvbm5h
IG5lZWQgdG8gc3dlZXAgbm93IGFuZCBhZ2FpbiBpbiBjYXNlIHRoZSBPSVQgZ2V0cyBzdHVjay4g
SSBhZ3JlZSBhbGwgdHJhbnNhY3Rpb25zIHNob3VsZCBiZSBhcyBzaG9ydCBhcyBwb3NzaWJsZSwg
YW5kIGVuZCBpbiBDb21taXQoKSB3aGVuZXZlciBwb3NzaWJsZSAtIGJ1dCB0aGlzIGlzbid0IGFs
d2F5cyBwcmFjdGljYWwuIEVzcGVjaWFsbHkgd2hlbiB1c2luZyBkYiB0b29scyB0aGF0IHdvcmsg
aW4gYSAnY29ubmVjdGVkIG1vZGVsJyAodmVyeSB1bi0ubmV0LCBidXQgeWV0IElCWCBpcyBvdXQg
dGhlcmUhKS4NCiANCkdlbmVyYWxseSwgSSBjaG9vc2UgdG8gc3dlZXAgdGhlIGRiIGVhY2ggbmln
aHQgYXMgcGFydCBvZiB0aGUgaG91c2Uta2VlcGluZy4gQmVjYXVzZSB0aGUgdmFzdCBtYWpvcml0
eSBvZiBteSB0cmFuc2FjdGlvbnMgYXJlIHYgc2hvcnQgYW5kIGVuZCBpbiBjb21taXQsIHRoaXMg
aXMgb2Z0ZW4gdW5uZWNlc3NhcnkuIEp1c3QgbGlrZSB0aGUgdmFzdCBtYWpvcml0eSBvZiBiYWNr
dXBzIGFyZSB1bm5lY2Nlc2FyeS4uLi4gZ3Jpbg0KIA0KQmVsdC1hbmQtYnJhY2VzLCBhbmQgYWxs
IHRoYXQuDQogDQpKb2huDQoNCgktLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBB
bGFuIE1jRG9uYWxkIFttYWlsdG86YWxhbkBtZXRhLmNvbS5hdV0gDQoJU2VudDogRnJpIDA1LzAz
LzIwMDQgMjI6MzkgDQoJVG86IGZpcmViaXJkLW5ldC1wcm92aWRlckBsaXN0cy5zb3VyY2Vmb3Jn
ZS5uZXQgDQoJQ2M6IA0KCVN1YmplY3Q6IFJFOiBbRmlyZWJpcmQtbmV0LXByb3ZpZGVyXSBzd2Vl
cGluZw0KCQ0KCQ0KDQoJPiBJJ3ZlIGp1c3QgYmVlbiB0cnlpbmcgdG8gd3JpdGUgYSBzY2hlZHVs
ZWQgcHJvZ3JhbSB0byBzd2VlcCB0aGUNCgk+IGRhdGFiYXNlIC0gYW0gSSByaWdodCBpbiB0aGlu
a2luZyB0aGVyZSBtdXN0IGJlIE5PIGFjdGl2ZQ0KCT4gY29ubmVjdGlvbnMgaW4gdGhlIHBvb2wg
Zm9yIHN3ZWVwaW5nIHRvIGJlIHN1Y2Nlc3NmdWw/Pw0KCT4gDQoJPiBJc24ndCB0aGlzIGEgYml0
IG9mIGEgZHJhd2JhY2s/Pz8NCgk+IA0KCT4gVGhhbmtzLA0KCT4gDQoJPiBKb2huDQoJDQoJeW91
IGRvbid0IG5lZWQgdG8gbWFudWFsbHkgcnVuIHN3ZWVwIC0geW91IHNldCBhbiBpbnRlcnZhbCBh
dCB0aGUgc2VydmVyLiBidXQgaWYgeW91IHJlYWxseSBuZWVkIHN3ZWVwIHRoZW4gdGhlcmUgaXMg
c29tZXRoaW5nIHdyb25nIHdpdGggeW91ciB0cmFuc2FjdGlvbiBjb250cm9sLg0KCUFsYW4NCgkN
CgkNCgkNCgkNCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tDQoJVGhpcyBTRi5OZXQgZW1haWwgaXMgc3BvbnNvcmVkIGJ5OiBJQk0gTGludXgg
VHV0b3JpYWxzDQoJRnJlZSBMaW51eCB0dXRvcmlhbCBwcmVzZW50ZWQgYnkgRGFuaWVsIFJvYmJp
bnMsIFByZXNpZGVudCBhbmQgQ0VPIG9mDQoJR2VuVG9vIHRlY2hub2xvZ2llcy4gTGVhcm4gZXZl
cnl0aGluZyBmcm9tIGZ1bmRhbWVudGFscyB0byBzeXN0ZW0NCglhZG1pbmlzdHJhdGlvbi5odHRw
Oi8vYWRzLm9zZG4uY29tLz9hZF9pZBQ3MCZhbGxvY19pZDYzOCZvcD1pY2sNCglfX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KCUZpcmViaXJkLW5ldC1wcm92
aWRlciBtYWlsaW5nIGxpc3QNCglGaXJlYmlyZC1uZXQtcHJvdmlkZXJAbGlzdHMuc291cmNlZm9y
Z2UubmV0DQoJaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vZmly
ZWJpcmQtbmV0LXByb3ZpZGVyDQoJDQoNCg==

Re: [Firebird-net-provider] sweeping

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

Hello:

>I've just been trying to write a scheduled program to sweep the database - 
 >am I right in thinking there must be NO active connections in the pool 
for
 > sweeping to be successful??


Seems to be wqorking for me, here is my test case:

FbConnection[] conns = new FbConnection[10];

for (int i = 0; i < conns.Length; i++)
{
	conns[i] = new FbConnection(connectionString);
	conns[i].Open();
}

FbValidation validation = new FbValidation();

validation.Options = FbValidationFlags.SweepDatabase;
validation.Parameters.Database	= @"c:\testdb.gdb";
validation.Parameters.UserName	= "SYSDBA";
validation.Parameters.UserPassword	= "masterkey";
validation.Parameters.DataSource	= "localhost";

validation.Start();

validation.Close();

for (int i = 0; i < conns.Length; i++)
{
	conns[i].Close();
}


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] sweeping

[Alan M. <al...@me...>]

> I've just been trying to write a scheduled program to sweep the=20
> database - am I right in thinking there must be NO active=20
> connections in the pool for sweeping to be successful??
> =20
> Isn't this a bit of a drawback???
> =20
> Thanks,
> =20
> John

you don't need to manually run sweep - you set an interval at the =
server. but if you really need sweep then there is something wrong with =
your transaction control.
Alan