struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amit Kumar Sharma" <amit...@sysarris.soft.net>
Subject RE: executeBatch
Date Mon, 26 Jul 2004 13:30:45 GMT
For this procedure would be the best bet...Reason := Oracle will take
care of the entire operation, Instead of mutilpe database hits from the
application its better to transfer the control and process....no need of
breaking it into batches also then...

Regards
Amit


-----Original Message-----
From: Shailender Jain [mailto:shailender.jain@teleatlas.com] 
Sent: Monday, July 26, 2004 6:48 PM
To: Struts Users Mailing List
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


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


Mime
View raw message