I have wrapped each insert in a transaction and I'm now getting an
exception thrown (I'm happy to report that the server stays running though).
Exception details-
FirebirdSql.Data.Firebird.FbException: Error reading data from the
connection.
at FirebirdSql.Data.Firebird.FbTransaction.Commit()
at FirebirdDBTests.FireBirdAdo.AddUser(Int64 id, String name,
DateTime dateCr
eated, String status) in C:\Documents and Settings\Matt\My
Documents\Visual Stud
io 2005\Projects\PrismDBTests\FirebirdDBTests\FireBirdAdo.cs:line 43
at DBTestRunner.TestRunner.RunTests(IDataBaseTests testDB) in
C:\Documents an
d Settings\Matt\My Documents\Visual Studio
2005\Projects\PrismDBTests\FirebirdDB
Runner\Program.cs:line 28
at DBTestRunner.TestRunner.FireBirdAdo() in C:\Documents and
Settings\Matt\My
Documents\Visual Studio
2005\Projects\PrismDBTests\FirebirdDBRunner\Program.cs:
line 39
at DBTestRunner.Program.Main(String[] args) in C:\Documents and
Settings\Matt
\My Documents\Visual Studio
2005\Projects\PrismDBTests\FirebirdDBRunner\Program.
P.S.
Please note that the test program has changed slightly.
Sorry for the long absence, I have been shifted around projects a couple
of times...
[EMAIL PROTECTED] wrote:
Hello:
Looks like you are runnint the inserts using always implicit
trasnactions what will cause 25000 transactiosn to be created and
committed, try using explicit transactions.
----Mensaje original----
De: [EMAIL PROTECTED]
Recibido: 25/10/2005 10:29
Para:
<Firebird-net-provider@lists.sourceforge.net>
Asunto: [Firebird-net-
provider] High load causing server quit?
Hi all.
I'm using 1.7a (is
this the most recent stable build?
the web page says 1.6.3 is but
doesn't provide links
to download it...) for some simple tests.
I have
a loop inserting items into a test DB by
building a string, creating a
NpgsqlCommand and
calling ExecuteNonQuery. The same connection is used
for all the inserts.
However, if I insert more than 25,000 rows an
exception is thrown and the Firebird server process
exits!
Am I doing
something wrong?
Exception details:
Started up at 25/10/2005 08:48:
48 ,
Initialising connection...
using ADO
on Firebird 00:
00:02.0625000
Deleting... , 00:00:02.4062500
Populating 100
categories... , 00:00:01.2656250
Populating 25000 products... ,
Unhandled Exception:
FirebirdSql.Data.Firebird.FbException: Error
reading
data from the connection.
at FirebirdSql.Data.Firebird.
FbTransaction.Commit()
at
FirebirdSql.Data.Firebird.FbCommand.
CommitImplicitTransaction()
at
FirebirdSql.Data.Firebird.FbCommand.
ExecuteNonQuery()
at OPathExperiments.AdoTests.PopulateProducts
(Int32
number, Int32 maxPrice)
at OPathExperiments.Program.RunTests
(IDBTests
tests, DBType dBType, String connectionString)
at
OPathExperiments.Program.Main(String[] args)
Cheers.
___________________________________________________________
Yahoo!
Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
-------------------------------------------------------
This SF.Net
email is sponsored by the JBoss Inc.
Get Certified Today * Register for
a JBoss Training Course
Free Certification Exam for All Training
Attendees Through End of 2005
Visit http://www.jboss.
com/services/certification for more information
_______________________________________________
Firebird-net-provider
mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.
sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
