for (CONDITION) {insert into }
Amit Kumar Sharma wrote:
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
