InterSystems Developer Community is a community of 20,011 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Announcement
· Mar 27, 2020
Give it a try on SQLBuilder tool

SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS,

With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries.

A Dynamic SQL without SQLBuilder

A Dynamic SQL with SQLBuilder

11 18
5 653

Hibernate is the most popular framework to do ORM (Object Relational Mapping) projects. With Hibernate a software can use the main DBMS in the market, including the capability to change the database vendor any time, without source code impact. This is possible because the Hibernate supports dialects. Each database product has a different dialect that can be assigned into a configuration file. So, if a software is using Oracle and is looking to evolve to InterSystems IRIS, just change the configuration file with connection and dialect information.

7 7
3 699
Article
· Jul 24, 2023 20m read
Local K8s Deployment of a FHIR server

k8s

This is a sample to deploy iris-oauth-fhir on k3d with IKO.
* iris-oauth-fhir is a sample to deploy a FHIR server with OAuth2 authentication with InterSystems IRIS for Health as a resource server and Google OpenId as an authorization server.
* k3d is a lightweight wrapper to run k3s (Rancher Lab's minimal Kubernetes distribution) in docker.
* IKO is a tool to deploy InterSystems IRIS for Health on Kubernetes.

6 0
2 488

Hi,

I am trying to load all the data tables from one iris server to a client server but some of the tables data failing to load all the time. But I can load around 100 tables successfully but 8 to 10 tables are failing all the time. I made an IRIS odbc connection using odbc driver to load the data from tables.

Also I can see read server loop error message on the iris server side as the same time the table loading fails.

Please find the screen shot attached which shows the error on client server.

0 15
0 932

Hi Community,

Watch this video to learn the basics of how to use the InterSystems® command line interface to execute commands, including starting the Terminal, executing methods and routines, and exiting the Terminal.

Using the InterSystems Terminal

https://www.youtube.com/embed/-vL31qoz91s
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
0 254

Iris DAT file is filling up the Internal Storage with available Free Space to Zero. Is there any Alternative measures to reduce the File size or to control the Capacity. Is there any chance to save Local storage.

Once the Local Storage is full, Production is not responding and throwing Out of Space Error.

Does IRIS has any Internal Cloud Storage which can be used for managing and Storing Database Operations. If yes, How can we configure it,

0 5
0 250

I am trying to setup our first SSL/TLS configuration so we can possibly connect to the EMR FHIR server to pull data into the Interoperability engine.

I am running on Red Hat, and created and submitted a openssl CSR request to our Windows ADCS system.

I used the following command to generate the key and CSR request to submit to Windows ADCS

openssl req -new -sha512 -nodes -newkey rsa:4096 -keyout xxxxxxx.key -out xxxxxxxx.csr

0 1
0 479

The Database Administrator’s responsibilities will include, but are not limited to:
• Monitor systems logs, report abnormalities and troubleshoot.
• Monitor database backups, modify when needed.
• Monitor file system space.
• Perform support and maintenance of existing Cache deployment, analysis, and migration of existing Cache code to Microsoft SQL; and Web Services (SOA).

REQUIRED SKILLS/EXPERIENCE:

1 0
0 218

SCOPE OF SERVICES:
The Database Developer’s responsibilities will include, but are not limited to:
• To perform support and maintenance of existing Cache code
• Analysis and migration of existing Cache code to Microsoft SQL; and Web Services (SOA)

REQUIRED SKILLS/EXPERIENCE:

A minimum of 5 proven years of experience in computer applications development planning, design, troubleshooting, integration, maintenance, and enhancement of Cache Database applications.

0 0
0 230

This is a bit of an IRIS question but also and OAuth 2.0 questions:

I am using %OAuth2.JWT.JWTToObject() to "validate" a JWT. My questions:

- While I am checking claims with the returned body, does the return status of the method "count" as a validation step? In other words, if I weren't checking claims and $$$OK was returned from that method call (passing in the token and public keys), I could feel confident that this token came from the expected auth server?

0 4
0 266
Article
· Jul 20, 2023 1m read
How to track your activity on DC

Hey Developers,

If you wish to know how you're doing in the Community and see your stats, you don't need to scroll through all your posts in your profile (though it is also possible). You can use the Online Analytics Dashboard. In it you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

      9 0
      0 162

      When manually coding REST services and using GET /api/mgmnt/v1/:namespace/spec/:application/ to return an OpenAPI spec, how do you specify supported properties (OpenAPI Properties in Use | Creating REST Services | InterSystems IRIS Data Platform 2021.1) like responses, definitions, and information in paths like summary and description?

      0 7
      1 289

      Hi InterSystems Community

      We recently had an issue where we weren't able to parse a JSON HTTP request, but the issue went by unnoticed. We also did not have a trace of what the raw HTTP request was that we couldn't parse. I'm looking at improving our this by:
      Tracing the raw request using $$$TRACE

      Raising an alert which will hit our Ens.Alert router which will compose and send an email

      1 0
      1 257

      Good morning!

      I am developing a Java project (Spring Boot + Maven + Hibernate) but I've a big issue when I try to define the Hibernate Dialect org.hibernate.dialect.InterSystemsIRISDialect... that dialect is neither in the Hibernate library nor in the IRISDriver class com.intersystems.jdbc

      How should I define the IRISDialect in my project?

      Thank you in advance!

      0 5
      0 762