Connect To HANA DB Using Java

03 November 2017 - 1054 views
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

  • 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.

  • Reading And Writing To Files

    Reading and writing to a file is a common task most developers do. Thankfuly Node.js provides a simple to use package that can be used to read and write to a file synchronously or asynchronously.

  • Introduction To Node.js

    Node.js is an asynchronous event driven JavaScript runtime built on Chrome's V8 JavaScript engine. It is deisnged to build scalable networking applications but can also be used to develop applications with GUI's using thrid party libraries.

  • Connect To HANA DB Using Python

    This article explains how to connect to a SAP HANA system using the Python hdbcli package.