craig1980
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by craig1980
-
-
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_06
- Tomcat 5.5.16
- Spring 2.5.1
- Hibernate 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.4
- JVM 1.5_06
- tomcat 5.5.16
- Spring 2.5.1
- hibernate 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 morePost 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.1
- Tiles 2.0.5
- JasperReports 2.0.4
- Struts-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
Question on JavaBean datasource
in Products
Posted
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?