Sample Java code for loading files from local machine to HANA

Subject:

Need to upload a PDF, WORD or Image file from local desktop to HANA

Prerequisites:

1) You have installed HANA studio and client in your desktop

2) Create a table in HANA to store the files:

create column table “YOURSCHEMA”.”SOURCETABLE”( “FILENAME” VARCHAR (20) null,

  “FILECONTENT” BLOB null)

Development:

Step 1) Create a JAVA project in HANA studio. Put “ngdbc.jar” on your libraries in the Java build path as shown in the attachment.

Step 2) Write the below Java code in HANA Studio ( JAVA EE perspective ):

package uploadText;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class uploadClass {

  public static void main(String[] args) throws IOException {

  // TODO Auto-generated method stub

  String inputFile = “d:\\ABCD.pdf”;

  byte[] buffer = new byte[50000000];

  Connection con;

  PreparedStatement stmt;

  int rs;

  try {

  Class.forName(“com.sap.db.jdbc.Driver”);

  con = java.sql.DriverManager.getConnection(“jdbc:sap://HANAIP:HANAPORT”, “HANA_ID”, “HANA_PASSWORD”);

  FileInputStream file = new FileInputStream(inputFile);

  file.read(buffer);

  stmt = con.prepareStatement(“INSERT INTO \”YOURSCHEMA\”.\”SOURCETABLE\” VALUES (?,?)”);

  stmt.setString(1,”ABCD.pdf”);

  stmt.setBytes(2,buffer);

  rs = stmt.executeUpdate();

  if(rs == 1){

  System.out.println(“File uploaded successfully”);

  }

  stmt.close();

  file.close();

  con.close();

  } catch (ClassNotFoundException e) {

  // TODO Auto-generated catch block

  e.printStackTrace();

  } catch (SQLException e){

  e.printStackTrace();

  } catch (FileNotFoundException e){

  e.printStackTrace();

  } catch (IOException e){

  e.printStackTrace();

  }

  }

}

Step 3) In HANA Studio console you will see the message “File uploaded successfully”.

Step 4) Run the below SQL:

SELECT * FROM SOURCETABLE

You will see the table content.

I could load a text as well as image file using the same code. Just need to change the file name.