Vladislav Panteleev wrote:
> reader1 = getReader(select .. from mytable left join table1 on .. where ..
> group by)
> while (reader1.Read())
> {
>   //do somth
>   reader2 = getReader(select .. from mytable left join table2 on .. where ..
> group by)
>   while (reader2.Read())
>   {
>     //do somth
>     reader3 = getReader(select .. from mytable left join table3 on .. where
> .. group by)
>     while (reader3.Read())
>     {
>       //do somth
> 
>       //////The exception rises here
>       reader4 = getReader(select .. from mytable left join table4 on ..
> where .. group by)
>       //////
> 
>       while (reader4.Read())
>       {
>         //do somth
>       }
>     }
>   }
> }
> 
> I've been triing to use view in select queries, result hadn't changed, I've
> been run all of this queries in ibexpert and all of them passed.

Looks to me like you're getting a deadlock. This is not really specific 
to the .NET provider, but four nested queries like that seems like 
rather a lot. Can you not implement the four loops separately so that 
you don't need four simultaneous connections to the database? (which 
would especially kill you if you're running against firebird classic 
server!)

Dean.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to