Skip to Content
0
Former Member
May 19, 2015 at 04:44 AM

UltraLite: batch process

21 Views

Hi,

Can I do batch processing using UltraLite's PreparedStatement?

I want to do something like following:

PreparedStatement preparedStatement = conn.prepareStatement(insertTableSQL);

preparedStatement.set(1, 101);

preparedStatement.set(2, "mkyong101");

preparedStatement.addBatch();

preparedStatement.set(1, 102);

preparedStatement.set(2, "mkyong102");

preparedStatement.addBatch();


preparedStatement.executeBatch();

I need help/suggestions regarding this.

Thanks and Regards

Shashi