[jboss-user] [JBoss Seam] - PDF, max of 14560 rows

[pista666]

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;
  |         }
  | }
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041118#4041118

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4041118