From: Pavol S. <pa...@st...> - 2003-02-07 10:26:04
|
hallo i have big problem Unhandled Exception: FirebirdSql.Data.Firebird.FbException: invalid request hand le at FirebirdSql.Data.Firebird.FbCommand.Prepare() at NovyCas.DBSearchWords.InsertWord(String iWord, FbConnection& dbConn, FbTra nsaction& dbTran) in C:\Projekty\NetStarek\NovyCas\DBSearchWords.cs:line 50 at NovyCas.DBSearchWords.WordsToDb(String[] iWords) in C:\Projekty\NetStarek\ NovyCas\DBSearchWords.cs:line 75 at Tests.Main(String[] args) in C:\Projekty\NetStarek\Tests\Main.cs:line 72 Unhandled Exception: FirebirdSql.Data.Firebird.FbException: Error reading data f rom the connection. at FirebirdSql.Data.Firebird.FbConnection.Close() at NovyCas.DBSearchWords.WordsToDb(String[] iWords) in C:\Projekty\NetStarek\ NovyCas\DBSearchWords.cs:line 83 at Tests.Main(String[] args) in C:\Projekty\NetStarek\Tests\Main.cs:line 72 Press any key to continue . . . this happend under havy load :( i have aprox. 40000 articles in database.. and im creating list of words for seraching. It means get article from database, split it in words array and foreach word look if it is in database if not insert it... i use one connection and one transaction for all word looking and inserting and separate connection and transaction for geting article... If you will want i will send you my code.. p. |