title: executeUpdate is not working after a loop
body: <p>I'm trying to copy data from a database to another so I have the below code, the insertion inside the loop is perfect but the second insertion is not working and gives no error </p>
  
  <pre><code>            Statement st = con.createStatement();
              rs=st.executeQuery("select id,cardid,a2,a2b,a2c,a2e,a17,a11,a16,a15,a14,a20a from a");
              while (rs.next()){
                  a=rs.getString(1);
                  b=rs.getString(2);
                  c=rs.getString(3);
                  d=rs.getString(4);
                  e=rs.getString(5);
                  f=rs.getString(6); 
                  g=rs.getString(7); 
                  h=rs.getString(8);
                  i=rs.getString(9);
                  j=rs.getString(10);
                  k=rs.getString(11);
                  l=rs.getString(12);
                  //sql="insert into rpttbl (empid) values ("+a+");";
                  sql="insert into rpttbl (temp,empid,name,fname,gname,sname,jkind,jstatus,emplevel,emptitle"
                          + ",cert,pay,pos,except,cens,cuts,med,job,presd,outjob,other,iban) values ("+a+","+"\""+b+"\""+","+"\""+c+""
                          + "\""+","+"\""+d+"\""+","+"\""+e+"\""+","+"\""+f+"\""+","+"\""+g+"\""+","+"\""+h+"\""+","+"\""+i+"\""+""
                          + ","+"\""+j+"\""+","+"'visacard'"+","+"\""+k+"\""+","+"\""+l+"\""+","+"0"+","+"0"+","+"0"+","+"0"+""
                          + ","+"0"+","+0+","+0+","+"0"+","+"0"+");";
                  rptStmt= conCreate.prepareStatement(sql);
                  rptStmt.executeUpdate(sql);
                  //System.out.println("cccccc");
              }
  
  
              sql="insert into rpttbl (tax) values (111)";
              rptStmt= conCreate.prepareStatement(sql);
              rptStmt.executeUpdate(sql);
  
              }
  </code></pre>
  
  <p>edit: I notice that only the last row of the table has tax=111</p>