Connect To HANA DB Using Java

  • Syed Hussim
  • 03 November 2017
  • 4907
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
  • 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 - 740 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 - 948 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 - 8066 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 - 6357 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 - 7147 views
  • Adding Auto Numbers To Table Columns

    This article explains how to create an auto generated column using IDENTITY.

    14 March 2018 - 5356 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 - 6928 views

HANA DB

  • JSON_TABLE Function

    SAP HANA has several functions to help query JSON data and in this article, we'll take a look at how to use the JSON_TABLE function to query JSON data stored in a regular column.

    31 March 2023 - 740 views
  • Connect To HANA DB Using Rust

    The hdbconnect package makes it easy to connect to a HANA database using Rust and in this article, we'll take a look at how to establish a connection and perform some queries.

    21 February 2023 - 948 views

Rust

  • Count File Types In Directory

    In this last article on developing a command line program, we'll develop a program that counts the occurrence of different file types in a directory and its sub-directories. The program will accept a directory as an argument and recursively scan all sub-directories. We'll use a HashMap to keep track of the count for each file type.

    29 January 2023 - 919 views
  • Port Scanner

    In the previous article, we developed a simple command line program that counted how many times a word occurred in a text file. The article gave us a brief introduction to the env, collections, and fs modules. In this article, we'll take a look at the TcpStream struct from the net module to develop a simple port scanner.

    05 January 2023 - 2697 views
  • Word Frequency Counter

    The best way to learn any programming language is to develop small meaningful programs that are easy to write and serve a purpose. In this three part article, we'll develop several small command line programs. Each article will focus on a different part of the standard library.

    02 January 2023 - 568 views

Java

  • A Simple HTTP Server - ThreadPool - Part 3

    In part 1, we developed a simple single-threaded HTTP server that processed requests synchronously. In part 2, we modified the server so that each request was handled in a separate thread, which improved concurrency but increased the load on the CPU and memory. In this article, we'll modify the server to use a ThreadPool which will help to improve concurrency while reducing the CPU and memory usage.

    15 January 2023 - 1175 views
  • A Simple HTTP Server - Multi Threading - Part 2

    In part 1, we developed a simple single-threaded HTTP server that returned a static string. While single-threaded servers have their use cases, they lack scalability. The nature of a single-threaded server means it can only process one request at a time. If there's a request that's taking a long time to process, all other requests will be blocked until the slow request has been completed. If we want to handle multiple requests at the same time, we need to use threads.

    22 December 2022 - 1275 views
  • A Simple HTTP Server - Part 1

    NodeJs has built-in http modules that allow developers to build web applications without the need to configure and run a proprietary HTTP server such as Apache or Nginx. Other programming languages provide similar libraries that allow developers to bundle a server with an application. So in this article, we'll take a look at how easy it is to write a simple single-threaded HTTP server in Java. Once we're done, we can run a simple test using Apaches ab tool to determine how many requests per second the server can handle.

    06 December 2022 - 1793 views

SAP Business One

  • Stock Transfer Part 2

    Batch managed items can be transferred between warehouses and bins by including the BatchNumbers property in the StockTransfers API post request. The BatchNumbers property is an array of batch numbers. Listing 1 below shows an example JSON object that contains an item with a single batch. Notice that the quantity specified for the batch number object is equal to the quantity at the item level.

    07 August 2020 - 3703 views
  • Stock Transfer Part 1

    Developing inventory management tools requires a good understanding of SAP Business One API's. Many API's in the Service Layer documentation lack payload samples leaving developers to do their own research. This article aims to help developers understand the payload data that is required to create a stock transfer.

    12 December 2019 - 5916 views

Node.js

  • A JavaScript Implementation Of The Logo Programming Language - Part 2

    In this article we continue developing the Logo Programming language further by writing a simple TokenCollection class to help traverse the array of tokens returned from the lexer we created in part 1. This class will be used in Part 3, when we develop the parser.

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

    The Logo programming language was designed by Wally Feurzeig, Seymour Papert, and Cynthia Solomon in 1967 as an educational tool. The language was used to program a robotic turtle that would draw graphics given a series of instructions. In later years the physical robot was replaced by a virtual on-screen turtle. Over the years, various institutions and organizations have implemented the language with additional features. Notable major implementations are UCBLogo and MSWLogo.

    06 June 2020 - 4713 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. You may be tempted to use a third-party library but before you do, consider using the crypto package from Node.js. The crypto module can generate random bytes, which can then be used to create your API keys.

    29 May 2020 - 7291 views
  • Port Scanner

    NodeJs has become one of my go to tools for developing small utilities and services extremely quickly. One such tool that I've developed, is a simple port scanner to help determine which ports are being used.

    31 January 2020 - 3198 views
  • Sorting Algorithms

    I don't often start an article asking a question, but I'll make an exception today. Can you take the following array [8,3,1,9,6,5,7,2,4] and sort it in ascending order? Fairly easy right? Many programming languages provide sorting functions that make tasks such as this a one liner.

    29 November 2019 - 2157 views