Connect To HANA DB Using Java

03 November 2017 - 995 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
  1. 1import java.sql.*;
  2. 2
  3. 3class Example{
  4. 4
  5. 5 public static void main(String args[]){
  6. 6
  7. 7 try {
  8. 8 Connection connection = DriverManager.getConnection(
  9. 9 "jdbc:sap://host:30015", "USER", "PASSWORD");
  10. 10 System.err.println("Connected");
  11. 11 } catch (SQLException e) {
  12. 12 System.out.println(e.getMessage());
  13. 13 }
  14. 14 }
  15. 15}