java.sql.BatchUpdateException: invalid argument(s) in call

Well I would recommend specifiying column names in the query String too, but I think you problem lies in setting the arguuments.

And more specifically the problem is with ps.addBatch() call, in fact you better use Statement and its .addBatch(String sql) method accepts an SQL String so i will take in consideration the updated SQL query in each iteration, so just make sure to pass it in ps.addBatch(sql).

And why would your for loop start from 1 and then use .get(i-1), if it can simply start from 0?

Just update your code accordingly:

public void insert(List < Employee > str, Connection con) throws SQLException {
  String sql = "insert into tbl_list(e_name,e_id) values (?,?)";
  Statement ps = con.createStatement();

  for (int i = 0; i <= str.size(); i++) {
    ps.setString(1, str.get(i).getName());
    ps.setString(2, str.get(i).getId());
    ps.addBatch(sql); //Note the sql String here
  }
  ps.executeBatch();
  ps.close();
  con.close();
}

And if the problem persists with setting query arguments, why don't you just create the query in the loop itself and change it dynamically?

Here's what I suggest here:

for (int i = 0; i <= str.size(); i++) {
    String sql = "insert into tbl_list(e_name,e_id) values ('"+str.get(i).getName()+"','"+str.get(i).getId()+"')";
    ps.addBatch(sql);
}

You can take a look at this Batch Insert In Java – JDBC tutorial for further reading and for full options.

Your query contain (?,?,?,?,?,) 5 ? and a typo , in the end, but you only set 2 parameters to your query :

ps.setString(1, str.get(i-1).getName());
ps.setString(2,str.get(i-1).getId());

Instead you have to correct your query, and like @Berger mention in comment, you have to specify the columns names in your query :

String sql = "insert into tbl_list(col_name1, col_name2) values (?,?)";

Or you have to set the correct number of your parameters.

You have also to use con.setAutoCommit(false); and con.commit(); like this :

con.setAutoCommit(false); // disabling autoCommit is recommend for batching

PreparedStatement ps = con.prepareStatement(sql);

for (int i = 1; i <= str.size(); i++) {
    ps.setString(1, str.get(i - 1).getName());
    ps.setString(2, str.get(i - 1).getId());
    ps.addBatch();
}
ps.executeBatch();

con.commit();//commit statements to apply changes 

Check this loop. Here in case of i=0 it is fetching (0-1) that is -1. As we know List provides 0 based indexing so your str.get(..) should start from 0 not from -1

try this

     public void insert(List<Employee> str, Connection con) throws SQLException {
    String sql = "insert into tbl_list values (?,?)";
    PreparedStatement ps = con.prepareStatement(sql);
       for (Employee e:str) {
        ps.setString(1, e.getName());
        ps.setLong(2, e.getId());
        ps.addBatch();
       }
    ps.executeBatch();
    ps.close();
    con.close();
}

The stacktrace is:

`May 16, 2017 2:34:40 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [spring] in context with path [/insert] threw exception [Request processing failed; nested exception is java.sql.BatchUpdateException: invalid arguments in call] with root cause java.sql.BatchUpdateException: invalid arguments in call at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at dao.insert.preparedInsert(insert.java:322)

insert.java :322 is ps.executeBatch();`