System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
2015-02-12
23:54 Closed ticket [647d282d11]: Configurable number of retries and sleep time of SQLite3.Prepare plus 4 other changes artifact: 51297d1403 user: mistachkin
23:53
Add PrepareRetries connection string property to allow the maximum number of retries when preparing a query to be overridden. Fix for [647d282d11]. check-in: 39f91f897d user: mistachkin tags: trunk
23:51 Pending ticket [647d282d11]: Configurable number of retries and sleep time of SQLite3.Prepare plus 4 other changes artifact: aa5b811267 user: mistachkin
21:34 Verified ticket [647d282d11]. artifact: 9e1971354c user: mistachkin
15:23 New ticket [647d282d11]. artifact: fd88760e62 user: anonymous

Ticket Hash: 647d282d111f6c3638138809df5ea8ae8dd900ae
Title: Configurable number of retries and sleep time of SQLite3.Prepare
Status: Closed Type: Feature_Request
Severity: Important Priority: Blocker
Subsystem: Connection Resolution: Fixed
Last Modified: 2015-02-12 23:54:33
Version Found In: 1.0.94.0
User Comments:
anonymous added on 2015-02-12 15:23:07:
SQLite3.Prepare will retry up to three times when an error occurs. For busy and locked errors it also sleeps a random number of milliseconds up to 150.

Max number of retries and sleep time is hardcoded. It would be very nice to be able to set these parameters via connection string and/or connection properties.

I think max number of retries is much more important than sleep time, so I would be happy with be able to set only max number of retries.

Thank you very much

mistachkin added on 2015-02-12 23:54:33:
Fixed on trunk via check-in [39f91f897d].  This will be in the 1.0.95.0 release.