title: SQLException: Missing IN or OUT parameter at index:: 1
body: <p>I've made certain jtextfield, jRadioButtons, and some text areas. I want them to insert to data entered in these SQL Database. I've made the following code:</p>
  
  <pre><code>Connection conn = null;
      //Statement stm = null;
      PreparedStatement pst = null;
      ResultSet rs = null;
      try{
  
          Class.forName("oracle.jdbc.OracleDriver");
          System.out.println("Driver Loaded.");
          conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hr", "hr");
          System.out.println("Driver Connected.");
          pst=conn.prepareStatement("insert into directorsdb (DIRECTOR_NAME, DOB, DIN, PAN, UIN, BIRTH_PLACE, PASSPORT, DRIVING_LIC, NATIONALITY, OCCUPATION, OCCUPATION_COMPANY, DESIGNATION, QUALIFICATION, ADDRESS_OFF, ADDRESS_RESI, CONTACT_HOME, CONTACT_WORK, CONTACT_MOBILE, EMAIL_PERSONAL, EMAIL_WORK, EMAIL_OTHER, SECRETARY_NAME, SECRETARY_CONTACT, SECRETARY_EMAIL, DSC, DSC_EXPIRY, FATHER_NAME, MOTHER_NAME, APPOINTMENT_DATE, POSITION_BOARD, CESSATION_DATE, CESSATION_REASON, PROMOTER, INDEPENDENT_DIRECTOR, ABOUT)"
                                    + "values("+jFormattedTextField1.getText()+"','"+jDateChooser1.getDate()+"','"+DIN.getText()+"','"+PAN.getText()+"','"+UIN.getText()+"','"+jFormattedTextField4.getText()+"','"+passportno.getText()+"','"+dlicense.getText()+"','"+jFormattedTextField5.getText()+"','"+jFormattedTextField6.getText()+"','"+jFormattedTextField7.getText()+"','"+jFormattedTextField8.getText()+"','"+jFormattedTextField9.getText()+"','"+officeadd.getText()+"','"+residentialadd.getText()+"','"+jFormattedTextField12.getText()+"','"+jFormattedTextField13.getText()+"','"+jFormattedTextField14.getText()+"','"+jFormattedTextField15.getText()+"','"+jFormattedTextField16.getText()+"','"+jFormattedTextField17.getText()+"','"+jFormattedTextField18.getText()+"','"+jFormattedTextField19.getText()+"','"+jFormattedTextField20.getText()+"','"+buttonGroup1.getSelection().getActionCommand()+"','"+jDateChooser2.getDate()+"','"+jFormattedTextField22.getText()+"','"+jFormattedTextField23.getText()+"','"+jDateChooser3.getDate()+"','"+jFormattedTextField25.getText()+"','"+jDateChooser4.getDate()+"','"+jTextArea2.getText()+"','"+buttonGroup2.getSelection().getActionCommand()+"','"+buttonGroup3.getSelection().getActionCommand()+"','"+jTextArea1.getText()+"',')");
  
          pst.execute();
  
          if(pst.execute()==true){
           JOptionPane.showMessageDialog( null, "Saved Successfully!!");   
          }else{
              JOptionPane.showMessageDialog( null, "Saved Successfully!!");
          }
  
      }catch(SQLException e){
          System.err.println(e.fillInStackTrace());
      }
       catch(ClassNotFoundException ex){
           System.err.println(ex);
       } 
  </code></pre>
  
  <p>The exception I'm getting is:</p>
  
  <pre><code>SQLException: Missing IN or OUT parameter at index:: 1
  </code></pre>
  
  <p>Help me in rectifying the same.</p>