title: sql error or missing database (no such table found)
body: <p>I am working on eclipse and using sqlite as database on windows 10 64 bit operating system. Now when i try to get all values from my database it shows the message that there is no such table but the connection is being established. 
  What should i do??</p>
  
  <pre><code>try {
      Class.forName("org.sqlite.JDBC");
      conn=DriverManager.getConnection("jdbc:sqlite:C://Users//APARAJIT//Desktop//Projects//kbcc.sqlite");
  } catch (Exception e) {
      JOptionPane.showMessageDialog(null,"can't open database");
  }
  
  try {
      Statement stmt = mycon.createStatement();
      String sql = "SELECT * FROM record";
      PreparedStatement pst = mycon.prepareStatement(sql);
      ResultSet rs = pst.executeQuery();
  
      rs.close();
      pst.close();
      stmt.close();
  } catch (Exception e) {
      JOptionPane.showMessageDialog(frame, e);
  }
  </code></pre>