title: Relative path to hsqldb files in a web app doesn't work?
body: <p>I'm using hsqldb for my Spring-based java webapp. I put database files (mydb.lck, mydb.properties,..) in src\main\java\data folder so that they're published into WEB-INF\classes\data.</p>
  
  <p>In datasource configuration, I specify this relative path to JVM working directory. As guided in hsqldb documents.</p>
  
  <p><code>portal.jdbc.url=jdbc:hsqldb:file:/data/mydb</code> (Is this seperator right for Windows?)</p>
  
  <p>But Spring seem not find this path and insist on claiming</p>
  
  <p><code>java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CUSTOMER
      org.hsqldb.jdbc.Util.sqlException(Unknown Source)
  </code></p>
  
  <p>However, if I specify an absolute path, it works flawlessly</p>
  
  <p><code>portal.jdbc.url=jdbc:hsqldb:file:d:\\TomcatServer\\apache-tomcat-7.0.10\\wtpwebapps\\myportal-app\\data\\mydb</code></p>
  
  <p>Should I miss understanding JVM working directory on a web app? 
  Any help is appreciated.</p>