1 Reply Latest reply on Apr 26, 2007 2:45 PM by Norman Richards

    PDF, max of 14560 rows

    pis ta Newbie

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