How to insert multiple rows

[Former Member]

I am new to MaxDB, how do you insert multiple rows to the table

Thanks for your help

[Former Member]

Hi,

Please check this weblog

/people/kathirvel.balakrishnan2/blog/2005/08/19/inserting-multiple-records-from-xml-files-into-maxdb-database

Cheers

Kathir~

[Former Member]

Hi,

Please find the solution below,

/people/kathirvel.balakrishnan2/blog/2005/08/15/inserting-multiple-records-into-maxdb-database

Cheers

Kathir~

[Former Member]

Hi Sam,

Check this one hope this will be helpful.

/people/kathirvel.balakrishnan2/blog/2005/01/25/batch-mode-operation-in-maxdb-using-maxdb-loader-and-java

cheers

Kathir~

[former_member185699]

Hello,

it depends on the kind of interface do you use. For JDBC the following code snippet give you an example:

int numverOfRows = 100;
//prepare a statement
PreparedStatement batchInsert = connection.prepareStatement("INSERT INTO MYTABLE values (?,?)");
//add values
for (int i = 0; i < numverOfRows; ++i) {
  batchInsert.setInt(1, i);              
  batchInsert.setString(2, "VALUE_"+i);
  batchInsert.addBatch();
}
//execute the insert statement
batchInsert.executeUpdate();

Hope that helps,

Marco