junejava

I have developed jsp page to show report from Jasperserver using javaserver web service. It works only for the reports using query time less than 600 seconds. If the reports take longer time, then I will get exception as below java.net.SocketTimeoutException: Read timed out at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.irplugin.wsclient.RepositorySoapBindingStub.runReport(RepositorySoapBindingStub.java:171) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:378) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at com.seamless.eire.service.impl.EIREServiceImpl.runReport(EIREServiceImpl.java:197) Do you know how to set the timeout to be longer than 600 sec?

Hi, I have 10 reports and I would like to run them everyday in sequential order. Ex, start runnning report1 and then when it finish , start running report2 and so on. I dont want to create 10 schedule jobs for the reports because I dont know when the first report will be finished running and I dont want several reports run on the same time. Is there anyway to do this on jasperserver? June

Hi, I m running jasperreport using ejbql on JBoss4.2 I have a problem with subreport could not perform createQuery. When I run the report I got exeption as following: java.lang.NullPointerException at org.jboss.ejb3.entity.ManagedEntityManagerFactory.getNonTxEntityManager(ManagedEntityManagerFactory.java:59) at org.jboss.ejb3.entity.ManagedEntityManagerFactory.getTransactionScopedEntityManager(ManagedEntityManagerFactory.java:164) at org.jboss.ejb3.entity.TransactionScopedEntityManager.createQuery(TransactionScopedEntityManager.java:132) at net.sf.jasperreports.engine.query.JRJpaQueryExecuter.createQuery(JRJpaQueryExecuter.java:157) at net.sf.jasperreports.engine.query.JRJpaQueryExecuter.createDatasource(JRJpaQueryExecuter.java:137) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:683) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:615) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1203) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:527) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Previously, My report didnt have subreport and it worked fine with ejbql on jboss and hibernate and then I need to add subreport to it which make the report could not run anymore. My mainreport has pass JPA_ENTITY_MANAGER to subreport as following: <subreport> <reportElement x="669" y="0" width="119" height="18" key="subreport-1"/> <subreportParameter name="JPA_ENTITY_MANAGER"> <subreportParameterExpression><![CDATA[$P{JPA_ENTITY_MANAGER}]]></subreportParameterExpression> </subreportParameter> <subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{SubLastChange}]]></subreportExpression> </subreport> Post edited by: junejava, at: 2008/03/13 15:11

For example, if you have $F{cast} as a collection, you can just pass new JRBeanCollectionDataSource($F{cast}) to your subreport. Ex. <subreport> <reportElement positionType="Float" x="20" y="25" width="240" height="20" isRemoveLineWhenBlank="true" backcolor="#99ccff"/> <dataSourceExpression>new JRBeanCollectionDataSource($F{cast})</dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA["JRMDbCastSubreport.jasper"]]></subreportExpression> </subreport>

Hi, I have an entity as the following @Entity class Entity1 implement Serializable { @Lob @Column(length=1024) UtilProperties fields; } class UtilProperties implement Serializable { Properties a; } UtilProperties is just a pojo class, not entity. I want to use ejbql to search Entity1 objects which have entity1.fields.a.key = "Key1", Is it possible?

I have tested the reports with Enterprise JBoss 4.2GA (production config) and they work fine. :) By the way, I found that we not need to explicitly specify all entities in persistence.xml. IReport will automatically detect them since it successfully established EJBQL connection from the entity manager. I m not sure if it is because I export my entities as jar files and put them in ireport/lib then IReport can detect it automatically. My entities also have attributes with UserDefine types. Thank you for your helps.It is really good that we finally solved this ireport and hibernate issue. junejava

I solved the problem about classes in my project could not found in ireport by put jar files of my project to ireport/lib and then ireport can find the classes. After that I got another problem with is about hibernate cache. What I have to do is edit persistence.xml by enable cache and add cache provider class as following: <persistence> <persistence-unit name="pu1"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <class>Person</class> <properties> <property name="hibernate.cache.use_second_level_cache" value="true" /> <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property> <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" /> <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/test1" /> <property name="hibernate.connection.username" value="root" /> <property name="hibernate.connection.password" value="root" /> </properties> </persistence-unit> </persistence> After that I got another problem about javax.jms.Message not found so I put jms.jar to ireport/lib. Finally EJBQL connection test successful!! :laugh: Post edited by: junejava, at: 2008/02/20 13:58

