Inserting Multiple Rows (10000+) at same time

Hi:

I am using my Java Servlets to populate the Oracle DB.

How do I insert 1000+ rows into same/different tables from within the Java Servlet Application.

What I did is:
String query = insert into emp values('aaa',100);

query += insert into emp values('aab',101);
query += insert into emp values('aac',102);
query += insert into emp values('aad',103);
query += insert into emp values('aae',104);
query += insert into emp values('aaaz',1000001);

ResultSet rs = stmt.executeQuery(query);

// In the end "query" stores a BIG chunk of INSERT statemenst separeted by sem-colons which is then passed to ResultSet ....

When I run my Java Servlet - it throws DB Error on above - can anyone tell me what's the better way of doing this...?

THANKS! HARI Received on Mon Nov 25 2002 - 18:35:51 CET