title: Insert Statement into Derby Database
body: <p>I am trying to insert a number of values into a table in my java derby database, I am getting the error java.sql.SQLSyntaxErrorException: VALUES clause must contain at least one element. Empty elements are not allowed.</p>
  
  <pre><code>    public boolean registerStudent(Student student)
      {
          try
          {
          Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/AceDrivingSchool", "ADC", "ADC");
          Statement stmt = conn.createStatement();
          stmt.executeUpdate("INSERT INTO ADC.STUDENT(EMAILADDRESS, FORENAME, SURNAME, ADDRESSLINE1, ADDRESSLINE2,"
                  + " POSTCODE, TELEPHONENO, GENDER, PASSWORD, ISREGISTERED, ISVERIFIED, PASSEDTHEORY, PASSEDPRACTICAL, DRIVINGLICENSENO, DOB"
                  + ") VALUES('" + student.getEmailAddress() +
                  "', '" + student.getForename() + "', '" + student.getSurname() + 
                  "', '" + student.getAddressLine1() + "', '" + student.getAddressLine2() + "', '" + student.getPostcode() + 
                  "', '" + student.getTelephoneNo() + "', '" + student.getGender() + "', '" + student.getPassword() + 
                  "', '" + student.isIsRegistered() + "', '" + student.isIsVerified() + "', '" + student.isPassedTheory() + "', '" +
                  "', '" + student.isPassedPractical() + "', '" + student.getdrivingLicenseNo() + "', '" + 
                  new SimpleDateFormat("yyyy-MM-dd").format(student.getDob()) + "')");   
          conn.close();
          return true;
          }
          catch(SQLException ex)
          {
              ex.printStackTrace();
              return false;
          }
      }
  </code></pre>
  
  <p>This should right the values to my table</p>