Performance issue with jakarta POI

2006-07-20 Thread Abh N
Hi, I am building xls with jakarta POI by fetching the records from database. There are 30K records fetched from DB. Process takes 40 min to complete. Any best practises on using POI api to improve the performance. I dont see issue with the query as The query is very simpl

Re: Intermediate write in JSP

2006-07-18 Thread Abh N
does not reaches peak limit. Do I need to run gc after looping for some record set Michael Jouravlev <[EMAIL PROTECTED]> wrote: Try setting buffer size to (8x10^6/3x10^4)x500 == 135K. On 7/18/06, Abh N wrote: > Hi, > > I have requirement where in I have to fetch around 30k (

Intermediate write in JSP

2006-07-18 Thread Abh N
Hi, I have requirement where in I have to fetch around 30k (size around 8MB) records from DB and render in xls. I am looping through the result set and then using response.getOutputStream for writing the data The server has a time out of 5min so by the time data gets completely

RE: need inputs on connection pool

2006-04-05 Thread Abh N
plicitly calling the conn.close() method, you are telling the connection pooling manager that you are finished with this connection and it can immediately return the connection to the pool. -Original Message- From: Abh N [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 05, 2006 11

need inputs on connection pool

2006-04-05 Thread Abh N
Hi, we are implementing the connection pooling in our application. connections are taken from the data source. After getting the connection i need to confirm whether i have to explictly close the connection like conn.close () i want to know in above case whether connect

need inputs on connection pool

2006-04-05 Thread Abh N
Hi, we are implementing the connection pooling in our application. connections are taken from the data source. After getting the connection i need to confirm whether i have to explictly close the connection like conn.close () i want to know in above case whether connect

RE: File upload issue

2006-01-16 Thread Abh N
You are correct. I probably should not have posted this question here. I was just in a hope that if anybody have worked on multiple platform and are aware of known issue might be able to help me. "Caldarale, Charles R" <[EMAIL PROTECTED]> wrote: > From: Abh N [mail

File upload issue

2006-01-15 Thread Abh N
Hi, We are migrating our application from Tomcat to Webshpere environment. There is a file upload utility in our application which uses multipart request feature from com o'reilly. This functionality works fine in tomcat but errors out in websphere. It stops while getting object for Mul

Migration

2006-01-06 Thread Abh N
Hi, We are migrating our applications from Tomcat to Websphere server. We are getting some issues (in Websphere )with code which used to work fine in Tomcat. Server is not recognizing IOException in jsp code. I am now putting import java.io.* to resolve this. Am not able to und