[SPS 09] How to use .xssqlcc?

[Former Member]

I saw a lot of things about .xssqlcc with the $.db, but i'm already using the new $.hdb and when i call my .xssqlcc file ($.hdb .getConnection("package::file")) it returns me an error "Error: getConnection: Wrong argument type. Expects Object!"

What can I do?

[thomas_jung · Accepted solution]

With the new DB interface, the getConnection has more options.  It now expects a JSON structure to pass in these options.  See the online help:

http://help.sap.com/hana/SAP_HANA_XS_JavaScript_API_Reference_en/$.hdb.html

var connection = $.hdb.getConnection({"isolationLevel": $.hdb.isolation.REPEATABLE_READ, "sqlcc": "package::mysqlccfile"});

[Former Member]

Thank you!