tag:blogger.com,1999:blog-8757327572165583509.post4238465835129611531..comments2023-11-15T14:34:28.681-05:00Comments on DMottab.blogspot.com: Statement (addBatch, executeBatch, clearBatch): Ejecutar insert, update por lotesDavid Mottahttp://www.blogger.com/profile/01952174965291761992noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8757327572165583509.post-62731034712582027652012-08-01T16:49:07.880-05:002012-08-01T16:49:07.880-05:00qwertyuiopqwertyuiopAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8757327572165583509.post-29792775390736037762012-04-12T09:32:20.907-05:002012-04-12T09:32:20.907-05:00Hola.
Yo no se si lo estoy haciendo bien, pero h...Hola. <br /><br />Yo no se si lo estoy haciendo bien, pero hago lo mismo, y funcionar funciona, pero tengo la sensación de que se está introduciendo en la bbdd un solo campo a la vez ... luego es muuuuy lento<br /><br />Este es mi código:<br /><br /> public void insertarDatos (ArrayList lista){<br /><br /> Connection connection = null;<br /> PreparedStatement statement = null;<br /> try {<br /> connection = getCx();<br /> statement = connection.prepareStatement("INSERT INTO logs (ip,time,request,referer,httpcode) VALUES (?,?,?,?,?)");<br /> for (int i = 0; i < lista.size(); i++) {<br /> BeanLog bl = (BeanLog)lista.get(i);<br /> statement.setString(1, bl.getIp());<br /> statement.setString(2, bl.getTime());<br /> statement.setString(3, bl.getRequest());<br /> statement.setString(4, bl.getReferer());<br /> statement.setInt(5, bl.getHttpcode());<br /> statement.addBatch();<br /> if ((i + 1) % 1000 == 0) {<br /> statement.executeBatch(); // Ejecuto cada 1000 items.<br /> }<br /> }Anonymoushttps://www.blogger.com/profile/15404070947831674437noreply@blogger.com