Catching DB exceptions in XSJS

[Former Member]

Hi, How can i catch DB exceptions like Unique Constraint errors in XSJS and put it in response object? Thanks, Naresh

[former_member182862 · Accepted solution]

Hi Naresh,

Maybe something like this

 
var conn = $.db.getConnection();
var pstmt = null;
var code = 0;

function closeresource(r) {
    if (r) {
        try {
            r.close();
        } catch (e) {
            //ignore
        }
    }
}

function getStatusCode(msg) {
    var m = msg.match('\\:\\s(\\d+)\\s\\-');
    return (m) ? parseInt(m[1], 10) : null;
}

try {
    pstmt = conn.prepareStatement('INSERT INTO "TABLENAME" ("SOMEFIELD") VALUES (?)');
    pstmt.setString(1, '1');
    pstmt.executeUpdate();
    $.response.setBody('OK');
    $.response.status = $.net.http.OK;
} catch (e) {
    code = getStatusCode(e.message);
    if (code && code === 301) {
        $.response.setBody('unique constraint violated');
    } else {
        $.response.setBody('something else');
    }
    $.response.status = $.net.http.BAD_REQUEST;

} finally {
    closeresource(pstmt);
    closeresource(conn);
}