craig1980

Hi. I'm in this situation: I have a hibernate object; i create it by doing some queries on DB in my application; now i'ld love to use this object as javabean datasource in my jasper; my hibernate object src code is: public class Struttura extends GenericEntity { private static final long serialVersionUID = -1418031403712107510L; private int idStruttura; private Set servizi = new HashSet(); private Set persone= new HashSet(); private Set recapiti= new HashSet(); private Set indirizzi= new HashSet(); private String organo; public Serializable getKey() { return new Integer(getIdStruttura()); } public int getIdStruttura() { return idStruttura; } public void setIdStruttura(int idStruttura) { this.idStruttura = idStruttura; } public Set getIndirizzi() { return indirizzi; } public void setIndirizzi(Set indirizzi) { this.indirizzi = indirizzi; } public String getOrgano() { return organo; } public void setOrgano(String organo) { this.organo = organo; } public Set getPersone() { return persone; } public void setPersone(Set persone) { this.persone = persone; } public Set getRecapiti() { return recapiti; } public void setRecapiti(Set recapiti) { this.recapiti = recapiti; } public Set getServizi() { return servizi; } public void setServizi(Set servizi) { this.servizi = servizi; } public void addPersona( Persona p ){ validateEntity(p, "Passato un oggetto persona null; impossibile proseguire"); if( !this.persone.contains(p) ){ p.addStruttura(this); persone.add(p); } } public void addServizio(Servizio s){ validateEntity(s, "Passato un servizio null; impossibile prosegure"); if( !this.servizi.contains(s) ){ s.setStruttura(this); servizi.add(s); } } public void addRecapito( Recapito r ){ validateEntity(r, "Passato un oggetto recapito null; impossibile proseguire"); if( !recapiti.contains® ){ r.setStruttura(this); recapiti.add®; } } public void addIndirizzo( Indirizzo i ){ validateEntity(i, "Passato un indirizzo null; impossibile proseguire"); if( !indirizzi.contains(i) ){ i.setStruttura(this); indirizzi.add(i); } } public String toString(){ StringBuffer sb = new StringBuffer(); sb.append("Entità: "+ this.getClass().getName()+". "); sb.append("Chiave: "+getKey()+". "); sb.append("Descrizione: "+getDescrizione()+". "); return sb.toString(); } As you can se in my bean i have several Set properties; how can i read them in my jasper file?

Hi. I'm new to IReport and Jasper reports. I'ld love to use a datasource by using my spring-hibernate file. I have this environment: JVM 1.4.2 IRport 3.0.0 Spring 2.0.6 Hibernate 3.2.5 I have tried to create a Spring Hibernate Datasource; first of all i have replaced the spring and hibernate jars in IReport with new ones; then i have added in classpath a Jar with my spring bens definition file, my hbm files and my classes files. After some test IRport tells me it successufully create datasource but then i can't see hibernate bean in my Query editor when i try to use HQL Can anyone give me some sample on how to setup correctly this datasource? Thnx Angelo

Hi. This is my environment: JVM 1.5_06Tomcat 5.5.16Spring 2.5.1Hibernate 3.2.5[/ul] I'm using spring support for Jasper. I'm getting out of memory errors; by reading the article on this link: http://www.jasperforge.org/index.php?option=com_content&task=view&id=250&Itemid=5 i understand that i'ld use the JRdatasource (now i use the JDBCdatasoruce); i'm usign hibernate and i'ld love to use JRHibernateAbstractDataSource or JRHibernateIterateDataSource. Can anybody suggest me how to use it? Is there any sample? Thanx to all.

Hi. I have this environment: Jasper report version 2.0.4JVM 1.5_06tomcat 5.5.16Spring 2.5.1hibernate 3.2.5[/ul] In my project i have a report in excel format; in this report in one file there are 2 sheets; when i want to use this report i get an error; the error is: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : REPORT_CALCOLO_SEGGI at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) 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.JRBaseFiller.fill(JRBaseFiller.java:795) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at it.eng.idep.web.view.base.report.AbstractIdepReportView.renderReport(AbstractIdepReportView.java:131) at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.renderMergedOutputModel(AbstractJasperReportsView.java:578) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:251) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1160) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:901) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at it.eng.idep.web.filter.CheckDestinationFilter.doFilter(CheckDestinationFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Out of memory (Needed 1048548 bytes) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2977) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1300) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1435) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 35 more Post edited by: craig1980, at: 2008/06/09 15:49 Post edited by: craig1980, at: 2008/06/13 11:28

HI. We are using Jasper Report 2.0.4 for creating reports. We need to use a well determinated stylsheet above all for HTML view; can i use a my own css for rendering HTML reports according to my needs (or better my boss needs)? Or can i set a class in the rendered report? For example how can i have an HTML Report like this one: Code: <html> . . . . <table class="myTableCssClass"> <tr> <td class="myTdCssClass"> </td> </tr> <tr> <td> <span class="mySpanCssClass"> </span> </td> </td> </table> . . . </html> What we need absolutly is to set css properties for tables and columns. Thanks to all. Regards, Angelo.

Hi all. I have searched everywhere but i have found no solution. I'm developing a project with these techonlogies: Spring 2.5.1Tiles 2.0.5JasperReports 2.0.4Struts-menu 2.4.3[/ul] I'ld love to use jasperreport by using tiles; can anyone show me a little example about how to integrate tiels+spring+jasperreports? Thanx to all. Angelo Post edited by: craig1980, at: 2008/03/19 18:03