struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shailender Jain" <shailender.j...@teleatlas.com>
Subject Re: executeBatch
Date Mon, 26 Jul 2004 13:18:25 GMT
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:shailender.jain@teleatlas.com]
> Sent: Monday, July 26, 2004 10:07 AM
> To: struts-user@jakarta.apache.org
> 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: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Mime
View raw message