SQL Server

Enable Chilkat Classes in JavaScript

See more JavaScript Examples

To use Chilkat classes in JavaScript, you must first enable them in the host application, as they are disabled by default. Instantiating a disabled class will cause a JavaScript exception. Chilkat classes can be enabled in four local filesystem access modes: sandbox, readOnly, writeOnly, or readWrite. You can also enable all classes in a chosen mode. SQL Server

-- 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