Problem:
We have tried to upgrade our JasperReports Server version from 8.0.4 to 9.0.0 in our environment and the upgrade was successful, but we did not find the Oracle JDBC JAR and in the UI when we tried to connect through Oracle data source, we did not find the driver in the drop-down menu, it is showing as "NOT INSTALLED" for Oracle driver. Any suggestions on how to proceed further with this situation?
Cause:
Starting from JasperReports Server 9.0.0 Progress JDBC drivers have been removed from JasperReports Server.
Solution:
If you have any resources that use or depend on any of the Progress JDBC Drivers, then you must manually install native drivers. After installing new drivers, update the resources in JasperReports Server to use the new drivers. Kindly see our Release Notes for more details.
https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-release-notes/v900/relnotesbody-_-functionality/
As JasperReports Server doesn't include JDBC drivers for the following commercial databases: Oracle, SQL Server, or DB2, you need to obtain one of the available JDBC drivers and copy it into the correct location, and then edit default_master.properties before running the upgrade steps. See section "Working With JDBC Drivers" from our Upgrade Guide for more information.
https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-upgrade-guide/v900/jrs-upgrade-guide-_-jdbc-driver/
________________________________________________________________________________________________________________________
Ref. Case #02242678
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now