Hi,
Have you tried to increase JVM heap size?
--
Leo
On Mon, Mar 19, 2012 at 7:50 AM, Pandey, Navin <navin.pan...@citi.com>wrote:
> Hi,****
>
> ** **
>
> I am using JXLS API to populate excel template. I have around 17000
> rows and 100 columns for each row: This is code snippet I am using:****
>
> ** **
>
> Connection con = ...// get connection****
>
> Statement stmt =
> con.createStatement();****
>
> String query = "SELECT * FROM
> employee";****
>
> ResultSet rs =
> stmt.executeQuery(query);****
>
> Map beans = new HashMap();****
>
> ResultSetCollection rsc = new
> ResultSetCollection(rs, false);****
>
> beans.put( "employee", rsc );****
>
> XLSTransformer transformer = new
> XLSTransformer();****
>
> transformer.transformXLS(
> templateFileName, beans, destFileName);****
>
> ** **
>
> ** **
>
> But it fails saying out of memory , what should I do for such a large
> amount of data. Please advice****
>
> ** **
>
> Regards,****
>
> Navin****
>
> ** **
>
> ** **
>
> ** **
>
>
> ------------------------------------------------------------------------------
> This SF email is sponsosred by:
> Try Windows Azure free for 90 days Click Here
> http://p.sf.net/sfu/sfd2d-msazure
> _______________________________________________
> jXLS-user mailing list
> jXLS-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jxls-user
>
>
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
