robert.groll

Hello, thank you for your help. The clues were good. The wrong scriptlet has made obstacles. Solved!!!

Thank you Markjdsmith.

Hello, another additive and maybe solving question. Can it be that I've to restart the Tomcat or the Jasperserver-Application to be able to use these Jars(in the Report Unit or the "/jasperserver/WEB-INF/lib"-folder? Have I to restart Jasperserver or the Apache Tomcat? Thank you in advance. With kind regards. Robert

Hello, I tried the /jasperserver/WEB-INF/lib folder and add the .jar to the Report Unit. But it still don't word. What can be wrong? Can the problem be that I habe already one .jar with the same Class-Name? And Jars with the same class can't word together on Jasperserver? But locally the Jars work together. Please can anybody help? Thank you in advance.

Hello, thank you for your answer and sorry for the late reply. I've attached the .java-file. Refer to the 3 suggestion: I've already tried to add the jar to the report unit. In the jasperserver I also see the jar as a ressource in the report unit under the name "dynamicdate". But it still don't work. Refer to suggestion 1 and 2: If I have entrance to the directories I'll try it. Thank you again. Robert

Hello, I'd like to get help for using custom functions on jasperserserver, too. Ich added the .jar to my Project with the Build Path Dialog within JasperStudio. Locally the method where used. But If I save the .jrxml on the server and execute it on the server with japsersoft studio, the error message says the method is undefined. I've already tried to ad the .jar to the Report-folder on the jasperserver but it also don't work. I've tried to set Properties in the Properties of the project and in the Preferences of JasperStudio but nothing had helped. If I try it with a scriptlet I can't use the scriptlet in the crosstab. Why Jasper don't publish the .jar to the report by saving it on the jasperserver. Ich hope someone can help. Thank you in advance. With kind regards Robert

!Solved! Thank you for your help. But, sorry too that you can't help. with kind regards

Sorry, but I think it doesn't word in that way. In that way I pass these Parameters(truststore-Data, keystore-Data) to the Database, but there has to be possibility to talk to the MySQL-Server. Previously there has to be a ssh-Tunnel, before I can pass Parameters to the MySQL-Server. Are there maybe other ideas. Thank you for more help in advance. Kind Regards

Please, see my Scriptlet-Class too.

Hello, thank you for your answer. But is there not a difference between ssh and ssl? kind regards

Hello everyone, my question is how can i make a tcp/ip over ssh connection to use my mysql-Database. I tried it with a Scriptet. The Scriptlet uses the command line with plink.exe(this is a command line version of PUTTY) and are right implemented. But the method beforeReportInit() does not start before the report starts the MySQL DataAdapter. I ask me, why? Can I execute Java code before connecting to the DataAdapter? I'm looking forward to get a helpful answer. Thanks in advance for your help. Robert