I have downloaded Geonetwork and opened it with NetBeans IDE 8.0.2. In that project, there exists some SQL files. How can i run them or create database based on these files?
Edit:
I have done some more research, and all i need is to connect to H2 driver, but somehow, i can't. It shows me this:
Cannot establish a connection to jdbc:h2: using org.h2.Driver (IO Exception: "java.io.FileNotFoundException: C:\Program Files\NetBeans 8.0.2\ .lock.db (The filename, directory name, or volume label syntax is incorrect)"; "C:\Program Files\NetBeans 8.0.2\ .lock.db" [90031-152]). So, how to fix this?
Asked
Active
Viewed 2,319 times
1
Stefan Mihajlovic
- 39
- 1
- 6
-
update your questions, it is better to follow the question than looking in the answers. I would like to see your java connection url (jdbc url). Should be something like jdbc:hsqldb:hsql://localhost/testdb – MrSimpleMind Jun 08 '15 at 12:09
-
I have updated, thanks. – Stefan Mihajlovic Jun 08 '15 at 12:20
-
please provide your jdbc url connection – MrSimpleMind Jun 08 '15 at 12:34
1 Answers
0
Go thru this document and you will have your database, Derby will give you a quick setup for your need.
NetBeans - Working with the Java DB (Derby) Database
Just remember to open your geonetwork sql files, from the file browser navigate to the location of the saved sql file and click open...
If you have other database already installed, such as MySQL, Oracle etc. You can check the documentation here (see database section)
MrSimpleMind
- 7,890
- 3
- 40
- 45
-
You have answered my question, but after you answered i have realized that this is not what i need. I have explained in answer above. – Stefan Mihajlovic Jun 08 '15 at 11:48