JasperReportsIntegration 2.4.0 released
I have just released a new version of the JasperReportsIntegration toolkit. You can download version 2.4.0 here: http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/.
What are the main features?
It contains the following fixes or new features, the most
noteworthy certainly being the upgrade to the latest JasperReports
libraries 6.4.1.
- FIX: #3939 - Built-in report functions not working due to
missing library jasperreports-functions-$version.jar - FIX: #3940 - printerDiagnostics abort when supported
attribute values cannot be retrieved for category - FEATURE: #3707 - Upgrade to JasperReports 6.4.1
- FEATURE: #3941 - Support for timeZones (report parameter
REPORT_TIME_ZONE) - FEATURE: #3942 - test.jrxml - list of user objects removed -
timeZone displayed
In order to use the integration it is always best to look how the APEX test application implements the new features, also you can look at the package specification:
/** make a callout with utl_http to the j2ee container running the
* JasperReportsIntegration web application
* => return the results
*
* @param p_rep_name name of the report (needs a name.jasper file deployed on the server)
* @param p_rep_format report format, e.g. pdf, rtf, etc, see constants
* @param p_data_source data source name, needs to be configured in J2EE application
* @param p_out_filename filename if the file should be downloaded
* @param p_rep_locale report locale setting, e.g. de_DE or en_US
* @param p_rep_encoding encoding, e.g. UTF-8
* @param p_additional_params additional parameters, e.g.: p1=1&p2=2
* @param p_print_is_enabled shall the report be sent to the printer directly?
* @param p_print_printer_name name or substring of printer name
* @param p_print_media media used, either the paper size or the tray
* @param p_print_copies number of copies to be printed
* @param p_print_duplex duplex printing?
* @param p_print_collate sorting the print output?
* @param p_save_is_enabled shall the generated file be saved on the server?
* @param p_rep_time_zone "time zone" parameter for the execution of the report,
a list of valid entries can be found here:
https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
E.g.: Europe/Berlin, UCT, US/Central, US/Pacific,
Etc/Greenwich, Europe/London
* @param p_save_filename filename for the file to be saved on the server
*
*/
PROCEDURE show_report (
p_rep_name IN VARCHAR2 DEFAULT 'test',
p_rep_format IN VARCHAR2 DEFAULT c_rep_format_pdf,
p_data_source IN VARCHAR2 DEFAULT 'default',
p_out_filename IN VARCHAR2 DEFAULT NULL,
p_rep_locale in varchar2 default 'de_DE',
p_rep_encoding in varchar2 default 'UTF-8',
p_additional_params in varchar2 default null,
p_print_is_enabled in boolean default false,
p_print_printer_name in varchar2 default null,
p_print_media in varchar2 default null,
p_print_copies in number default 1,
p_print_duplex in boolean default false,
p_print_collate in boolean default false,
p_save_is_enabled in boolean default false,
p_save_filename in varchar2 default null,
p_rep_time_zone in varchar2 default null
);
or look at the J2EE application http://host:port/JasperReportsIntegration/ after you deployed it:
Please comment here if you find any issues or any other features you might need ... . If you find things that are broken please let me know quickly so that I can fix them.
Always trying to be better than yesterday,
~Dietmar.
Enhancement request
@param p_rep_format report format, e.g. pdf, rtf, etc, see constants
In iReport Designer, it allow Single Sheet XLS or Multiple Sheets XLS.
If you can fix p_rep_format to support both format, that would be great.
Hi Peter,
great suggestion, I will have a look at that.
Thanks,
~Dietmar.
Hi Peter,
please add this as a requirement here: https://github.com/daust/JasperReportsIntegration/issues.
I am currently working on 2.5.0 and this should not be too hard to include.
Cheers,
~Dietmar.
We are using this now for 4 years in a multi tenant production server.
it works very well never had any issues with the integration.
Now upgraded development to this version, that will go live in December
Hi Dennis,
excellent … I love to hear that.
Thanks,
~Dietmar.
Awesome work Dietmar – I have used the older version at several client sites along with APEX and it works brilliantly – great to be able to make use of the current version of Jasper.
Thanks 🙂
Hi Ben,
totally love your feedback! Keep building cool stuff with it.
Cheers,
~Dietmar.
P.S.: Anything you were struggling with in particular … that I could change to make it easier for people to use?
Hello Dietmar,
many, many thanks for your great work!!
It is a super solution, which is used by many users every day very gladly.
Thanks for your time :-).
Hi Armen,
glad to hear :).
Did “your” personal fix for the printerDiagnostics.jsp work?
Cheers,
~Dietmar.
Hello Dietmar,
not yet, I would gladly try to install the new version first in the TEST system. If I did not get it, I’ll get in touch with you.
Hello Dietmar,
not yet, I would gladly try to install the new version first in the TEST system. If I did not get it, I’ll get in touch with you.
Thanks, that’s very very great tools that I love it and have been waiting for long years ago
Cool :). Please test the QR-Codes and report your feedback.
Hello Dietmar
Thanks, that’s very very great tools
Hello Dietmar,
Thank you for this great integration utility.
The only feature we are missing is a plain text file export. It is usefull for simple data exchange between different systems and communication with low level hardware (uploading store scales with item name,price … information). Although CSV exporter can be used, some tweaking has to be done otherwise delimiters are added to resulting report.
In short, we would need a JasperReport text exporter.
Hi Simon,
yes, I will add this to the next release.
Thanks for the suggestion.
~Dietmar.
Thank you Dietmar,
Upon upgrade to new version (2.4.0) on server where my application is hosted (at Maxapex) I noticed that _repEncoding (for IBM852 charset) that worked on your previous version is not working any more.
Simon
Hi Simon,
really strange. I haven’t changed anything there. Could you please send me the debug / logging output, especially the URL that gets generated for the Tomcat?
Also, could you try to run the report using the encoding directly when accessing the J2EE application (don’t know whether you have access to it or not) .
Please send me also a simplified test case to my email address. (dietmar.aust at opal-consulting.de). And a screenshot of what the result should look like.
Thanks,
~Dietmar.
Hi Simon,
could you please also add the request for the new format here: https://github.com/daust/JasperReportsIntegration/issues
This way it is easier to track “my promises” ;).
Thanks,
~Dietmar.
Hi
We have been using your older version of product for many of our clients for more than 4 years.
And never we had issues .Will test your product new version and shall get back.
Currently based in Mumbai and Soon moving to germany
Thanks again.
Paul j
Awesome! Thanks for the feedback.
Hi Dietmar
We have been using v2.1.0 very successfully for a while now running in Glassfish, and I’m in the process of checking out 2.4.0 for an upgrade.
We are using jndi type datasource and came across a problem – which I have worked round – but I think it may trip others up.
First off (for Glassfish) the jndiPrefix is different to out-of-the-box prefix setting i.e. Glassfish required “jdbc/”
[application]
configFileVersion=2.3.0
#jndiPrefix=java:comp/env/jdbc/
jndiPrefix=jdbc/
For JNDI based resource the usual setting (working in previous version of JRI) is:
[datasource:myapp]
type=jndi
name=myapp
However this on it’s own gives an Exception on app restart
Caused by: java.lang.NullPointerException
at de.oc.integration.jasper.webapp.AppConfig.decryptPWD(Unknown Source)
at de.oc.integration.jasper.webapp.AppConfig.processConfigFile(Unknown Source)
at de.oc.integration.jasper.webapp.AppConfig.initialize(Unknown Source)
at de.oc.integration.jasper.webapp.AppServletContextListener.contextInitialized(Unknown Source)
at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:5396)
at com.sun.enterprise.web.WebModule.contextListenerStart(WebModule.java:743)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5965)
… 26 more
It looks to me like the optional encryption/decryption expects a password field specified in the datasource, which isn’t normally required for JNDI – my work-around is to include a “password” value in the jndi config e.g.
[datasource:myapp]
type=jndi
name=myapp
password=this-is-required-for-work-around
This allows the app server to restart and I can now get test connection and test report working.
Regards and thanks for the great software
David
Hi David,
thanks for the great workaround. Should hopefully no longer be required starting 2.5.0.1: https://github.com/daust/JasperReportsIntegration/issues/11
Thanks,
~Dietmar.
Hi Dietmar,
I have installed JasperReportsIntegration2.4 , that works fine.
I will encrypt the passwd in application.properties file with encryptPasswords.sh.
I’m facing below errors:
bin]$ ./encryptPasswords.sh /opt/oracle/JasperReportsIntegration2.4/conf/application.properties
Exception in thread “main” java.lang.NoClassDefFoundError: org/apache/commons/lang/exception/NestableException
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
How to resolve this issue?
Best regards, Bright
Hi Bright,
since more people are struggling with this and I don’t have the time for a regular release … please see here: http://s565579479.online.de/jasperreportsintegration-2-4-0-fix-for-encryptpassword
Cheers,
~Dietmar.
Hi Dietmar…Good day to you.
Am facing a strange issue off late…of getting no data in my Jasper Report even though it shows it correctly, both in iReport and JasperStudio. There are no errors either in the log files to indicate any issue.
My configuration is as follows:
Jasper Reports Integration v1.3 (we are having recurrent issues with version 2.4 of multiple classnofound exceptions)
Open JDK 1.8
APEX 5.1.2 (installed via OXAR).
Your test report works correctly and shows me the list of tables in my schema.
Any pointers would be greatly appreciated.
Regds and Kudos once again on producing such a brilliant utility,
Gaurav
…Just to add…I’m also using Tomcat 7
What classes are missing? Please post the error message / stack trace.
Hi Dietmar,
Great job!
We’re facing a problem when trying to connect to an Oracle PDB with connection secured by SSL. Our connection string need to be through TNSNAMES (which has all security specified inside) and url should be oci like:
url=jdbc:oracle:oci:@tnsmanes_entry
But when we try to connect it raises “java.lang.UnsatisfiedLinkError: no ocijdbc11 in java.library.path” how can we force JasperIngration to use ocijdbc12 instead of 11? Do you have any other experiences using SSL connections?
Any help will be appreciated!
Thanks for your time!
Hi,
We finally managed to resolve our issue!
Just to let you know how we did it:
1) Deploying JasperRerportsIntegration war file to a new Tomcat7 server installation (it comes with jetty by default)
2) Adding library ojdbc9.jar at $LD_LIBRARY_PATH and providing required permissions to file
3) Adding at tomcat7 profile load script the variable definition for LD_LIBRARY_PATH and TNS_ADMIN
Hope it helps!
Hi Josep,
many thinks, it will be fixed in 2.5.0.1: https://github.com/daust/JasperReportsIntegration/issues/13
Cheers,
~Dietmar.
Hi Dietmaraust
I installed Apex5.1 with ords 3 and jasperreportsintegraion 1.3.0.2 in windows environment. I am facing a strange problem. I am able to run the reports from browser (directly) but unable to run through apex application. I have run acl and looks like there is no acl issue. please advise.
Ata
Hi Ata,
sorry for the delay.
Please try the more current version here:
Future Releases will also be posted here: https://github.com/daust/JasperReportsIntegration
This is the right place to ask any questions about issues, etc.
Amazing work as usual 🙂
Thank you.
Thank you, well appreciated 🙂
Hi Dietmar,
Great work, can the JasperRI do a loop (print multiple pages) until it meets a certain critiria ?
Or can custom java logic be added?
Hi Socrates,
yes, you should be able to add custom java code. I made this work many years ago but don’t recall exactly.
possibly you could create a dynamic end condition in JasperReports. Best would be to ask the question in the JasperReports forums.
Cheers,
~Dietmar.
thaaank,BIG Dietmar
success integration
hi Dietmar
i have followed all the steps and installed but when i click on test report from tomcat it give me following error
Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
java.lang.RuntimeException: Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
de.oc.utils.Utils.throwRuntimeException(Unknown Source)
de.oc.db.ConnectionUtility.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.AppConfig.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Note The full stack trace of the root cause is available in the server logs.
and on sample app apex verify steps at check 6 and 7 showing follwoing error
Check 6: Is the data source “default” configured properly?
Error occured: ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1819 ORA-29269: HTTP server error 500 ORA-06512: at “SYS.HTTPURITYPE”, line 34
We couldn’t make a successful connection to http://localhost:8888/JasperReportsIntegration/test?_dataSource=default.
This can be ignored when the the parameter infoPageIsEnabled=false is set in the application.properties file. Then the J2EE server will respond with an 403 error code for security reasons.
It seems like the data source default is not configured properly.
Check 7: Does the test report return a result for the data source “default”?
Error occured: ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1819 ORA-29269: HTTP server error 500 ORA-06512: at “SYS.HTTPURITYPE”, line 34
We couldn’t make a successful connection to http://localhost:8888/JasperReportsIntegration/report?_dataSource=default.
It seems like the data source default is not configured properly.
waiting please do reply thanx
it seems like your entries in the application.properties file are wrong, the password or the connect information is wrong.
Hi Imaan,
did you ever figure this out?
Seems like the configuration in the application.properties file is not correct.
Is the environment variable OC_JASPER_CONFIG_HOME properly defined?
Also, the project is moved to https://github.com/daust/JasperReportsIntegration, there you can enter issues, there is forum to ask these questions and you download the new releases: https://github.com/daust/JasperReportsIntegration/releases
Best
~Dietmar.
parse error in line 2572/19: got “begin wwv_flow_api.set_region_column_width (
p_id=>26311502713976717 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_page_id=>4,
p_plug_column_width=>’valign=top’); end;”, expected WHITELISTED_EXECUTE_IMMEDIATE_EXPRESSION
import error
Well, here we are actually hitting a bug (I guess due to the older compatibility mode setting in the app) https://community.oracle.com/thread/4173070.
The workaround is simple, just install on the command line using sqlplus . You will probably want to change your environment in the session prior to installing the script:
SQL> DECLARE
2 l_workspace_id NUMBER;
3 BEGIN
4 l_workspace_id := APEX_UTIL.FIND_SECURITY_GROUP_ID (‘JRI_TEST’);
5 apex_application_install.set_workspace_id (l_workspace_id);
6 apex_application_install.generate_application_id;
7 apex_application_install.set_schema(‘JRI_TEST’);
8 END;
9 /
PL/SQL procedure successfully completed.
SQL> @f121_JasperReportsIntegration-Test_2.5.0.0.sql
For the next fix 2.5.0.1 I will make a version available which installs into 18.1 without problems.
Also, I have created an updated version for 2.4.0.0 which you can find here: https://github.com/daust/JasperReportsIntegration/blob/master/src/apex/APEX%2018.1/f121_JasperReportsIntegration-Test_2.4.0.0.sql
Works perfectly, thank you!
arse error in line 2572/19: got “begin wwv_flow_api.set_region_column_width (
p_id=>26311502713976717 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_page_id=>4,
p_plug_column_width=>’valign=top’); end;”, expected WHITELISTED_EXECUTE_IMMEDIATE_EXPRESSION
Hi Dietmar!
Thanks for your great job!
We’re facing a session issue, it seems sessions are no properly closed after generating PDF reports. Have you faced this problem earlier?
Thanks
No, not that I am aware of. You can open a ticket here: https://github.com/daust/JasperReportsIntegration/issues
and provide more details please.
Hi Josep,
this is fixed in 2.6.0, you can test it here: https://github.com/daust/JasperReportsIntegration/releases
This is a pre-release, please report any issue on github.
Thanks
~Dietma.r
Hi Dietmar…Good day to you.
My configuration is as follows:
Jasper Reports Integration v2.4
APEX 18.2
From time to time,
I’m facing below errors:
HTTP Status 500 – Internal Server Error
Type Exception Report
Message Could not connect via JDBC: IO Error: Got minus one from a read call, connect lapse 24 ms., Authentication lapse 0 ms.
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
java.lang.RuntimeException: Could not connect via JDBC: IO Error: Got minus one from a read call, connect lapse 24 ms., Authentication lapse 0 ms.
de.oc.utils.Utils.throwRuntimeException(Unknown Source)
de.oc.db.ConnectionUtility.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.AppConfig.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/9.0.8
Any help will be appreciated!
Thanks for your time!
Hhhhmm. Seems like network / firewall / proxy issues.
Hi Dietmaraust,
Great work !! You have helped a lot of people using Jasper Reports as an interface from Oracle Apex.
I am having an issue when adding values to p_save_is_enabled and p_save_filename parameters. The contenty type is changing from ‘text/html’ even though I am entering pdf. If I don’t enter the above 2 parameters then the content type is ‘application/pdf’ hence generating the pdf’s correctly.
Can you please help?
I cannot really reproduce this issue. Could you please elaborate more, ideally with screenshots? Enter here, please: https://github.com/daust/JasperReportsIntegration/issues
I’m having an issue where the font size is not being honored when you run it.
Also is it possible to store the reports files as apex static files?
Thanks!!!
>I’m having an issue where the font size is not being honored when you run it.
Please add a ticket here: https://github.com/daust/JasperReportsIntegration/issues
> Also is it possible to store the reports files as apex static files?
Not as of now … but there is already an enhancement request filed: https://github.com/daust/JasperReportsIntegration/issues/3
Hi Dietmar,
Thanks for the great library. I have one problem with barcode4j (barbecue works fine).
If i use barcode component then this error occur:
20-May-2019 07:30:23.207 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [ReportWrapper] in context with path [/JasperReportsIntegration] threw exception [Servlet execution threw an exception] with root cause
java.lang.ClassNotFoundException: org.apache.xml.serializer.TreeWalker
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1308)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1136)
at org.apache.xalan.processor.TransformerFactoryImpl.newTransformer(TransformerFactoryImpl.java:818)
at net.sf.jasperreports.components.barcode4j.BarcodeSVGImageProducer.createImage(BarcodeSVGImageProducer.java:74)
at net.sf.jasperreports.components.barcode4j.AbstractBarcodeEvaluator.evaluateBarcodeRenderable(AbstractBarcodeEvaluator.java:98)
at net.sf.jasperreports.components.barcode4j.AbstractBarcodeEvaluator.visitCode128(AbstractBarcodeEvaluator.java:205)
at net.sf.jasperreports.components.barcode4j.Code128Component.receive(Code128Component.java:40)
at net.sf.jasperreports.components.barcode4j.AbstractBarcodeEvaluator.evaluateBarcode(AbstractBarcodeEvaluator.java:85)
at net.sf.jasperreports.components.barcode4j.BarcodeFillComponent.evaluateBarcode(BarcodeFillComponent.java:83)
at net.sf.jasperreports.components.barcode4j.BarcodeFillComponent.evaluate(BarcodeFillComponent.java:70)
at net.sf.jasperreports.engine.fill.JRFillComponentElement.evaluate(JRFillComponentElement.java:110)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)
at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:500)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2022)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:582)
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:90)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:286)
at de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Configuration Info:
The current configuration is loaded from: /opt/jsreport/JasperReportsIntegration-2.4.0.0
Config-Directory: /opt/jsreport/JasperReportsIntegration-2.4.0.0/conf
Config-File: /opt/jsreport/JasperReportsIntegration-2.4.0.0/conf/application.properties
Reports-Directory: /opt/jsreport/JasperReportsIntegration-2.4.0.0/reports
Temp-Directory: /opt/tomcat/apache-tomcat-8.5.30/webapps/JasperReportsIntegration/report_tmp
Logs-Directory: /opt/jsreport/JasperReportsIntegration-2.4.0.0/logs
Java-Runtime-Version: 1.8.0_172
JasperReports-Version: 6.4.1
Reports without barcode4j lib worked good.
regards
J
Hi Jozef,
please post your questions in the forum for JasperReportsIntegration that I have created: https://gitq.com/daust/JasperReportsIntegration, so that also other people can jump in and help. My time is limited and I want as many people as possible to get value from this.
Please make sure to be as specific as possible:
Version of JasperReportsIntegration
Version of Tomcat or other application server
Version of operating system (for Tomcat)
Version of Oracle Database
Steps to reproduce the issue (including the error message)
Thank you,
~Dietmar.
Hi,
As suggested I raised a query in the forum but am still facing the same problem. The link is – https://gitq.com/daust/JasperReportsIntegration/topics/3/frequent-could-not-connect-via-jdbc-while-running-jasperreports
This problem does not happen always. First few reports will be fine and then subsequent reports will all throw exception 500. However, a restart of tomcat fixes this temporarily. As someone else also suggested above, it seems like connections / sessions are not being closed properly.
Hi Ajitabh,
I have replied on the github page, the new release 2.6.0 will fix this.
Best,
~Dietmar.
Dear Dietmar,
Appreciate your good deed!
I’m getting below error:
==================================================================================
Check 6: Is the data source “default” configured properly?
Error occured: ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1819 ORA-29269: HTTP server error 500 ORA-06512: at “SYS.HTTPURITYPE”, line 34
We couldn’t make a successful connection to http://localhost:8989/JasperReportsIntegration/test?_dataSource=default.
==================================================================================
My Environment:
Oracle 11gR2; Apex18.1; Ords18.4; JasperReportsIntegration.2.4.0
Your help in this regard is much appreciated. Thank you.
Hi Dietmar,
Is it possible to use your plugin to access jasper reports on an external jasper report server, instead of the internal j2ee app? We already have a jasper report server and we need to use the reports already there through Apex.
Regards,
Hi Cezar,
did you figure this out?
Well, it was never intended for that use case.
But perhaps you can just tweak the xlib_jasperreports package to use the url for the jasper reports server directly?`
Good luck
~Dietmar.
I have several installations working perfectly, now I have the need to connect to Oracle Autonomus Transaction but I can’t get it through the secure connection you can help me
Hi Josue,
did you figure this out?
I have no practical experience with it but you could post it in the forum: https://gitq.com/daust/JasperReportsIntegration
Also, it is best to ask questions and report issues on the github page: https://github.com/daust/JasperReportsIntegration
Cheers
~Dietmar.
Hi Dietmar
I installed JaspereportsIntegration 2.4.0 with tomcat 9. homepage is working fine. however data source is not connecting. I am using Oracle 19c database.
it gives this error, when I run the TEST report.
HTTP Status 500 – Internal Server Error
Type Exception Report
Message Could not connect via JDBC: ORA-28040: No matching authentication protocol
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
java.lang.RuntimeException: Could not connect via JDBC: ORA-28040: No matching authentication protocol
de.oc.utils.Utils.throwRuntimeException(Unknown Source)
de.oc.db.ConnectionUtility.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.AppConfig.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/9.0.30
++++++++++++++++++++++++++++++++++++++
Oracle told me this is due to high security feature in 19 c and have asked to add below properties in application side:
props.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL, “REQUIRED”);
props.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES, “( AES256 )”);
props.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL, “REQUIRED”);
props.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES, “( SHA1 )”);
but I dont know where do we need to set it in Jasper side and how ?
can you enlighten me.
thank you
Charandeep
Hi Charandeep,
this was an issue with an outdated jdbc library. A newer version is available here: https://github.com/daust/JasperReportsIntegration/releases.
This is a pre-release, please report any issues on the github page.
Thanks
~Dietmar.
Hi Dieter,
Could please help configuring using an oracle pluggable database: https://community.oracle.com/message/15578597 ?
Thanks a lot!
Jose.
Hi Jose,
as I can see in the forum post you have already found a solution. Great. Version 2.6.0 and later will include the latest jdbc libraries, see: https://github.com/daust/JasperReportsIntegration/releases
This is a pre-release … please test and report any issues on github. Thanks.
Hi Dietmar,
I have problem with Cyrillic printing
Using Oracle Apex 18 and TibcoJaspersoft Studio…
When print from studio everything works fine,
when print from apex, it returns me report withOUT cyrllic or with something like this : Гоквић (all letters one over other ) *all letters are there but one over other
Trying to use Tahoma for example….
Font is instaled…imported to JasperSoft studio, copied to folder where jrxml file is, copied to JDK_HOME and JRE_HOME/fonts….
Any solution?
Hi Rajko,
did you figure it out?
Also, the project is moved to https://github.com/daust/JasperReportsIntegration, there you can enter issues, there is forum to ask these questions and you download the new releases: https://github.com/daust/JasperReportsIntegration/releases
Please enter the issue on github, we can take it from there.
Best
~Dietmar.
Dear Sir,
i have this error when make a test report on tomcat and inform you that my windows is 10-64bit and database 12c.
HTTP Status 500 – Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
type Exception report
message Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
description The server encountered an internal error that prevented it from fulfilling this request.
exception
java.lang.RuntimeException: Could not connect via JDBC: ORA-01017: invalid username/password; logon denied
de.oc.utils.Utils.throwRuntimeException(Unknown Source)
de.oc.db.ConnectionUtility.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.AppConfig.getConnection(Unknown Source)
de.oc.integration.jasper.webapp.ReportWrapper.service(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/8.0.26 logs.
Apache Tomcat/8.0.26
Hi Khalid,
did you figure it out?
Did you check the username and password in the application.properties file, is that actually the correct one?
Also, the project is moved to https://github.com/daust/JasperReportsIntegration, there you can enter issues, there is forum to ask these questions and you download the new releases: https://github.com/daust/JasperReportsIntegration/releases
If that is an issue connecting to a newer Oracle version, it might be an issue with the included jdbc drivers. I have just (pre-) released a new version 2.6.0 which includes newer versions. You might want to check it out.
Best
~Dietmar.
Exception
java.lang.NullPointerException
de.oc.integration.jasper.webapp.AppConfiguration.(AppConfiguration.java:61)
de.oc.integration.jasper.webapp.AppContext.loadApplicationProperties(AppContext.java:150)
de.oc.integration.jasper.webapp.ReportWrapper.service(ReportWrapper.java:152)
javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Tomcat 9
Database 11xe
java 1_8_045 please assist
Hi Rajeev,
did you figure it out? It could be that the configuration file application.properties could not be found. Is the environment variable OC_JASPER_CONFIG_HOME properly defined?
Also, the project is moved to https://github.com/daust/JasperReportsIntegration, there you can enter issues, there is forum to ask these questions and you download the new releases: https://github.com/daust/JasperReportsIntegration/releases
Best
~Dietmar.