Dietmar Aust

daust ·

I can have a look. Please contact me at dietmar.aust AT gmail.com.

I don't know where you went wrong. But you can use the jetty as is.

I still believe it is a privilege / access issue.

Would it be possible to use jri without tomcat in relation to apex? That in the conditions in which jri starts on port 8090 and seems to see and recognize the database?

I am sorry, but I don't understand the question.

You don't need to install Tom...

Hhhm. Perhaps there is some security software involved? Some live virus checker disallowing access to this file for some reason? Or another hardening of the system?

Is the file read-only for some reason?

I am sorry, but I can only work with the information that I have:

• you managed to install on other systems, thus you generally understand how it works.
• And the software works as well in general.
• Thus, there is something different on this Wind...

The log indicates it might be a privilege issue with the log4j.properties file?
Can you check that?

Best
~Dietmar.

Not specific enough.

Which version of JRI and what is the error? Please post the relevant part from the logfile in Tomcat.
Thanks.

As the error code suggests, the connect string to the database is wrong. Please double check. If it still doesn't work then post your config file without the password.

Can you provide the files for a simple test case? Please use a query on user_objects, e.g.

select count(*) cnt, object_type 
  from user_objects
 group by object_type

Thank you.
I am still on vacation so I might have a look next week.

Hi,

I don't quite understand. The error message says the account is locked. You need do unlock it.
Connect as a dba user (SYS, SYSTEM, etc.) and issue:

alter user <username> account unlock;

Then restart the Tomcat so that the connection pool is rebui...

yes, that would certainly work. It is recorded in the logfile.

I guess I would have run the following statement from within the database (using sqlcl, SQL Developer or something similar):

select httpuritype('http://localhost:8080/jri').getclob() from...

Hi @sellexx-stephan,

thank you for giving so much feedback, well appreciated :).

Issue added: https://github.com/daust/JasperReportsIntegration/issues/76

You can see the ip address that is being tested against here:

Yes, it is an ip address ... just vor IPv6, not IPv4.

See here for reference: http://www.steves-internet-guide.com/ipv6-guide/

Hi @sellexx-stephan,

while this is correct and true, I would rather suggest to fully understand the proper syntax for Oracle jdbc urls: https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/data-sources-and-URLs.html#GUID-C4F2CA86-0F68-4...

Hi @sellexx-stephan,

yes, you are right. I changed the parameter name and fixed it in almost all places.

The right setting is: ipAddressesAllowed

The documentation was correct, though: https://github.com/daust/JasperR... , especially in the section .

I see that those two requests are indeed different, one seems to be about the Oracle cloud and this one is more general in nature.

I will have to look into this and do some testing myself. Perhaps you could configure a local domain name on the database se...

Hi,

you have created a question in two places, let us continue the conversation here: https://github.com/daust/JasperReportsIntegration/issues/75

Cheers
~Dietmar.

Hi @miki720 ,

direct printing will send the document to a printer that is CONNECTED TO THE APPLICATION SERVER, not the client browser.

In order to see the names that are known to the application server, go to the Tomcat directly: http://vm1:8...

Hi @mohamedhattab,

I have checked it and it works with my setup on the latest versions:

• JasperSoftStudio 6.16.0
• JRI version jri-2.7.0-jasper-6.16.0

it seems like the .jasper file created with JasperSoftStudio 6.12.0 is incompatible with t...

Thank you for the detailed explanation! I will have a look at it.

Please provide more details:

• Screenshot of the problem
• Simple test case - based on a simple query without database objects, e.g.

  select '... this is long text ...' my_text from dual;

• Upload the .jrxml file for this testcase
• Version of the...

Thank you. I have added your suggestion to the FAQ/Troubleshooting section: https://github.com/daust/JasperReportsIntegration#faq

Hi David,

I have added a section to the GitHub homepage under Related Projects for JRI Publisher.

Best
~Dietmar.