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

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);

SAP Expert

Published on 05-Dec-2017 15:43:14

• Related Questions & Answers
• Checking SAP HANA Schema owner name
• Different schema types in SAP HANA database
• Checking schema creation in SAP HANA database
• Authoring schema vs Physical schema in SAP HANA
• Changing Ownership of schema in SAP HANA Database
• Getting error while using schema in SAP HANA Modeling
• Checking tables in a schema in SAP HANA database
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Checking a table inside a schema in SAP HANA database
• Taking schema wise backup in SAP HANA
• Taking backup of schema in SAP HANA
• Use of _SYS_BIC schema in SAP HANA
• Use of _SYS_BI schema in SAP HANA
• Refreshing a schema after creating a table in SAP HANA database