shrije

I get the following issue in creating hibernate connection using spring in iReport 3.7.0 Error creating bean with name 'entityManagerFactory' defined in class path resource [analysis-server-dao-spring-config.xml]: Cannot create inner bean 'org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter#19c21c1' of type [org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter] while setting bean property 'jpaVendorAdapter'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter#19c21c1' defined in class path resource [analysis-server-dao-spring-config.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter]: Constructor threw exception; nested exception is java.lang.NoClassDefFoundError: org/hibernate/ejb/HibernatePersistence The spring file is being tested successfully and used in my test cases and applications. The class is already added in classpath through jar file like other jar files. I am using hibernate version 3.4.0 GA and spring version 2.5.5.. I tried the following to fix the issue 1. Restarted iReport after closing the application. 2. Exploded the jar file containing the class and added the same folder in the class path. But in vain. Please help me. Please find the attached spring file code. I have replaced the company name and component name from the file with "company" and "component". Code:<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <value>component.properties</value> </property> <property name="placeholderPrefix" value="$DB{" /> <property name="ignoreUnresolvablePlaceholders" value="true" /> </bean> <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"> <property name="persistenceUnitName" value="component" /> <property name="dataSource" ref="componentDataSource" /> <property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml" /> <property name="jpaVendorAdapter"> <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"> <property name="database" value="$DB{db.database.type}" /> <property name="showSql" value="true" /> <property name="generateDdl" value="true" /> </bean> </property> </bean> <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager"> <property name="entityManagerFactory" ref="entityManagerFactory" /> <property name="dataSource" ref="componentDataSource" /> </bean> <tx:annotation-driven transaction-manager="transactionManager" /> <bean id="componentDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="$DB{db.connection.driver_class}" /> <property name="jdbcUrl" value="$DB{db.connection.url}" /> <property name="user" value="$DB{db.connection.username}" /> <property name="password" value="$DB{db.connection.password}" /> </bean> <bean id="componentProgressDao" class="com.company.iii.component.dao.impl.componentProgressDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="componentrequestDao" class="com.company.iii.component.dao.impl.componentrequestDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="componentResultDao" class="com.company.iii.component.dao.impl.componentResultDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="aggregateRequestDao" class="com.company.iii.component.dao.impl.AggregateRequestDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="parameterGroupDao" class="com.company.iii.component.dao.impl.ParameterGroupDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="parameterDao" class="com.company.iii.component.dao.impl.ParameterDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="componentAlgorithmDao" class="com.company.iii.component.dao.impl.componentAlgorithmDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="markerDao" class="com.company.iii.component.dao.impl.MarkerDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="parameterDefinitionDao" class="com.company.iii.component.dao.impl.ParameterDefinitionDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean> <bean id="parameterDefinitionGroupDao" class="com.company.iii.component.dao.impl.ParameterDefinitionGroupDaoEjb3Impl"> <property name="entityManagerFactory" ref="entityManagerFactory" /> </bean></beans>

Try escaping the character & and othetr characters like #, @ with a \. For example replace '&' with '\&'.

This works in all the report bands but not on the title band. I need on the title band too.

Create a new band and set split allowed to false. Put the text field on this. Then u will get what you want.

Please look at the demo sample in Fonts folder. It is not that it does not work at all but it is quite a menacing issue. We have using XLS reports extensively

Please check if your XML encoding is UTF-8.

I think this is the limitation with the XLS reports. Even the samples provided with the JR source code have this issue. XLS is not a standard reporting tool though it can used to get reports with numerical and statistical data for later analysis.

Please download the source code for jasperreports and look at the sample program under folder jasperreports-3.0.0demosamplestableofcontents. It gives an example of table of contents.

Project Admins, Please let us know the right direction for this approach. We are stuck midway. Thanks in advance. Shrirang

Even "alterdesign" speaks about the implementation we need and works for us best. Since we are doing it for the first time we would like a confirmation on the technique.

For a project using jasper reports 2.0.2, we intend to use the jasper API to dynamically change the report contents Contents could be the following:- 1. Fonts properties like size, bold, italic on the report. 2. Re-ordering the images on the detail band on the report. We have gone through the samples in the demo folder "noxmldesign" and "noreport" which indicates that jasper reports can be changed dynamically. We would like to know if this is the best way to change the reports on the fly.

