Error: "invalid schema name" even if schema is present in the database in SAP HANA

SAP HANASAPSAP Basis

I think you need to mention database name in JDBC URL while connecting to the database. Try following −

String server = "servername.domain.com";
String instance = "03";
String database = "TEST";
String dbUsername = "USERNAME";
String dbPassword = "xxxxxx";
String jdbcUrl = "jdbc:sap://" + server + ":3" + instance + "15/?currentschema=" + database + "&user=" + dbUsername + "&password=" + dbPassword;
java.sql.Connection connection = java.sql.DriverManager.getConnection(jdbcUrl);
raja
Published on 05-Dec-2017 20:13:14
Advertisements