Hi GN developers/users,
The latest version of GN trunk and also the ANZMEST SVN7850 GN vesion comes
with the new H2 database. I can manage to connect to it using the Squirrel 3.2.1 SQL database
client but only when Geonetwork is not running. When GN
is running attempting to connect gives an error message:
H2 GN: Database may be already in use: "Locked by another process".
Possible solutions: close all other connection(s); use the server mode [90020-152]
It seems this could be because a lock file geonetwork/jetty/geonetwork.lock.db
exists.
FYI here were my database/JDBC/connection details:
Squirrel 3.2.1 SQL
h2 driver copied from web/geonetwork/WEB_INF/lib/h2-1.3.152.jar to squirrel lib
driver class: org.h2.driver
Connection details:-
Driver: H2 Embedded
URL: jdbc:h2:C:\ANZMEST_7850\geonetwork\jetty\geonetwork
User Name: admin
Password: gnos
Can I configure the database client to be able to connect to GN
when its running?
Andrew