search

daust / JasperReportsIntegration

JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).
BSD 3-Clause "New" or "Revised" License
55 stars 23 forks source link

Jasperreportsintegration on linux and autonomus database #74

Closed har3653 closed 3 years ago

har3653 commented 3 years ago

Hi can you give me example for jdbc conection string for conection with autonomus database, i tried to conect using documentation provided but not successfuly.

daust commented 3 years ago

What exactly did you try? Can you copy the exact string here?

This did not work?

[datasource:default]
name=default
url=jdbc:oracle:thin:@tnsnames_entry?TNS_ADMIN=/path/to/wallet
username=MY_USER
password=my_user_password

Did you get an error message?

har3653 commented 3 years ago

Here is the connection string

url=jdbc:oracle:thin:@cloud_high?TNS_ADMIN=/tmp/wallet/

and here is the error

HTTP Status 500 – Internal Server Error Type Exception Report

Message Could not connect via JDBC: IO Error: The Network Adapter could not establish the connection

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: The Network Adapter could not establish the connection 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:733) 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.44

im using odbc8 system : oracle linux 7 oracle cloud VM instance opened 1522 port

I tried both ways of conection, through jks and wallet

daust commented 3 years ago

Can you try using sqlcl on the same machine with the same wallet? To make sure, the wallet works at all.

har3653 commented 3 years ago

I conected through sqlcl as suggested. Im using version 2.4 of integration tool, is it possible to connect with this version

har3653 commented 3 years ago

i tried on another local linux machine and got this error : Invalid connection string format, a valid format is: "host:port:sid"

har3653 commented 3 years ago

OK i just managed to connect from my local machine, i had to use newest odbc8 jar and replace it in tomcat/webapps/jasperreports/WEB-INF/lib and then restart tomcat. And my link had to be closed with / (/tmp/wallet/). Il try same on cloud VM

daust commented 3 years ago

Not sure that it will work with 2.4.

The support for the autonomous database was added in version 2.7: image

There it should work right out of the box.

Cheers

har3653 commented 3 years ago

I conected with 2.4 version from VM on cloud but only works with JKS. On same version of linux but localy it works with oracle wallet. In all cases odbc8 have to be copied into tomcat/webapps/jasperreports/WEB-INF/lib folder and replace old odbc.I conected with jaspereports 6.5.15 with JKS from windows also.

daust commented 3 years ago

Ok, great that you could make it work with 2.4.

So, we are done here, right? Can I close the ticket?

har3653 commented 3 years ago

Yes , thank you