JDBC2.0 supports a concept of batch SQL. This has a lot of performance advantage over individual inserts.
-----Original Message----- From: bhaskar kumar rudrakshala [mailto:[EMAIL PROTECTED]] Sent: Freitag, 16. August 2002 10:48 To: [EMAIL PROTECTED] Subject: EJB Server Transaction Hi, I'm currently working on an application where there is a need for me to insert a nearly 10 to 20 thousand records at a shot. My question is a) whether can i insert the at a shot? b) Can i use a usertransaction of the server to insert all the records into the database in a single transaction. If i dont use the transaction then i should delete all the recoreds progrmattically. Regards RKS Bhaskar kumar _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". ==========================================================================To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
