Connect To HANA DB Using Java - Syed Hussim

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

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

Recent Articles

If Table Exists Function

In this article, I explain how to create a function to determine if a table exists in SAP HANA.

Connect To HANA DB Using NodeJs

This article explains how to connect to a SAP HANA system using the Node HANA client library.

Simple Http Server

This article explains how to create a simple HTTP server using Node.js without using any dependencies.

php-sapb1 Library Documentation v1

A simple and easy to use PHP library for SAP Business One Service Layer API.

node-sapb1 Library Documentation v1

This article provides documentation on the SAPb1 NodeJs library.

Reading From Console

Node.Js provides several ways to read user input from the terminal. This article explains how to use the process object to read user input.

Difference Between const, let And var

This article explains the difference between const, let and var.