SQL connection problem
-
i need to insert huge database in sql table the problem 1) i need to know any method/process by which u may guess the connection has break 2) if connection is brek i need to roll back all the inserts any idea ? :wtf: P.S. PATWAL
First of all, you didn't mention how you contact your database and what db you use (or do you mean MS SQL-Server by "sql table"?) 1) Can't say any particular without knowing how you contact database. But you could check the return value of your data-access-method. There should be an error code for lost connection. 2) If you don't use autocommit, it should be the database's job not to store any data that's not commited. -- karl
-
First of all, you didn't mention how you contact your database and what db you use (or do you mean MS SQL-Server by "sql table"?) 1) Can't say any particular without knowing how you contact database. But you could check the return value of your data-access-method. There should be an error code for lost connection. 2) If you don't use autocommit, it should be the database's job not to store any data that's not commited. -- karl