Dietmar Aust
posted to
daust/JasperReportsIntegration
Compatibility with Apex 5.1.1Hi Tullio, yes. It will work with pretty much any APEX version because it is "just" a pl/sql API that communicates with the J2EE server running the custom war file There is an APEX test application, though. This application helps you to chec... |
Dietmar Aust
posted to
daust/JasperReportsIntegration
error when Calling Multi Data-source from Oracle ApexHi @msami07, I designed the integration for a single Oracle db-connection, your use case is not expected. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedAh ok. Thank you for the clarification. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedGood that you have it working but I don't understand what you have changed and how you are running it. Best |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedI can have a look. Please contact me at dietmar.aust AT gmail.com. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedI don't know where you went wrong. But you can use the jetty as is. I still believe it is a privilege / access issue. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be started
I am sorry, but I don't understand the question. You don't need to install Tom... |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedHhhm. 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? |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedIs the file read-only for some reason? |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedI am sorry, but I can only work with the information that I have:
|
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedThe log indicates it might be a privilege issue with the log4j.properties file? Best |
Dietmar Aust
posted to
daust/JasperReportsIntegration
FAIL - Application at context path [/JasperReportsIntegration] could not be startedNot specific enough. Which version of JRI and what is the error? Please post the relevant part from the logfile in Tomcat. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
Exception on Test ReportAs 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. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
Class Not Found Error WIth Custom VisualizationCan you provide the files for a simple test case? Please use a query on user_objects, e.g.
Thank you. |
Dietmar Aust
posted to
daust/JasperReportsIntegration
Could not connect via JDBC: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-28000: The account is locked.Hi, I don't quite understand. The error message says the account is locked. You need do unlock it.
Then restart the Tomcat so that the connection pool is rebui... |
Dietmar Aust
posted to
daust/JasperReportsIntegration
IP-Adress limitationyes, 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):
|
Dietmar Aust
posted to
daust/JasperReportsIntegration
Script user_remove probably misses XLIB_JASPERREPORTS_IMGHi @sellexx-stephan, thank you for giving so much feedback, well appreciated :). Issue added: https://github.com/daust/JasperReportsIntegration/issues/76 |
Dietmar Aust
posted to
daust/JasperReportsIntegration
IP-Adress limitationYou can see the ip address that is being tested against here: |
Dietmar Aust
posted to
daust/JasperReportsIntegration
IP-Adress limitationYes, it is an ip address ... just vor IPv6, not IPv4. See here for reference: http://www.steves-internet-guide.com/ipv6-guide/ |
Dietmar Aust
posted to
daust/JasperReportsIntegration
Tomcat Deployment : The requested resource [/jri/] is not availableHi @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... |
Dietmar Aust
posted to
daust/JasperReportsIntegration
IP-Adress limitationHi @sellexx-stephan, yes, you are right. I changed the parameter name and fixed it in almost all places. The right setting is: The documentation was correct, though: https://github.com/daust/JasperR... , especially in the section . |
Dietmar Aust
posted to
daust/JasperReportsIntegration
SSL Jasperreportsintegration and autonomus databaseI 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... |
Dietmar Aust
posted to
daust/JasperReportsIntegration
SSL Jasperreportsintegration and autonomus databaseHi, you have created a question in two places, let us continue the conversation here: https://github.com/daust/JasperReportsIntegration/issues/75 Cheers |
Dietmar Aust
liked post in
daust/JasperReportsIntegration
Direct printing from JRI and ApexThank you for explanation Dietmar and thank you for your awesome JRI :) |
Dietmar Aust
posted to
daust/JasperReportsIntegration
Direct printing from JRI and ApexHi @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... |