silenco

Hi again, it's not that much work as is seemed to be in the beginnig... As JasperServer offers a WebService Interface it's quite easy to create a component in JasperETL / Talend. :) The first Test-Run was succesful. If interested you can see below the code for calling the WS. Cheers, Simon -- www.kybeidos.de KYBEIDOS Gesellschaft für Systeme zur Unternehmenssteuerung mbH Code:[...]com.jaspersoft.jasperserver.irplugin.JServer jserver = new com.jaspersoft.jasperserver.irplugin.JServer();jserver.setUrl("[YOUR JS]");jserver.setUsername("[YOUT_USER]");jserver.setPassword("[YOUT_PW]");com.jaspersoft.jasperserver.irplugin.wsclient.WSClient wsclnt = new com.jaspersoft.jasperserver.irplugin.wsclient.WSClient(jserver);com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.ResourceDescriptor rdes = new com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.ResourceDescriptor();rdes.setUriString(<%=[A_PATH_TO_A_REPORTUNIT]%>);java.util.List args_<%=cid %> = new java.util.ArrayList();args_<%=cid %>.add(new com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.Argument(com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.Argument.RUN_OUTPUT_FORMAT, com.jaspersoft.jasperserver.api.metadata.xml.domain.impl.Argument.RUN_OUTPUT_FORMAT_PDF));java.util.Map attachments_<%=cid %> = wsclnt.runReport(rdes, parameter_<%=cid %>, args_<%=cid %>);com.jaspersoft.jasperserver.irplugin.wsclient.FileContent content_<%=cid %> = null;if (attachments_<%=cid %> != null && !attachments_<%=cid %>.isEmpty()) { Object key = attachments_<%=cid %>.keySet().iterator().next(); content_<%=cid %> = (com.jaspersoft.jasperserver.irplugin.wsclient.FileContent) attachments_<%=cid %>.get(key); java.io.FileOutputStream fos; fos = new java.io.FileOutputStream(new java.io.File(<%=destinationDirectory%> + java.io.File.separator + <%=outFileName%>)); fos.write(content_<%=cid %>.getData()); fos.close();}

Hi there, I'm trying to create a Component for Talend / Jasper ETL that is able to execute reports (handle in-/output), which are defined already in JasperServer. For our purpose the existent components tJasperOutput are not usefull at all ... ... the reason for that is, that we are planning to automate (Mass-) E-Mailing with attached Reports .... and the Scheduler in JasperServer is not capable of doing so. Why not using Talend instead of programming your own stuff? So, just in case if somebody had the idea already... is there perhaps a connection between those two products of yours already, which can be used? Perhaps in the professional (not community) products? It's quite a lot of work ... ;) Thanks! Regards, Simon I. Landes -- www.kybeidos.de KYBEIDOS Gesellschaft für Systeme zur Unternehmenssteuerung mbH Post Edited by Simon Landes at 02/16/09 21:04

Hi Lucian, many thanks for your reply! It worked perfectly well. Thanks a lot ! Cheers, Simon

Bug Tracker: http://jasperforge.org/tracker/index.php?func=detail&aid=3487&group_id=112&atid=378&action=browse Post Edited by Simon Landes at 01/23/09 10:44

Hi Gabriel, thanks a lot for your quick reply! It's good having the certainty that I'm not crazy ... spent a whole day on that! I'm going to open a bug report for that issue. Jasper-Team, is there parhaps any known solution for that already? Thanks. Simon

Hi! I have a problem with the smtp authentication for JasperServer Version 3.0.0. and 3.1.0. I've tried the mail configuration for both versions (3.0.0. and 3.1.0)... each of them with two different mailserver/accounts. The error is always the same - "authentication required". (see below) Our Server Administrator ensured me that there had been no attempt for any authentication. Entering a password in the config file (V3.1.0 js.quartz.properties // V3.0.0 js.mail.properties) or leaving it blank won't make a difference. All other settings in the config file are applied correctly after a restart. Does anyone have any idea? Can anybody approve, that the smtp authentication in Version V 3.x is working at all? Thanks very much! Cheers, simon Code: Post Edited by Simon Landes at 01/22/09 14:55

