title: Error during table creation
body: <p>I am trying to create a new table on a database but i am getting an error which says:</p>
  
  <blockquote>
    <p>Exception in thread "main" java.sql.SQLSyntaxErrorException: Table/View 'USERPRIVACYDB' does not exist.</p>
  </blockquote>
  
  <p>The code is as follows:</p>
  
  <pre><code>public class UserPrivacyData {
  
      private static String password = null;
      private final static String USER = "root";
      final String DRIVER = "org.apache.derby.jdbc.EmbeddedDriver";
      final String DATABASE_URL = "jdbc:derby://localhost:1527/USERPRIVACYDB;create=true;";
  
      public void loadDB() throws SQLException {
          try {
              Class.forName(DRIVER); //load the driver
                connection = DriverManager.getConnection(DATABASE_URL, USER, password);
        statement = connection.createStatement();
          } catch (Exception ex) {
              ex.printStackTrace();
          }
  String sql = "insert into USERPRIVACYDB values('" + gender[rand.nextInt(2)] + "',"
                      + " '" + privacyLevel[rand.nextInt(3)] + "', '" + age[rand.nextInt(3)] + "',"
                      + " '" + presentEducationLevel[rand.nextInt(3)] + "',"
                      + " '" + highestEducation[rand.nextInt(3)] + "', '"
                      + everVictimOfCrimeString + "', "
                      + " '" + crimeTypeString + "', "
                      + " '" + shareWithThirdParty[rand.nextInt(2)] + "',"
                      + " '" + reasonforChoiceofPrivacy[rand.nextInt(5)] + "')";
  
              statement.executeUpdate(sql);
             // }
  
          }
  
      }           
  </code></pre>
  
  <p>Can someone please help me? Thanks.</p>