OT: Off topic (was Re: executeBatch)

[DG...@EvergreenInvestments.com]

Too....much....noise.




"Shailender Jain" <sh...@teleatlas.com> 
07/26/2004 09:18 AM
Please respond to
"Struts Users Mailing List" <us...@struts.apache.org>


To
Struts Users Mailing List <us...@struts.apache.org>
cc

Subject
Re: executeBatch






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