batch updating mysql

[mat buckland]

I have a Container of objects in my server, which regularly need writing to the database. At the moment I simply iterate through the container and do an executeUpdate() for each object.

This is slow though. Is there a way I can create an update that will send all the objects to the database in one cumulative update instead of many?

thanks

[mat buckland]

tis ok, i've found the answer!

[Campbell Ritchie]

Well done

For the benefit of future generations searching this forum, how did you do it?

[mat buckland]

good point!

Like this:

http://www.java2s.com/Code/Java/Database-SQL-JDBC/BatchupdateforMySQL.htm

[Campbell Ritchie]

It's nice when you can find links like that, isn't it