RE: executeBatch

2004-07-26 Thread Thiharie Rajesh
Have you written a Stored Procedure on the database to handle your batch. You can send an array containing all the values you need to insert/update via the batch. It will help you to cut down / lower execution time significantly, i.e., improve performance. You can also try to pass the array of val

RE: Multiple Databases.

2004-06-06 Thread Thiharie Rajesh
It is best to use the application server connection pool. Do not use the Jakarta Struts connection pool. Rajesh -Original Message- If you are using tomcat, then I believe you can use dbcp. (I think that's what Riyad Kalla was talking about too..) We use dbcp but only for connecting to