Frank Schönheit - Sun Microsystems Germany wrote:
Hi Fernand,
- When after redoing my coding homework , a connection is still left
"open" due to a usermachine who chrashes.... how can i close "all
conections" ? instead of sending a mail to the users and asking to
restart OO :-)
In this case, we need to talk about the definition of "locked" :)
If there is a .lck file besides the .odb file, this doesn't mean the
database is "locked" in a file system sense. Instead, it just means that
either somebody has an open connection to this database, or the last
instance which had an open connection did not shutdown properly.
HSQLDB, the engine used in Base, is able to cope with the latter case
automatically. That is, upon next connection, it will recognize that the
previous connection did not properly shut down, and recover the database.
However, I now seem to understand that you're trying to access a shared
.odb file, with embedded HSQLDB, simultaneously with multiple users. Is
this correct? If so, then your "locked" probably means that the second
user cannot connect to the .odb file at all. This is since Base with
embedded HSQL currently simply does not support this scenario at all.
Such databases are strictly single-user at the moment.
Oh... that explains a lot, we uses an embedded HSQLDB with 100 users but
only for Reading some information and that works fine. I stupidly went a
step to far and tryed to Store some information. Puting the Tables on
our MSQL will sove the problem
Thanks
Ciao
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
