| Author |
ultralite ~.db file
|
|
| handheldmaster 2005-09-01, 11:23 am |
|
using ultralite 9.0.2 (3137) Appforge MobileVB 4. Found that
the engine creates a lock file of sorts .. dbname.~db
What does this file do ? Can we simple delete.
The app goes through a data sync then disconnects from the
database. Connection.close ... now if we attempt to create a
new connection to the same database that has the ~.db file
then it just crashes on the statement Set Connection =
DataMgr. OpenConnection(open_
pars)
Am doing error capture but still do not get any error
notices from this overall event.
Any ideas ? how to connect to the app without exiting the
full application from memory.
| |
| Tom Slee 2005-09-01, 8:23 pm |
| handheldmaster wrote:
> using ultralite 9.0.2 (3137) Appforge MobileVB 4. Found that
> the engine creates a lock file of sorts .. dbname.~db
>
> What does this file do ? Can we simple delete.
>
> The app goes through a data sync then disconnects from the
> database. Connection.close ... now if we attempt to create a
> new connection to the same database that has the ~.db file
> then it just crashes on the statement Set Connection =
> DataMgr. OpenConnection(open_
pars)
>
> Am doing error capture but still do not get any error
> notices from this overall event.
>
> Any ideas ? how to connect to the app without exiting the
> full application from memory.
The dbname.~db file is a temporary file used during processing, and can
be deleted once UltraLite is no longer running.
I don't see why the OpenConnection failes, but if you want to release
everything associated with UltraLite without closing your app, you could
free your DatabaseManager object with a "DatabaseManager = Nothing"
statement (VB) or its C# equivalent.
Tom Slee
iAnywhere
| |
| Tom Slee 2005-09-01, 8:23 pm |
| handheldmaster wrote:
> using ultralite 9.0.2 (3137) Appforge MobileVB 4. Found that
> the engine creates a lock file of sorts .. dbname.~db
>
> What does this file do ? Can we simple delete.
>
> The app goes through a data sync then disconnects from the
> database. Connection.close ... now if we attempt to create a
> new connection to the same database that has the ~.db file
> then it just crashes on the statement Set Connection =
> DataMgr. OpenConnection(open_
pars)
>
> Am doing error capture but still do not get any error
> notices from this overall event.
>
> Any ideas ? how to connect to the app without exiting the
> full application from memory.
The dbname.~db file is a temporary file used during processing, and can
be deleted once UltraLite is no longer running.
I don't see why the OpenConnection failes, but if you want to release
everything associated with UltraLite without closing your app, you could
free your DatabaseManager object with a "DatabaseManager = Nothing"
statement (VB) or its C# equivalent.
Tom Slee
iAnywhere
| |
| handheldmaster 2005-09-06, 8:23 pm |
|
> The dbname.~db file is a temporary file used during
> processing, and can be deleted once UltraLite is no
> longer running.
>
Ok. Am using the RESERVE_SIZE parameter to extend the file
to 10 MB .. what happens is that if one creates the database
with CreateDatabase it also creates the ~.db file of 10 MB
.. so myself will have to make sure that there is always
enough free space >20 MB in the handheld ? .. Example: If db
size is 3.5 Mb need to have minimum 10 Mb space available in
memory for operation. Is this correct ?
> I don't see why the OpenConnection failes, but if you want
> to release everything associated with UltraLite without
> closing your app, you could free your DatabaseManager
> object with a "DatabaseManager = Nothing" statement (VB)
> or its C# equivalent.
>
My bad .. put in more debug statements and problem was
earlier connection was not closed ... Had to code manually
around it as there was no property to the Connection object
to check if Connection is Open .. something like
Connection.isOpen ? ... Thanks for your inputs.
| |
| Tim McClements 2005-09-14, 8:24 pm |
|
<handheldmaster> wrote in message
news:431de43d.53c9.1681692777@sybase.com...
>
> Ok. Am using the RESERVE_SIZE parameter to extend the file
> to 10 MB .. what happens is that if one creates the database
> with CreateDatabase it also creates the ~.db file of 10 MB
> . so myself will have to make sure that there is always
> enough free space >20 MB in the handheld ? .. Example: If db
> size is 3.5 Mb need to have minimum 10 Mb space available in
> memory for operation. Is this correct ?
Correct.
We do intend to change this behaviour though -- only the main database file
should grow based on the reserve_size parameter.
- Tim
| |
| Tim McClements 2005-09-15, 8:23 pm |
| This problem has been fixed in 9.0.2.3190 and later. (reserve_size only
applies to the main database file, not the temp file.)
- Tim
"Tim McClements" < mcclemenXnospam@syba
se.com> wrote in message
news:4328cc27$1@foru
ms-1-dub...
>
> <handheldmaster> wrote in message
> news:431de43d.53c9.1681692777@sybase.com...
>
> Correct.
>
> We do intend to change this behaviour though -- only the main database
> file should grow based on the reserve_size parameter.
>
> - Tim
>
|
|
|
|