title: HSQL database user lacks privilege or object not found error try insert data into database
body: <p>I try to read data from text file then insert into database but keep getting error.</p>
  
  <p>Below is the code I am writing</p>
  
  <pre><code>Class.forName("org.hsqldb.jdbcDriver");
  connection = DriverManager.getConnection("jdbc:hsqldb:TestDB", "sa", "123");
  connection.prepareStatement("drop table people if exists;").execute();
  connection.prepareStatement("create table people (id integer, name varchar(20) not null, picture varchar(20), detail varchar(40), gender varchar(5), age integer, state varchar(5), primary key(id));").execute();
  String fileName = "/Users/da/Desktop/AP Assignment 2/people.txt";
  BufferedReader br = new BufferedReader(new FileReader(fileName));
  while (strLine != null) {
      String data[] = null;
      strLine = br.readLine();
      data = strLine.split(",");
      int id = Integer.parseInt(data[0]);
      String name = data[1];
      String picture = data[2];
      String detail = data[3];
      String gender = data[4];
      int age = Integer.parseInt(data[5]);
      System.out.println(age);
      String state = data[6];
      String sql = "insert into people(id, name, picture, detail, gender, age, state) values (" + id + "," + name + ", " + picture + ", " + detail + ", " + gender + ", " + age + ", " + state + ")";
      connection.prepareStatement(sql).execute();
      connection.commit();
  }
  br.close();
  </code></pre>