alexey_1 Posted May 13, 2014 Posted May 13, 2014 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"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 1all 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?
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now