title: Columns of type integer cannot hold values of type char
body: <p>I have a table named <code>BENEFICTOR</code> in my database. When I try to insert into this table it gives me the following error:</p>
  
  <blockquote>
    <p>columns of type integer cannot hold values of type char and i am typing a true values in the textfields (T1,T2,...).</p>
  </blockquote>
  
  <pre><code>private void Add_PeopleActionPerformed(java.awt.event.ActionEvent evt) {                                           
      // TODO add your handling code here:
  
      int bid=Integer.parseInt(T1.getText());
      int fid=Integer.parseInt(T2.getText());
      int idnum=Integer.parseInt(T5.getText());
      int age = Integer.parseInt(T14.getText());
      try{
          String url="jdbc:derby://localhost:1527/spc";
          String username="issam";
          String password="issam";
          Connection con=DriverManager.getConnection(url,username,password);
          Statement stmt=con.createStatement();
  
          String Query="INSERT INTO BENEFICTOR (BID,FID,FULL_NAME,GENDER,AGE,IDNUM,STATUS,ORIGINAL_AREA,RECENT_AREA,EVAL,PHONE_NUMBER1,PHONE_NUMBER2,SITUATION,VISIT) VALUES ("+bid+" , "+fid+" , '"+T3.getText().toString()+"' , '"+T4.getSelectedItem().toString()+"' , "+age+" , "+idnum+" , '"+T6.getSelectedItem().toString()+"' , '"+T7.getText().toString()+"' , '"+T8.getText().toString()+"' , '"+T9.getSelectedItem().toString()+"' , '"+T10.getText().toString()+"' , '"+T11.getText().toString()+"' , '"+T12.getText().toString()+"' , '"+T13.getText().toString()+"')";
          stmt.executeUpdate(Query);
          JOptionPane.showMessageDialog(null,"A Person Added To Database");
          T1.setText(null);
          T2.setText(null);
          T3.setText(null);
          T4.setSelectedItem(0);
          T5.setText(null);
          T6.setSelectedItem(0);
          T7.setText(null);
          T8.setText(null);
          T9.setSelectedItem(0);
          T10.setText(null);
          T11.setText(null);
          T12.setSelected(true);
          T13.setSelected(true);
          T14.setText(null);
  
      }
      catch(SQLException ex){
          JOptionPane.showMessageDialog(null, ex.toString());
      }
  }   
  </code></pre>
  
  <p>can anyone tell me how can i fix this ? thank you.</p>
  
  <p>Here Is the Types of columns fields: </p>
  
  <pre><code>BID:INTEGER,FID:INTEGER,FULL_NAME:VARCHAR,GENDER:VARCHAR,AGE:INTEGER,IDNUM:INTEGER,STATUS:VARCHAR,ORIFINAL_AREA:VARCHAR,RECENT_AREA:VARCHAR,EVAL:VARCHAR,PHONE_NUMBER1:INTEGER,PHONE_NUMBER2:INTEGER,SITUATION:VARCHAR,VISIT:VARCHAR
  </code></pre>
  
  <p>The <code>Status</code>, <code>Gendre</code>, <code>eval</code> are all ComboBoxes. <code>visit</code> and <code>Situation</code> are checkBoxes</p>