Databases comparative based on a Java project connected by JDBC to IRIS, MySQL and Postgresql.

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.

• 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

Build the image we will use during the workshop:

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

The main purpose of this example is to test the performance of different databases connected by JDBC to a Java project.

• Run the containers we will use in the workshop:

docker-compose build

docker-compose up -d

Automatically an IRIS instance, a MySQL and a PostgreSQL databases will be deployed, a Tomcat will be deployed with the war generated from our Java project (you can check the code under the src folder).

You can check PostgreSQL and MySQL databases from Adminer

• Open Adminer using the following parameters:
  • Server: mysql
  • Username: testuser
  • Password: testpassword
  • Database: test
• Review the records in patient, city and country tables.

• Open Adminer using the following parameters:
  • Server: posrgres
  • Username: testuser
  • Password: testpassword
  • Database: testuser
• Select Schema test
• Review the records in patient, city and country tables.

• Open the Management Portal.
• Login using the default superuser/ SYS account.
• Open System Explorer --> SQL
• Select NAMESPACE USER and Schema Test

The war generated doesn't need further modifications to work, but you can edit the java project to test different queries. In order to generate a new war you will have to install Maven in your computer and add the InterSystems IRIS JDBC library into your local maven repository.

To generate a new war file from Visual Studio you only have to open a terminal and run:

mvn package -DskipTests

A new war will be created under \target\ folder, rename it to performance.war and move it into \tomcat\ folder. The next step to deploy your new war is to clean the Docker containers and images and recreate it again launching:

docker-compose build
docker-compose up -d

This project contains a json file to be loaded into Postman application (performance.postman_collection.json). Once you have imported this file you will be able to launch the tests created by default.