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

Timeout issue when connecting to cloud database #69

Closed daust closed 2 years ago

daust commented 3 years ago

When connecting to an Oracle cloud database, I see the following severe exception in the Tomcat logs: 

oracle.simplefan.impl.FanManager.configure attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out

The connection gets established and everything works, just the initial timeout takes up some time for the first usage of JRI to establish the connection pool for this connection.

The solution is one of the following:

See: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=270218870398327&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2679061.1&_afrWindowMode=0&_adf.ctrl-state=133spg7szt_53 for details.

I guess I will add a parameter for the JDBC configuration file (application.properties), so that it can be turned on for a specific JDBC connection pool but is turned off by default.

daust commented 2 years ago

I have removed the Oracle Notification Services (ons.jar) from the build.

See: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=228794872741974&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2679061.1&_afrWindowMode=0&_adf.ctrl-state=83kfn7hl1_4 for details.

Connections to autonomous database work.

If you need this support nevertheless, you can download the matching jar file from here: https://www.oracle.com/database/technologies/appdev/jdbc-ucp-21-4c-patched-downloads.html