Re: [Firebird-net-provider] Execution of query hangs up/freezes

[Lucjan Ł. <lu...@o2...>]

I think it's not the same problem as Jiri has suggested.

The query is:

update ecc$rejestr set wartosc0=@wartosc, typklucza=@typklucza where
klucz=@klucz and induzytkownik=@induzytkownik

The params are:

@klucz = PersonLocator_mainGridControl
@induzytkownik = 1
@typklucza = 0
@wartosc =
db://(2813f4c2-87c7-4c3d-8175-d0e03c88d516)//PersonLocator_mainGridControl.x
ml

A DDL of ECC$REJESTR:

CREATE TABLE ECC$REJESTR
(
  KLUCZ STRING50_FIELD DEFAULT '' NOT NULL,
  INDUZYTKOWNIK BIGINT_FIELD NOT NULL,
  TYPKLUCZA SHORT_FIELD DEFAULT 0,
  WARTOSC0 STRING250_FIELD,
  WARTOSC1 INTEGER_FIELD,
  WARTOSC2 FLOAT_FIELD,
  WARTOSC3 MONEY_FIELD,
  WARTOSC4 TIMESTAMP_FIELD,
  CONSTRAINT PK_ECC$REJESTR PRIMARY KEY (KLUCZ,INDUZYTKOWNIK)
);

ALTER TABLE ECC$REJESTR ADD
  FOREIGN KEY (INDUZYTKOWNIK) REFERENCES ECC$UZYTKOWNICY (ID);

Ivan wrote:
> How stable is your connection and how big is the query?

Connection is local, on not default port (3075).


Lucek

-----Original Message-----
From: Jiri Cincura [mailto:di...@ci...] 
Sent: Thursday, April 22, 2010 2:07 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Execution of query hangs up/freezes

Well you're not showing the query, thus nobody can test it. Can you
test it's (not) same as http://tracker.firebirdsql.org/browse/DNET-304
?

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com