title: java.sql.sqlexception invalid column index
body: <p>Hello everyone can someone tell me what is wrong here ?
  I have a task i was asked and i am new in connecting oracle databases with java servlet.</p>
  
  <p>here is me code:</p>
  
  <pre><code>try {
      out.print("first");
      Class.forName("oracle.jdbc.OracleDriver");
      out.print("aaa");
      Connection con
              = DriverManager.getConnection(
                      "jdbc:oracle:thin:@localhost:1521:xe", "myusername", "mypassword");
      out.print("111");
      PreparedStatement ps = con
              .prepareStatement(
      "INSERT INTO signup 
           values(fn, ln, date, em, pa, crnum)
      ");
                      out.print("222");
      ps.setString(1, fn);
      ps.setString(2, ln);
      ps.setString(3, da);
      ps.setString(4, em);
      ps.setString(5, pa);
      ps.setString(6, cr);
  
      int i = ps.executeUpdate();
      if (i &gt; 0) {
          out.print("You are successfully registered...");
      }
  
  } catch (Exception e2) {
      out.println(e2);
  }
  
  out.close();
  response.sendRedirect("address");
  /* when press next bottom 
          it'll take me to add.html*/
  </code></pre>
  
  <p>and after i ran the whole code i get this :<code>java.sql.sqlexception: invalid column index</code></p>