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>
java:
@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;
}
}
