(SQL Server) Enable Chilkat Classes in JavaScript

See more JavaScript Examples

Note: This example requires Chilkat v11.4.0 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- Chilkat classes within JavaScript are disabled by default.
    -- An attempt to instantiate a disabled Chilkat class results in a JavaScript exception.

    -- For example, try the following JavaScript without first enabling the Chilkat class:

    -- sb = new CkStringBuilder();
    -- sb.Append('Hello World');
    -- success = sb.WriteFile('c:/aaworkarea/helloWorld.txt','utf-8',true);

    DECLARE @sbJavaScript int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbJavaScript OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @sbJavaScript, 'Append', @success OUT, 'sb = new CkStringBuilder(); sb.Append(''Hello World''); success = sb.WriteFile(''c:/aaworkarea/helloWorld.txt'',''utf-8'',true);'

    DECLARE @js int
    EXEC @hr = sp_OACreate 'Chilkat.Js', @js OUT

    DECLARE @result int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @result OUT

    EXEC sp_OASetProperty @result, 'EmitCompact', 0

    -- Run the script.  This should result in an error because we haven't enabled the Chilkat CkStringBuilder class.
    EXEC sp_OAMethod @js, 'Eval', @success OUT, @sbJavaScript, @result
    IF @success = 0
      BEGIN
        -- Examine the result for an exception.
        EXEC sp_OAMethod @result, 'Emit', @sTmp0 OUT
        PRINT @sTmp0

        -- The result contains this:
        -- {
        --   "exception": {
        --     "message": "Cannot create the chilkat object because the chilkat class is disabled in JavaScript. Fix by calling SetCkPermission before calling Eval or CallFunction",
        --     "stack": [
        --       {
        --         "func": "CkStringBuilder"
        --       },
        --       {
        --         "func": "<eval>",
        --         "file": "<input>",
        --         "line": 1,
        --         "col": 9
        --       }
        --     ]
        --   }
        -- }

      END

    -- Enable the Chilkat CkStringBuilder JavaScript class for readWrite
    EXEC sp_OAMethod @js, 'SetCkPermission', @success OUT, 'CkStringBuilder', 'readWrite'
    -- The script should work now...
    EXEC sp_OAMethod @js, 'Eval', @success OUT, @sbJavaScript, @result

    PRINT 'success = ' + @success

    -- If the CkStringBuilder class is enabled for readOnly or sandbox, then it will fail.
    --   - Chilkat methods that could directly or indirectly write to the filesystem require writeOnly or readWrite access.
    --   - Chilkat methods that read the local filesystem require readOnly or readWrite access.
    --   - Chilkat methods that don't interact with the local filesystem work in any mode including sandbox.
    EXEC sp_OAMethod @js, 'SetCkPermission', @success OUT, 'CkStringBuilder', 'readOnly'
    EXEC sp_OAMethod @js, 'Eval', @success OUT, @sbJavaScript, @result
    IF @success = 0
      BEGIN
        -- Examine the result for an exception.
        EXEC sp_OAMethod @result, 'Emit', @sTmp0 OUT
        PRINT @sTmp0

        -- {
        --   "exception": {
        --     "message": "failed because this Chilkat method requires the writeOnly or readWrite permission",
        --     "stack": [
        --       {
        --         "func": "WriteFile"
        --       },
        --       {
        --         "func": "<eval>",
        --         "file": "<input>",
        --         "line": 1,
        --         "col": 67
        --       }
        --     ]
        --   }
        -- }
      END

    EXEC @hr = sp_OADestroy @sbJavaScript
    EXEC @hr = sp_OADestroy @js
    EXEC @hr = sp_OADestroy @result


END
GO