title: hsqldb-2.2.6 creating tables and inserting data from a script
body: <p>I have following commands in Test.sql<br>
  create table MY_USER (id int,name varchar(10));<br>
  INSERT INTO MY_USER VALUES(1 ,'Test1');<br>
  INSERT INTO MY_USER VALUES(2 ,'Test2');</p>
  
  <p>Java Code:-</p>
  
  <p>Connection c = DriverManager.getConnection("jdbc:hsqldb:file:Test.sql, "sa", "");<br>
  Statement statement = c.createStatement();<br>
  statement.executeQuery("select * from MY_USER where name = 'Test1' ");<br>
  statement.execute("SHUTDOWN");<br>
  statement.close();  </p>
  
  <p>Issue:
  its giving me 
  java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: MY_USER</p>