Connect To HANA DB Using Java

  • Syed Hussim
  • 03 November 2017
  • 4185
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());
        }
    }
}
HANA DB Articles
Recent Articles
  • A Simple HTTP Server - Part 1

    In this article, I discuss how to create a simple single-threaded HTTP server.

    06 December 2022 - 3 views
  • Stock Transfer Part 2

    In the previous article I exaplined how to transfer stock between warehouses and bin enabled warehouses. In this article, I discuss how to transfer batch enabled items.

    07 August 2020 - 2251 views
  • Logo Programming Sample Code

    This article details the usage of the CSharpLogo program, which is a basic port of the iconic Logo programming language.

    29 July 2020 - 1176 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 2

    Part 2 of A Javascript Implementation Of The Logo Programming Language. In the previous article I explained how to develop a simple lexer. In this part we develop a TokenCollection class to help traverse the array of tokens returned from the lexer.

    10 June 2020 - 1887 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 1

    In this four part article, I explain how to develop the iconic Logo programming language in JavaScript. In this part, we discuss how to take a source input and convert it into a series of tokens.

    06 June 2020 - 3047 views
  • Generating Web API Keys

    If you're building a REST API, chances are you're going to need to generate secure random API keys. In this article, I explain how to use the Node.js crypto module to generate random secure API keys.

    29 May 2020 - 5810 views
  • Port Scanner

    A simple port scanner to scan a range of ports.

    31 January 2020 - 2361 views