> -----Original Message----- > From: Christian Schwarz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 18, 2007 7:25 AM > To: sqlite-users@sqlite.org > Subject: AW: [sqlite] Still getting "Insertion failed because database > isfull." errors > > > the database residing on removable media. When the system returns, > the > > "pointer" to the media is not guaranteed to work again. In other > words, > > The file handle remains perfectly valid when the media has not been > removed or changed. Besides, I've observed that sometimes the media is > not accessible at all after an application was trying to use one of the > open file handles while the media is being remounted. Maybe that's just > a sign for a poorly written driver and thus device dependent...
It is in fact, device-dependent. Some hardware manufacturers have more durable remounting infrastructure that enables your file handles to survive a resume from standby, and some don't. I always recommend short-lived connections on a mobile device. Get in and get out quickly, and don't keep anything in memory or active longer than it needs to be. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
