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());
}
}
}
-
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 - 5597 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 - 4697 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 - 5729 views -
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.
14 March 2018 - 3330 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 - 5484 views -
Loading And Unloading Column Table Into And From Memory
This article explains how to load and unload a column table into and from memory.
18 October 2017 - 2326 views -
M_SERVICE_MEMORY System View
This article explains how to view detailed information on memory for HANA services.
01 August 2017 - 3557 views