Thread: [Firebird-net-provider] RE: BeginTransaction Problem ??

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Mahesh.

If you use RC2 or RC3 the problems are gone.

I have done very many tests with RC2, and I cannot re-create the exception
with this release.

/Thomas

Thanx for ur prompt replies Carlos & Thomas.
I tried with 1.5 RC2 (that is what I could download) and haven't received exception yet. But I've to test it more as I'd told earlier that it is a very random error. I feel it won't... Fingers Crossed. :-)

One thing I'm curiuos about that why in the first place I got this exception? Can u guys give me any idea?

The second thing which I wanted to point out was that I'd to change a li'le bit of my code to work with this newer version. While creating a new parameter, my earlier code was (1.5 Beta 2)
FbParameter fbParam = new FbParameter("@no_of_days",4);

But this somehow was givin' me some null exception with 1.5 RC2. I changed the code to this
FbParameter fbParam = new FbParameter("@p_no_of_days",(object)0);
And  now it is workin' fine. Can I expect an explanation?

U've written about thread-safe. As I've metioned in my previous mail, I'm using a static class for connections and any queries. This is static class ans is same replica as the OracleHelper and MSSQL Helper libraries available on the Microsoft site. Hope u've gone thru them. I think they are thread safe. Anything u would like to add to this. I haven't gone any such issue till now.

Thanx once a'ain for ur prompt responses.
Mahesh.

---------------------------------
BT Yahoo! Broadband - Free modem offer, sign up online today and save £80
Hello:

> Thanx for ur prompt replies Carlos & Thomas.
> I tried with 1.5 RC2 (that is what I could download) and haven't received exception yet. But I've to test it more as I'd told earlier that it is a very random error. I feel it won't... Fingers Crossed. :-)
>  
> One thing I'm curiuos about that why in the first place I got this exception? Can u guys give me any idea?

There are some issues with the transaction handling that are fixed in 
RC2 and RC3.

> But this somehow was givin' me some null exception with 1.5 RC2. I changed the code to this
> FbParameter fbParam = new FbParameter("@p_no_of_days",(object)0);
> And  now it is workin' fine. Can I expect an explanation?

Are you getting the exception on parameter creation ( i don't get 
exception ) or in statement execution (in that case can you send a test 
case) ??

>U've written about thread-safe. As I've metioned in my previous mail, I'm using a static class for 
 >connections and any queries. This is static class ans is same replica 
as the OracleHelper and MSSQL Helper
 >libraries available on the Microsoft site. Hope u've gone thru them. I 
think they are thread safe.
 >Anything u would like to add to this. I haven't gone any such issue 
till now.

Huummm maybe i'm wrong but as i know they are not thread safe, correct 
me if i'm wrong.

--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello Carlos,
You had asked about the exception I'm facing while this peace of code is executed in .NET Provider RC2

FbParameter fbParam = new FbParameter("@no_of_days",4);

This is what the exception I've got
 Message : Incorrect values within SQLDA structure
 Source : FirebirdSql.Data.Firebird
 TargetSite : FirebirdSql.Data.Firebird.FbDataReader ExecuteReader(System.Data.CommandBehavior)

By casting it with (object), the FbException doesn't comes.
FbParameter fbParam = new FbParameter("@no_of_days",(object)4);

As for the thread-safe nature of OracleHelper Library by Microsoft, I found that there are no member variables to be shared across various instances and all the mehods just work on local variables. As there is nothing to be shared, I 'assumed' it to be thread safe. (I'm not including the ParameterCollectionCache, as I'm not using it). 
Is there anything else to be taken care of while looking at thread safety? Will be more than happy if u can make it clear.

Thanx.
Mahesh.

---------------------------------
BT Yahoo! Broadband - Free modem offer, sign up online today and save £80
Hello:

>  Message : Incorrect values within SQLDA structure
>  Source : FirebirdSql.Data.Firebird
>  TargetSite : FirebirdSql.Data.Firebird.FbDataReader ExecuteReader(System.Data.CommandBehavior)

Can you send to me a test case ??

--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Thread: [Firebird-net-provider] RE: BeginTransaction Problem ??

A powerful, cross platform, SQL database system

firebird-net-provider