firebird-net-provider

[Firebird-net-provider] DataAdapter.Fill in NUNIT

[Denis D. <fir...@De...>]

Hello,
I'm a new user for Firebird.NET.Provider wich seems to be a very good tool
for accessing Firebird database.

My configuration is : (full detail at the message bottom)
    Microsoft Visual C# ( Windows XP )
    Firebird 1.5.0.3744
    Firebird.NET Provider 1.1-alpha2

I've got a problem running a test with NUNIT
(see attachement FirebirdTest2.cs)

This test  ( Firebird.Test2.FirebirdTest2.FirebirdDataSet )
use the EMPLOYEE.FDB sample and try to fill a DataSet
("SELECT * FROM EMPLOYEE")

When using this test in a Main( ) procedure, with :

    FirebirdTest2 Test2 = new FirebirdTest2();
    Test2.FirebirdDataSet();

it does work fine.
*************

BUT, if running this test with NUNIT,
I get the following output :

    Test 7:
    Get a DataSet from EMPLOYEE.FDB.
    Connection opened
    Transaction started
    Command ready
    DataAdapter created
    DataSet created
    InvalidCastException: Le cast spécifié n'est pas valide.
    ****************

What can goes wrong ??
Thank you if you have an idea.

Full test project can be found at
http://DenisDumoulin.net/FirebirdNETProvider/TEST.zip
( NUNIT must be run in this directory :
  Firebird.Test\bin\Debug
  using Firebird.Test.dll file )
( solution entry is FirebirdTest\FirebirdTest.sln
  for MS C# studio
  StartUp project is  Firebird.TestConsole )

________________________________

Configuration details :
// Microsoft Development Environment 2003, version 7.1.3088
// Microsoft .NET Framwork 1.1, version 1.1.4322
// Firebird version 1.5.0.3744 RC4

(http://prdownloads.sourceforge.net/firebird/Firebird-1.5.0.3744_RC4_win32.z
ip?download)
// Firebird.NET Provider 1.1-Alpha2 ( 2003-06-23 )

(http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.1-Alpha2.e
xe?download)
// NUnit version 2.0.6 (http://www.nunit.org/files/nunit-v20/Nunit.msi)

_________________________________

Best regards,
Denis Dumoulin

Re: [Firebird-net-provider] DataAdapter.Fill in NUNIT

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

Hello:

> Well, dont bother for now, I will go on with other tests and see if I can
> get them working....

Can you get the Stack Trace of the Exception and send it ??



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] DataAdapter.Fill in NUNIT

[Denis D. <fir...@De...>]

>
> > I've got a problem running a test with NUNIT
> > ....
>
> Can you get the Stack Trace of the Exception and send it ??

Ok, this what I get with  E.StackTrace

InvalidCastException: Le cast spécifié n'est pas valide.

   at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
        Int32 maxRecords, String srcTable, IDbCommand command,
        CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
        startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
        CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Firebird.Test2.FirebirdTest2.FirebirdDataSet()
        in c:\documents and settings\denis\mes documents\sources.net\
            epsitec.cresus\firebird.test\firebirdtest2.cs:line 52

____________________________________________________

Is there a way to get the version of FirebirdNETProvider at run time ?
And also for Firebird version ?


Thanks,
Denis Dumoulin

Re: [Firebird-net-provider] DataAdapter.Fill in NUNIT

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

Hello:


> Ok, this what I get with  E.StackTrace
> 
> InvalidCastException: Le cast spécifié n'est pas valide.
> 
>    at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
>         Int32 maxRecords, String srcTable, IDbCommand command,
>         CommandBehavior behavior)
>    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
>         startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>         CommandBehavior behavior)
>    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
>    at Firebird.Test2.FirebirdTest2.FirebirdDataSet()
>         in c:\documents and settings\denis\mes documents\sources.net\
>             epsitec.cresus\firebird.test\firebirdtest2.cs:line 52

This didn't help, try to debug the nunit test execution trying to see 
that the values the FbDataReader is obtaining are correct.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain