Connecting to a HANA system using Java requires the JDCB ngdbc.jar driver. This driver comes as part of the HANA Studio installation. You can also download it when installing HANA Express using the download manager.
Listing 1 below shows a sample connection code.
Listing 1 below shows a sample connection code.
Listing 1
import java.sql.*;
class Example{
public static void main(String args[]){
try {
Connection connection = DriverManager.getConnection(
"jdbc:sap://host:30015", "USER", "PASSWORD");
System.err.println("Connected");
} catch (SQLException e) {
System.out.println(e.getMessage());
}
}
}
HANA DB Articles
-
JSON_TABLE Function
In this article, we'll take a look at how to use the ++JSON_TABLE++ function to represent JSON data stored in a regular column as a relational table.
31 March 2023 - 2696 views -
Connect To HANA DB Using Rust
Learn how to connect and query a HANA database using Rust with the hdbconnect package.
21 February 2023 - 2758 views -
If Table Exists Function
In this article, I explain how to create a function to determine if a table exists in SAP HANA.
31 October 2019 - 8832 views -
Connect To HANA DB Using NodeJs
This article explains how to connect to a SAP HANA system using the Node HANA client library.
28 October 2019 - 7128 views -
Connect To HANA DB Using Python
This article explains how to connect to a SAP HANA system using the Python hdbcli package.
11 October 2018 - 7978 views -
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.
14 March 2018 - 6253 views -
Connecting To SAP HANA Using PHP ODBC
This article describes how to install and configure PHP odbc to connect to a SAP HANA system on Ubuntu 16.
01 December 2017 - 7640 views