Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded