[jasperreports-questions] Jasper Report regarding a join

2006-05-01 Thread Manish Jain

Hello,
my DB schema is like

CLASS-A
id ( primary key ) , other properties

CLASS-B
rollno ( primary key ) , id ( foreign key CLASS-A.id ) , other attributes

I want to create a Jasper Report to display all elements of class B and 
and whenever the user clicks on id, the details to Class-A.id should show 
up. I have created the first Jasper ( to display Class-B) using iReports 
and it shows up fine in the iReports execution.


I am using Hibernate and struts in my app.

i feed this jasper using the following function :

   Session session = HibernateFactory.getSession();
   HibernateFactory.beginTransaction();

results = 
HibernateFactory.getSession().createCriteria(ClassB.class).setFetchMode(classa,FetchMode.JOIN).list();


   HibernateFactory.commitTransaction();
   HibernateFactory.closeSession();

when i try to feed this jasper using my java code, i get the error 
java.lang.NoSuchMethodException: Unknown property 'id' '.


Can any one help me out with this problem ...

thanks
Manish



--
- Imagination is more important than knowledge.
-- Albert Einstein


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions


[jasperreports-questions] Error in creating a jasper report

2006-03-29 Thread Manish Jain

Hi
I have created a jrxml and subsequently a jasper file using iReports. The 
report also comes nicely in the iReports Execute using active connection 
mode. However, when i try to incorporate this jasper file into my project 
( I am using Oracle JDev 9.0.5 on Windows XP ), i get the error as 
mentioned in the attached error file.


My Source code is also attached.

Pls help.
thanks
Manish


--
- Imagination is more important than knowledge.
-- Albert Einstein06/03/30 12:38:12 Hibernate: select payroll0_.payrollid as payrollid,
payroll0_.date as date9_, payroll0_.startday as startday9_,
payroll0_.endday as endday9_, payroll0_.hoursworked as hourswor5_9_,
payroll0_.grosspay as grosspay9_, payroll0_.deductions as deductions9_,
payroll0_.netpay as netpay9_, payroll0_.empid as empid9_ from payroll
payroll0_

06/03/30 12:38:15 java.lang.NoSuchMethodException: Unknown property
'empid'

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1175)

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772)

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:104)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:800)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:986)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:409)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:257)

06/03/30 12:38:15   at
com.cde.payroll.Common.actions.GenPayrollReportAction.execute(GenPayrollReportAction.java:68)

06/03/30 12:38:15   at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

06/03/30 12:38:15   at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

06/03/30 12:38:15   at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1485)

06/03/30 12:38:15   at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:509)

06/03/30 12:38:15   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

06/03/30 12:38:15   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

06/03/30 12:38:15   at
com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)

06/03/30 12:38:15   at
oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source)

06/03/30 12:38:15   at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:604)

06/03/30 12:38:15   at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)

06/03/30 12:38:15   at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)

06/03/30 12:38:15   at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)

06/03/30 12:38:15   at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)

06/03/30 12:38:15   at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)

06/03/30 12:38:15   at java.lang.Thread.run(Thread.java:534)

06/03/30 12:38:15 
NESTED BY :

06/03/30 12:38:15 java.lang.NoSuchMethodException: Unknown property
'empid'

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1175)

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:772)

06/03/30 12:38:15   at
org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:801)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:104)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:800)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:986)

06/03/30 12:38:15   at
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126)

06/03/30 12:38:15   at