Subject | Transaction problems |
---|---|
Author | rodbracher |
Post date | 2002-10-15T07:02:21Z |
Hi
I have a transaction that essentially imports records - check to see
if there is an existing key ( edit ) or none ( inserts ). I then
update all those records with an update statement ( execSQL ). This
causes a 'Connection Lost To Database' ( in the interbase.log I get
IBServer terminated abnormally )
Is it bad to use edit/inserts and post along with execSQL statements
in the same transaction ?
I also have not changed ( or ever used the TimeOutProps ). Could this
possibly cause the connection loss ( The import size varys but
usually 5000 records / relation * 9 relations are imported ) and I
see the Default TimeOutProps.Attempt is some number lower than that.
Thanks
Rod
I have a transaction that essentially imports records - check to see
if there is an existing key ( edit ) or none ( inserts ). I then
update all those records with an update statement ( execSQL ). This
causes a 'Connection Lost To Database' ( in the interbase.log I get
IBServer terminated abnormally )
Is it bad to use edit/inserts and post along with execSQL statements
in the same transaction ?
I also have not changed ( or ever used the TimeOutProps ). Could this
possibly cause the connection loss ( The import size varys but
usually 5000 records / relation * 9 relations are imported ) and I
see the Default TimeOutProps.Attempt is some number lower than that.
Thanks
Rod