After I removed hibernate-metadata.jar and hibernate-ejb3-persistence.jar from ireport/lib and tried EJB connection from ireport, I got the following exception. I think it is the same as you got. I feel that we almost solve it :cheer: :cheer: Keep on testing. javax.persistence.PersistenceException: [PersistenceUnit: pu1] class or package not found at org.hibernate.ejb.Ejb3Configuration.addNamedAnnotatedClasses(Ejb3Conf iguration.java:1125) at org.hibernate.ejb.Ejb3Configuration.addClassesToSessionFactory(Ejb3Co nfiguration.java:905) at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java: 792) at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java: 186) at org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java: 246) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(Hib ernatePersistence.java:120) at javax.persistence.Persistence.createEntityManagerFactory(Persistence. java:51) at it.businesslogic.ireport.connection.EJBQLConnection.getEntityManager( EJBQLConnection.java:130) at it.businesslogic.ireport.connection.EJBQLConnection$1.run(EJBQLConnec tion.java:178)

Hi Giulio, I have updated ireport/lib/jpa.jar to ejb3-persistence.jar, jpa api come with hibernate. And I also update all hibernate lib in ireport/lib to be latest version but I still got the same exception. The following is my hibernate lib version. Hibernate Core 3.2.6.ga Hibernate Annotations 3.3.0 GA Hibernate EntityManager 3.3.1 GA Hibernate Validator 3.0.0 GA However, I m not sure if it is related to hibernate lib version because I use the same lib jars and run the reports on JBoss 4.2.0GA and they works fine. June.

I have updated hibernate3.jar under ireport/lib to be version 3.2.4 sp1. And I also put more jars of hibernat as following. hibernate-entitymanager.jar hibernate-annotation.jar hibernate-ejb3-persistece.jar hibernate-metadata.jar When I opened ireport using bin/ireport.bat and tried to test ejbql connection, I got the following exception in the console. C:Program FilesJasperSoftiReport-2.0.4>iReport.bat Exception occurred during event dispatching: java.lang.AbstractMethodError: org.hibernate.ejb.HibernatePersistence.createEnti tyManagerFactory(Ljava/lang/String;Ljava/util/Map; )Ljavax/persistence/EntityMana gerFactory; at javax.persistence.Persistence.createEntityManagerFactory(Persistence. java:83) at it.businesslogic.ireport.connection.EJBQLConnection.getEntityManager( EJBQLConnection.java:130) at it.businesslogic.ireport.connection.EJBQLConnection$1.run(EJBQLConnec tion.java:178) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Unknown Source) at java.awt.Component.show(Unknown Source) at java.awt.Component.setVisible(Unknown Source) at java.awt.Window.setVisible(Unknown Source) at java.awt.Dialog.setVisible(Unknown Source) Post edited by: junejava, at: 2008/02/19 20:04

Thanks, it works

The value is null . I checked in SQL command which using the parameter. I used mysql: show full process list to show the sql command sent from jasper server.

Hi, I have a report with has one parameter name 'REPORT_DATE' and default value is new Date(). User is able to change the parameter value so I have to create a control for the parameter. The problem is when I create a schedule job for the report, I want to use default value of the parameter. If I dont enter any value, the parameter value will be null. If I enter value of today, the parameter value will not be change for next running. What should I do?

Hi, I develop reports using crosstab feature on jaspersreport. They run against database having 50 millions rows, 40 GB. The report could not run on jasperserver. It always throws OutOfMemoryException java heap exception. I set java heap with the following commands export CATALINA_OPTS="-Xms1024m -Xmx2048m" export JAVA_OPTS="-Xmx2048m" But jasperserver still throw outofmemoryexception. My question are How to configure jasperserver to support the reports using crosstab and running against 50 million rows? Have Jaspersoft any commercial supports?

I want to show the list of generated files from particular schedule job using java. Is it possible ?