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

The "invalid schema name" error in SAP HANA typically occurs when the JDBC connection cannot properly resolve the schema reference, even if the schema exists in the database. This usually happens due to incorrect connection parameters or missing database context in the JDBC URL.

Solution

You need to specify the database name in the JDBC URL while connecting to the database. The key is to use the currentschema parameter correctly along with proper connection credentials.

Example

Here's the correct way to establish a JDBC connection to SAP HANA with proper schema reference ?

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class SAP_HANA_Connection {
    public static void main(String[] args) {
        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;
        
        try {
            Connection connection = DriverManager.getConnection(jdbcUrl);
            System.out.println("Connection successful!");
            System.out.println("Connected to schema: " + database);
            connection.close();
        } catch (SQLException e) {
            System.out.println("Connection failed: " + e.getMessage());
        }
    }
}

The output of successful connection would be ?

Connection successful!
Connected to schema: TEST

Key Points

The JDBC URL format includes several important components:

• Server and Port: servername.domain.com:30315 (where 30315 is constructed from instance number 03)
• currentschema parameter: Specifies which schema to use as the default
• Authentication: Username and password parameters in the URL

Make sure the schema name matches exactly as it appears in the SAP HANA database, including case sensitivity.

Conclusion

The "invalid schema name" error is resolved by properly configuring the JDBC URL with the currentschema parameter and ensuring all connection details are correctly specified.