I am using Jasper reports 3.0.0 and getting the following error. What could be reason. The report runs fine though. 2008-12-11 14:29:18,734 INFO [sTDOUT] 2008-12-11 14:29:18,734 1748643 ERROR [net.sf.jasperreports.engine.fill.JRThreadSubreportRunner] (fieldResult subreport filler:) Fill 14572403: exception java.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:474) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.suspend(JRThreadSubreportRunner.java:189) at net.sf.jasperreports.engine.fill.JRBaseFiller.suspendSubreportRunner(JRBaseFiller.java:1999) at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1219) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1294) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1319) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1396) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:591) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:524) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:253) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:536) 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)2008-12-11 14:29:20,624 INFO [sTDOUT] 2008-12-11 14:29:20,624 1750533 ERROR [net.sf.jasperreports.engine.fill.JRThreadSubreportRunner] (resultTypeValue subreport filler:) Fill 28443632: exceptionjava.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:474) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.suspend(JRThreadSubreportRunner.java:189) at net.sf.jasperreports.engine.fill.JRBaseFiller.suspendSubreportRunner(JRBaseFiller.java:1999) at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1219) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnHeader(JRVerticalFiller.java:495) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:251) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:536) 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)2008-12-11 14:29:20,624 INFO [sTDOUT] 2008-12-11 14:29:20,624 1750533 ERROR [net.sf.jasperreports.engine.fill.JRThreadSubreportRunner] (imageAndResult subreport filler:) Fill 2131330: exceptionjava.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:474) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.suspend(JRThreadSubreportRunner.java:189) at net.sf.jasperreports.engine.fill.JRBaseFiller.suspendSubreportRunner(JRBaseFiller.java:1999) at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1219) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1294) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1319) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:578) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:524) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:253) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:536) 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)2008-12-11 14:30:41,673 DEBUG [com.arjuna.ats.arjuna.logging.arjLogger] Periodic recovery - first pass <Thu, 11 Dec 2008 14:30:41>

Does jasper read the font files from the WindowsFonts folder or they are part of the classpath. ? If i have to include additional fonts how do i do this ?

Not sure if this is an issue but your jrxml shows no value in the dataset tag too. May it needs some dataset expression.

This would not be possible right now and is also not desirable. One can change the look of the report by changing the jasper files on the fly. so they cannot be part of the jar. So in your expression jar:file: will not work. Whereas just the location of the jasper will work. It looks for the file as the url location first and then as the file location later. If it finds it, it will load it.

Download the latest jasper reports source code. You will find it in the demo folder. There are several examples. TOC is one of them.

I had this issue just yesterday. This is the way i fixed it. The issue occurs if we have multiple iReports installed on your machine. Obviously if one of them is prior to 2.0.3 as Lucian has suggested. Steps to get away with the problem:- 1. Delete the folder ".iReport" from the file system location Desktop<UserName>. 2. Also delete the folder "flexdock" from the file system location Desktop<UserName>. where <UserName> is the user name displayed as per your login.

This kind of issues can appear if the jasperreport version used in iREport version is different than jasperreports used in java application. Please verify the same.

You have use the columnar report. Go to report properties and select 'More' tab. Select the print order as horizontal. Select as many columns you need on your report in the columns tab. Remember you cant have indefinite columns since it is limited to the page width you select. Let me know how it goes. The columns boundaries will be faintly visible on the report layout once you do this. The race 'Men' or 'Women' will be part of single columns.

Project Admins What are the major differences between iReport 3.0.0 and iReport 3.1.2 apart from that iReport 3.1.2 is for NetBeans platform. Can i assume that this is the only difference and rest of the bug fixes, features remain the same.

Add a manual page break and use the REcord_Count to enable the break every 15 records

Does iReport have maven repository from where i can download the latest versions.

if you download the JR source code. It has a demo folder with all the samples. They are good enough to tell how jasper reports works and is supposed to be used.

Please look at the sample TableOfContents in the JR Distribution. You will get the answer to all your questions.

This is a major issue which we can see the demo samples too that go along with JR Distribution. I have verified this. The issue is that POI api used does not change the height of the cells.