An IDEA's bug or a limitation of hsqldb?

I already have a data source connects to a hsqldb database (by url: jdbc:hsqldb:file...). When I open "Data Sources" dialog and refresh the database the first time, everything is fine. But from the second time, I have a SQLException "The database is already in use by another process..."

Is it an IDEA's bug or a limitation of hsqldb?

5 comments

Hello t800t8,

I already have a data source connects to a hsqldb database (by url:
jdbc:hsqldb:file...). When I open "Data Sources" dialog and refresh
the database the first time, everything is fine. But from the second
time, I have a SQLException "The database is already in use by another
process..."

Is it an IDEA's bug or a limitation of hsqldb?


I think (but am not sure) that HSQL in "standalone" mode allows only a single
connection.
Perhaps IDEA is not properly releasing connections?

-tt


0

Perhaps IDEA is not properly releasing connections?


Taras,

Yes, it's what I'm thinking about. So I want to make sure before file a JIRA.

T.

0

Hello t800t8,

I observe the same with "jdbc:hsqldb:file:" URL. I think an issue can be
created.
However it allows to refresh many times with "jdbc:hsqldb:hsql:" URLs.

I already have a data source connects to a hsqldb database (by url:
jdbc:hsqldb:file...). When I open "Data Sources" dialog and refresh
the database the first time, everything is fine. But from the second
time, I have a SQLException "The database is already in use by another
process..."

Is it an IDEA's bug or a limitation of hsqldb?

Alexander.


0

Taras Tielkes wrote:

I think (but am not sure) that HSQL in "standalone" mode allows only a
single connection.
Perhaps IDEA is not properly releasing connections?


I believe it always keeps the connection open - I wish I could close it
as I have a database defined which gets created/recreated in unit tests,
but because IDEA keeps the connection open I can't drop it :(

0

Please sign in to leave a comment.