Explain how to do batch updates using CallableStatement interface. ?

Question

Hi we want know about how to do batch updates using CallableStatement interface.

Senthilkumar · Answer

Hi Abhishek Please go through the below urls: http://www.careerride.com/java-batch-updates-using-CallableStatement-interface.aspx http://www.jeggu.com/2010/08/how-can-we-do-batch-updates-using.html

Satyapriya Nayak · Answer

Hi Abhishek Batch update is the ability to add more than one statement at once. CallableStatement.executeBatch() method is used to execute the batch of statements. This will return integer number of records updated if it returns other than that BatchUpdateException will occur. For Example: try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection con = DriverManager.getConnection(jdbc:odbc:students); Callable Statement c= con.prepareCall({Call insert_data(??)}); //set input parameters c.setInt(110); c.setString(2ABC); c.addBatch(); c.setInt(111); c.setString(2DEF); c.addBatch(); int [] updateCounts = c.executeBatch(); } catch(BatchUpdateException bu) { System.out.println(bu); } catch(SQLException e) { System.out.println(e); } catch(ClassNotFoundException e1) { System.out.println(e1); } } } Thanks