How to connect to SAP HANA from Jython using JDBC
Product: On Prem-Oracle EPM System Workspace, Fusion Edition
Version: 11.2.8.0.0.05
Product: Oracle Hyperion Financial Data Quality Management, Enterprise Edition
Version: 11.2.8.0.000.11
Jython Version is: 2.7.2 (v2.7.2:925a3cc3b49d, Mar 21 2020, 10:03:58)
Hi.
In Data Management, I'm using Jython to attempt connecting to a DB in SAP HANA using JDBC. The driver com.sap.db.jdbc.driver is installed and in my script and I am being able to load the driver using Class.forName; no errors.
But when I attempt to create the connection within the Try-Except clause using con = DriverManager.getConnection(url, username, password) , the script stops with just "Error" in the log file but my exception handler is not being able to catch any meaningful exception message.