martinst

Is there some timeline in connection to the Roadmap (http://jasperforge.org/projects/jasperserver/tracker/roadmap)? When can we, for exemple, expect to see the extremely anticipated feature - 0003506: [Feature Requests] Custom output destinations for scheduled reports - acknowledged. implemented? It currently has 88 votes!

I installed JasperServer 3.7.0 with bundled Tomcat and MySQL. I then logged in the server, right-clicked the Accounts Report and selected "Run in background" to be saved in the "ContentFiles" folder. This resulted in the following error: 2010-06-10 09:28:36,858 ERROR ReportExecutionJob,quartzScheduler_Worker-1:308 - An error occurred while saving AllAccounts.pdf into the repository. com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]; SQL [insert into JIContentResource (data, file_type, id) values (?, ?, ?)]; Packet for query is too large (1267304 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1267304 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) The parameter in jasperserver-ce-3.7.0/mysql/my.ini is set to max_allowed_packet = 32M I changed it to max_allowed_packet = 1G but the problem remains. Perhaps MySQL is using some other configuration file, but this shoulnd't be the case since I use the bundled MySQL, should it? Post Edited by martinst at 06/10/2010 08:19

Just wanted to say that I have the exact same question(s). :)

That indeed did the trick. Thanks!!! Post Edited by martinst at 06/10/2010 06:37

I've installed JasperServer 3.7.0 and tried to set it up using oracle as a configuration database following these instructions: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994&page=1 It seems that the connection to the oracle db works well, but I do get the exception below. Does anyone have any suggestions? DB connection from data source 'springNonTxDataSource.quartzScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected ) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected )]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1043) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1185) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:575) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.JSSchedulerFactoryBean.createScheduler(JSSchedulerFactoryBean.java:66) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:451) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) ... 132 more

I would like to be able to perform logging from iReport to see what SQL queries are actually executed (I create them dynamically using parameters). Is this possible?