Skip to Content
author's profile photo Former Member
Former Member

HANA XS js problem

Hi,

trying to use XS server side javascript to upload data I discovered the ..executeBatch() function.

Unfortunately I got the error (developer_mode enabled):

Found the following errors:

===========================

Error: PreparedStatement.addBatch: bulk insert not enabled (line 11 position 0 in /..../xs/test_ins.xsjs)

The HANA box is 1.00.60.379371 - nearly all XS packages installed.

May be somebody knows the setting to enable bulk inserts via xsjs (via ABAP and BO dataservices it is running fine >50000 daterows/s).

rgds

werner

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 05, 2013 at 08:22 PM

    There is no configuration that must be done. Perhaps you aren't using the executeBatch correctly? Can you post your source code? Are you sure you are sending in more than one record? I've found taht if my batch size is only one, the executeBatch fails.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2013 at 07:06 AM

    Thanks Thomas,

    just by chance I used batch size = 1 to test the function -> above error occurs.

    With batch size > 1 it works and I achieve batch upload speeds near to 100k lines on empty tables (very similar to the ADBC batch speed via TREX package and a little bit faster than BO DS).

    rgds

    werner

    Add a comment
    10|10000 characters needed characters exceeded

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 you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.