9

How to store CLOB data in SAP HANA table through UI5 Application?

 1 year ago
source link: https://answers.sap.com/questions/13799199/how-to-store-clob-data-in-sap-hana-table-through-u.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
Search Questions and Answers
5 hours ago

How to store CLOB data in SAP HANA table through UI5 Application?

25 Views Last edit 5 hours ago 2 rev

Hi, I am trying to store CLOB data in SAP HANA table (SAP HANA Database Explorer) through UI5 application and using NodeJS as backend Application. I am getting following error while posting into database, please check screen shots and sample code. If this description is not enough, please reply I will provide more information about it. code.txttable.pngerror1.pngerror2.png

Attachments

code.txt (2.0 kB)
table.png (41.5 kB)
error1.png (4.6 kB)
error2.png (6.3 kB)
2 Answers
Sort by:

Madhav Machiwal

Did you try this method ?

//Create a controller for the UI5 application.

sap.ui.controller("my.controller.uploader", {

    //FileUploader change event
    handleUploadComplete: function(oEvent) {

        //Create an instance of FileReader
        var reader = new FileReader();

        //Read the uploaded file
        reader.readAsDataURL(oEvent.getParameter("files")[0]);

        //The file reader event
        reader.onload = function () {

            //Create an instance of the HANA Client
            var oHanaClient = new HANAClient();

            //Set the HANA table
            oHanaClient.setTable("SCHEMA.TABLE_NAME");

            //Set the data to be stored in the table
            oHanaClient.setData("PDF_DOCUMENT", reader.result);

            //Save the data to the HANA table
            oHanaClient.save();
        };
    }



1 comment
4 hours ago

Hi, Yogananda Muthaiah

Thanks for reply. But does I need any prerequisite library/package Installation for HANAClient().
4 minutes ago

you can not call that api with full url, you have to go through destination, I think.

Know someone who can answer? Share a link to this

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.

You must be Logged in to submit an answer.

Please provide a distinct answer and use the comment option for clarifying purposes.
10 characters required.

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK