hi,
i'm only able to print out 14560 row per table in pdf.
Sometimes i get 1row sometimes (and always after jboss restart) 14560.
No exception, No error ... :(
i'm using postgres, report query always retrieves 100 000 rows.
thanks for any idea
stefan
xhtml:
<table columns="5"> <cell><paragraph>num</paragraph></cell> <cell><paragraph>produkt_id</paragraph></cell> <cell><paragraph>type</paragraph></cell> <cell><paragraph>name</paragraph></cell> <cell><paragraph>comment</paragraph></cell> <ui:repeat value="#{PrProduktReport.testQuery.resultList}" var="i"> <cell><paragraph>#{i[0]}</paragraph></cell> <cell><paragraph>#{i[1]}</paragraph></cell> <cell><paragraph>#{i[2]}</paragraph></cell> <cell><paragraph>#{i[3]}</paragraph></cell> <cell><paragraph>#{i[4]}</paragraph></cell> </ui:repeat> </table>
@Name("PrProduktReport") @Scope(ScopeType.SESSION) public class PrProduktReport implements Serializable { @In EntityManager entityManager; @Logger Log log; public Query testQuery; public Query getTestQuery(){ testQuery = entityManager.createNativeQuery("select nextval('seq1'), produkt_id as produkt_id, produkt_typ, nazov, poznamka from pr_produkt limit return testQuery; } public void setTestQuery(Query testQuery) { this.testQuery = testQuery; } }
Please open a JIRA case. We can't avoid keeping the whole document in memory now, but assuming memory isn't an issue I don't know anything that would cause part of the document to be lost.