workshop-sql-jgw

Example about an IRIS production connected by JDBC to a MySQL database throught JGW

You can find more in-depth information in https://learning.intersystems.com.

New to IRIS Interoperability framework? Have a look at IRIS Interoperability Intro Workshop.

What do you need to install?

Git
Docker (if you are using Windows, make sure you set your Docker installation to use “Linux containers”).
Docker Compose
Visual Studio Code + InterSystems ObjectScript VSCode Extension

Setup

Build the image we will use during the workshop:

$ git clone https://github.com/intersystems-ib/workshop-sql-jgw
$ cd workshop-sql-jgw
$ docker-compose build

Example

The main purpose of this example is to get all new data recorded into Patient table and make it accesible from a production in IRIS. You will also be able to write some record into MySQL table.

Run the containers we will use in the workshop:

docker-compose up

MySQL

Open Adminer using the following parameters:
- Server: mysql
- Username: root
- Password: SYS
- Database: test
Review the records in Patient table.

IRIS

Automatically an IRIS instance will be deployed and a production will be configured and run to read new records from a MySQL database.

Test Production

Read data from MySQL table

Opening Visual Studio Code you will be able to review the business operation used to read the object created for each row in Patient’s table and the object definition

Code to read the patient’s object:

 set context.patientStream = ##class(Ens.StreamContainer).%New()
 set stream = ##class(%Stream.GlobalCharacter).%New()
 do stream.Write(request.Id_" "_request.Name_" "_request.Lastname_$Char(13)_$Char(10))
 set context.patientStream.Stream=stream

Patient’s object definition:

Class Test.Patient Extends (%Persistent, %JSON.Adaptor, %XML.Adaptor, Ens.Request)
{

Property Id As %Integer;

Property Name As %String;

Property Lastname As %String;

}

Write data to MySQL table

Check the EnsLib.SQL.Service.Operation operation in your production.
This operation will insert new records in the patient table in MySQL.
To test it simply click on it and Actions tab > Test
- Set the test request type to: Test.Patient
- Fill out some values for Id, Name and LastName
- Test your request
After testing the operation, you can check that the new records are created in MySQL table