hsqldb with tomcat
I have an hsqld 1.8 database using the jdbc driver. DBSight 4.2.8 is installed on a tomcat6 server on ubuntu 11.04 server.
DBSight comes up okay but I cannot get it to validate my database.
My url is: "jdbc:hsqldb:/home/jay/Desktop/inhdb/inhdb"
(I have the files on the Desktop for now to test).
I keep on receiving the following error:
Test failed! [java.sql.SQLException: File input/output error /home/jay/Desktop/inhdb/inhdb.properties java.io.FileNotFoundException: /home/jay/Desktop/inhdb/inhdb.properties.new (Permission denied)]
I've tried changing the permissions of the inhdb folder and inhdb.properties and inhdb.script so it is owned by user tomcat6 but that didn't work. I've also tried running tomcat6 as root but that didn't work either.
I know the database is working because I can access it with the program I use to add information. Also, I was able to access it with dbsight when installed on a Windows computer.
Any suggestions on fixing this ever so annoying problem?