Dietmar Aust

daust ·

Wonderful!!!

Thank you for raising it and improving the project. I will update the documentation to clarify the usage on Weblogic. I typically use my built-in connection pool through the application.properties file only.

Thanks again
~Dietmar.

I could make it work on my system.
I had to change this setting in the application.properties file though:

jndiPrefix=

Give it a try, Dietmar.

Which is your version of JasperReportsIntegration, 2.10.1?
Which operating system is Weblogic running on ... Windows?

Thank you.

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.19.1.final using JasperReports Library version 6.19.1-867c00bf88cd4d784d404379d6c05e1b419e8a4c  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports...

The other issue I cannot reproduce either.
I created a simple test case since you didn't provide one ... again.

This one worked right off the bat without me doing anything ... but copying the Bar... to the windows machine.I used jri-2.10.1-jasper-6.20.0

I could make it work. I created a simple test case on my Macbook.

• Downloaded the font from here: https://www.dafont.com/code-128.font
• Created a simple test report

• Followed the instructions for font extensions here: https://com...

Well, then this seems to be a font issue ... not related to the two different barcode components that you can use in JasperReports.
Busy today ... might take a bit to build a testcase and try it.
Will get back to you.

ok, please provide a simplified test report, then I can have a look.

Hi, version 2.4.0 is really old. You have to make sure to build reports using a version of jasperstudio that supports the old engine (JasperReports 6.4.1).

When you create a simple test report I can give it a try ... but I will try with the latest relea...

Ok, you are taking a different approach and not using the backend with pl/sql but rather Javascript from the frontend. Please be aware of the security implications because every user can access your datasource now.

Anyhow. First, you need to make sure tha...

This is a basic ssl communication issue when dealing with Oracle. This is "below" the JasperReportsIntegration and even APEX.

Here is a simple check to make sure the SSL wallet is referenced correctly: https://github.com/daust/JasperReportsIntegration#run...

Great!

For the ACLs you have a sample script to allow them.
In the documentation you will find instructions for running it with SSL: https://github.com/daust/JasperReportsIntegration#accessing-jasperreportsintegration-through-ssl

Generally speaking, sin...

Hi,

please use the latest release and make the following change in the file xlib_http.pks in line 39:

HTTP_VERSION_1_1 constant VARCHAR2(64) := 'HTTP/1.1'; -- #123

=>

HTTP_VERSION_1_1 VARCHAR2(64) := 'HTTP/1.1'; -- #123

So, basically, when you...

I will have a look later today. Still busy. First I need to set up an environment so that I can test it ... on an older release. Please bear with me. Thanks. Want to make sure, it works flawlessly this time.

Release 2.4 is very old.

Did you run the script: sys_install_acl_12_and_above.sql ?

You need to use the exact same configuration as what you want to call via the url. For example, when you want to access then you should configure the ACLs to allow ,...

I don't mind at all ... keep 'em coming :).

Thank you.

You are absolutely right ... will have to revisit it. For the most part this is still valid, I don't use any specific higher-version features.

Thank you again!

Thank you for raising this.

I don't have an old database version currently because I switched machines.
I did remove the reference to the 1.1 http version constant ... and it compiles on Oracle 21c.
Will have a look at it next week.

Best, Dietmar.

Hi,

are you looking for a full-blown replacement for TIBCO Jaspersoft Studio? Or do you have a limited use-case?
After a brief search for HTML/Javascript alternatives (which I could integrate into APEX) I have only found the following: https://fileproi...

Hi Stephan,

you can find the actual code here, the function is compileJRXMLIfNecessary(): https://github.com/daust/JasperReportsIntegration/blob/main/src/main/java/de/oc/jasper/ReportUtilities.java

The basic concept is:

• compilation is only...

Hi,

I am not sure, I fully understand the use case.

Can you post a simplified version of the pl/sql call and also the SQL query in the .jrxml report file?
That Java code doesn't really make sense to me.

You should have a SQL query in the report, right?

No, not at the moment.I did build an integration into it in the past, but never made it into production. Conceptionally it should work. Nevertheless, the report has to be built differently. The data source would have to be XML, which is fed into the repo...

This typically indicates a missing font in the environment of the Tomcat (or other J2EE) server. You need to install all required fonts on that machine locally so that they are accessible by JasperReports.

Perfect!

The proof is in the pudding. Whatever works for you.
Actually, the file setenv.bat needs to be created first, it does not exist after installation. But this is a typical (and well documented) way to configure Tomcat.

Best
~Dietmar.

Well, xlib_jasperreports.show_report() will form the URL AND execute the report through the database backend using UTL_HTTP. Thus, the call to the Tomcat (where jri.war resides) is done from the database, NOT the client browser.

So, basically, the dat...