HANA XS js problem

[Former Member]

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

[thomas_jung · Accepted solution]

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.

[Former Member]

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