Jump to content

Recommended Posts

Posted

Hi, I have the following problem:

I try to create a simple report from 1 postgewSQL table "Cotracts"(JDBC connection). It's very huge and contains about ~5 million rows. 

My activity:

File->New->Jasper Report->Choose Blank A4 template->Next->choose foldier "My Reports"->Next->Then I Select my data Adapter->

Now I give a query: 

SELECT * 

FROM "Contracts" 

and click "Next"->Then JasperSoft Studio begins Retrieving Fields. But it doesn't only make a scheme of fields, understanding data types. As far as I understand, it downloads ALL data from my table.

It's clear from the memory consumption. I have 2 GB RAM, and in some minutes of "Retrieving Fields" JasperSoft Studio begins to consum practically all memory. (135 000 mb) 

Then I get an error (picture related). "java.lang.outofmemoryerror java heap space"2014-05-13_12-47-57.png.d5695aad54f9f382663a084025e49a13.png

I suppose that JasperSoft Stuido tries to download all data from table. By the by, I "solved" this by using the query:

SELECT * 

FROM "Contracts"  limit 1

all fields are retrieved quickly. And then I have to delete limit 1 expression and add new parametrs to report.

Is there any oppotunity to avoid all data downloading and usinfg "limit" expression?

 
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...