litol xy February 2016

Database Manager can't connect to hsqldb

After inserting the data into HSQLDB, I tried using database manager to connect to it but it failed to connect.

i launched the hsqldb in standalone mode. here is the error message:

Connection to HSQLDB (Local) - target failed Database lock acquisition failure: 
lockFile: org.hsqldb.persist.LockFile@a9e38b36[file =C:\Program Files (x86)\JetBrains\IntelliJ IDEA 15.0.2\bin\target\misc.lck, exists=false, locked=false, valid=false, ] 
method: openRAF 
reason: java.io.FileNotFoundException: C:\Program Files (x86)\JetBrains\IntelliJ IDEA 15.0.2\bin\target\misc.lck (The system cannot find the path specified)

Answers


jiming February 2016

If you are launch the hsqldb in standalone mode. It will happen like you said.

In this mode. DB engine will share the same jvm as application, the process will be faster than server mode. but the bad thing is you can't access it from outside. including database manager.

If you want view the data by tools. Please launching the db in server mode

Post Status

Asked in February 2016
Viewed 2,757 times
Voted 5
Answered 1 times

Search




Leave an answer