Dear Shailender,
What type of insert are you trying to do, is it a single insert(eg:
Insert into (select * from *)) or multiple insert (eg
for(CONDITION){insert into})
Regards
Amit
-----Original Message-----
From: Shailender Jain [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 10:07 AM
To: [EMAIL PROTECTED]
Subject: executeBatch
Hi,
I want to insert some 3000 records in the database.
I tried using executeBatch() to insert all the records at a go.
But the application gets hang and nothing happens.
When i try using PreparedStatement then it does work and just takes some
30 seconds.
I am using Informix as the database and the DriverClass in ifxjdbc.jar.
I checked the specification of the driver
and it promises to be jdbc2.0 compliant.
Any idea on how to improve the performance?
Regards
Shailender Jain
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
