Re: [Hsqldb-user] database already in use

[fredt <fr...@us...>]

The only circumstances I know of that can currently create this issue is if
the FIRST connection attempt (opening the DB) is unsuccessful due to:

(a) wrong user / pw

(b) database already open by another process (as server or standalone)

(c) internal error due to corrupt DB files.


Fred Toussi
--------------

SB wrote:

This error is coming only in standalone mode, and not in
webserver mode - simultaneous connections are accepted in
the server mode.

I dont know what details I can provide, but the connections
are opened by DriverManager.getConnection( dsn, usr, pwd )
where dns is 'jdbc:hsqldb:e:\filename', usr is 'sa', pwd
is "".

> Please provide more details on how the connections are opened.
>
> Fred Toussi
>
> --------------
>
> SB wrote:
>
> I am using 1.7.1 RC4 only, are there any logs that I can provide you?
>
> > Several simultaneous connections can be made to a database, but the
first
> > connection takes a while to open the DB and other connection attempts
> should
> > block in the meantime. The blocking did not take place in previous
> versions,
> > resulting in the wrong error message.
> >
> > Fred Toussi
> >
> > SB wrote:
> >
> > What does this error mean?
> > java.sql.SQLException: The database is already in use by another process
> >
> > How many simultaneous connections can be made to hsqldb? is there a
limit?
>


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user