"Andrew A. Raines" <[EMAIL PROTECTED]> writes: > My solution, which seems to work well, is a poor man's blocking > scheme where access to the database loops until successful: > > while ! sqlite $DB_FILE "BEGIN TRANSACTION; $sql; COMMIT;" \ > >/dev/null 2>&1; do > continue > done
You can let the sqlite shell do the blocking for you, with the '.timeout' command. (In sqlite, type ".help" for a brief explanation) Then, if you get back a non-zero status, it'll be from some more legitimate error than blocking (unless you have processes that block for longer than your specified timeout value). Derrell --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