Hi Yupa, thanks a lot for your posting. It helped! :) Cheers, simon

Hi! I'm facing the same error... does anyone have found any solution for that, yet? :dry: regards simon

Hi martyn, thanks for your reply! Indeed my report application has a spring based & mda developed architecture. With iReport you can define a Spring Datasource, based on your "applicationContext.xml". That feature is very nice...as you can work with your beans... but unfortunately it's not so easy to get that environment running with the JasperServer, respectivley i didn't get it working at all. ... I thought about developing my own webfrontend with services executing the reports, too. ... but a few points made me use JasperServer anyway: -> reusable, typesafe input controls, which are defined in the webapp and loosely bound to the reports is quite a nice feature! -> the analysis function & the creation of drill down tables is a very nice feature too, which I am planning to use in future. -> Yes, there are still many problems with the JasperServer .. BUT: It's only the version 1.2.0 ... I think there will be a lot development concerning the server in future!! -> The Scheduler is also nice, espacially for reports, that are often requested and only hourly updated... ... for the beginning (13 Reports) I will use JDBC with SQL Queries and little logic in the queries, as it is the ETL process that has to cover that ... later on it could easily be adopted into a Spring architecture ... I think for a quick setup and a few reports, it's perhaps better to develop up your own application...but in the long run, and escepially when your are planning to offer a lot of reports ...etc. your are doing very good with JasperServer. regards, simon

Hi again! ... I solved it... more or less: The problem are the queries, which are defined NOT inside the jrmxl ... defining the queries in the JasperServer and referencing them in a Report Unit causes the NULL in the query... defining them inside the jrxml it works. That's a pity because I would like to define one jrxml and different Report Units in the JasperServer with different queries... respectively different jrxml with the same query, but another view (jrxml). I really liked the way defining all parts external in order to reused it... Do you have an idea how to do this? Is that behaviour purposely or is it a bug? Many Thanks, Simon

Hi Lucian, many thanks for your reply. The Log now shows the SQL Query: Code:15:06:05,833 DEBUG JRJdbcQueryExecuter,http-8080-Processor23:135 - SQL query string: select * from r__registration where null 15:06:05,849 ERROR EngineServiceImpl,http-8080-Processor23:572 - Error while filling report net.sf.jasperreports.engine.JRException: Error executing SQL statement for : registration_jrxml_1173189673239 ... for the defined Query: Code:[code] select * from registration where $P!{WHERE} regards, simon

Hi all, I've got a Problem building a dynamic query with JasperServer ... don't know if it's a bug?! I build the Query with some logic encapsulated in dummy parameters: Query / SQL: Code:select * from registration where $P!{WHERE} WHERE Parameter (default value expression): Code:[code]($P{INPUT_DATE_FROM} != null?" and reg_date >= '"+$P{INPUT_DATE_FROM}+"' ":""«») + ($P{INPUT_DATE_THROUGH} != null?" and reg_date <= '"+$P{INPUT_DATE_THROUGH}+"' ":""«») Running the Report in IReport, everything works fine. Uploading this to the JasperServer following error occure: Code:[code]... Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 4 ... ... which means $P!{WHERE} returns NULL on the jasper server... Is anyone familiar with that problem or does anyone have found a workaround for that, yet? I searched the forum up and down ... but I didn't find anything similar ... any help is highly appreciated ! Thanks, Simon iReport: 1.3.1 jasperServer: 1.2.0 Post edited by: silenco, at: 2007/03/02 19:41

Hi Nagendra, ... I've got the same problem. ... changing the query in a scriptlet seems not possible, as you only can set variables from a scriptlet, not parameters ... and in the query you can access only parameters ... have you found another solution, yet? regards, simon