Drivers for Databases

In Cadenza, the following drivers are used by default to connect to databases:

  • Oracle: oracle.jdbc.OracleDriver

  • PostgreSQL: org.postgresql.Driver

  • MSSQL: com.microsoft.sqlserver.jdbc.SQLServerDriver

  • H2: org.h2.Driver

For SAP HANA®, the driver must be added: usually ngdbc.jar, driver class: com.sap.db.jdbc.Driver

Driver directory:

  • in the lib directory of the Cadenza installation (<cadenza_home>/cadenza/WEB-INF/lib)

  • in the libs directory of the Database Migration Tool (<cadenza_home>/tools/database-migration-tool/libs)

  • In the Docker container, if applicable