New post
Discussion
· Oct 2, 2020

VSCode Settings JSON File

#Development Environment #Docker #SQL #VSCode #InterSystems IRIS

Hi VSCode users!

Just want to check with you, is this settings.json file ideal enough if I:

1. Want VSCode to connect to IRIS in docker?

2. Want to use VSCode SQL Tool?

The connection settings file:

{
    "files.associations": {
    
        "Dockerfile*": "dockerfile",
        "iris.script": "objectscript"
      },
    "objectscript.conn" :{
      "ns": "IRISAPP",
      "username":"_SYSTEM",
      "password": "SYS",
      "docker-compose": {
        "service": "iris",
        "internalPort": 52773
      }
    },
    "sqltools.connections": [
      {
        "namespace": "IRISAPP",
        "connectionMethod": "Server and Port",
        "showSystem": false,
        "previewLimit": 50,
        "server": "localhost",
        "port": 32770,
        "askForPassword": false,
        "driver": "InterSystems IRIS",
        "name": "objectscript-docker",
        "username": "_SYSTEM",
        "password": "SYS"
      }
    ]

}

Also available here.

Discussion (2)1
Log in or sign up to continue
Steve Pisani · Mar 7

Hi,

Note that if you are running a recent release of iris, that is not the community edition, and, does not deploy the personal web server - chances are your docker-compose defines 2 services, one for iris and one for the webgateway.

So for VS Code to reach iris,  I have had to change the docker objectscript.conn entries in the original post to:

{
   ...
      "docker-compose": {
        "service": "webgateway",
        "internalPort": 80
      }
   ...

},

where 'webgateway' is the name of the iris-webgateway service as named in the docker-compose file.

Steve

1 0