All time

Hi,

I have a spring-boot Java application which has Quartz Scheduler (spring-boot-quartz-starter) dependency, and uses IRIS DB.
There is a problem with making Quartz Scheduler work with IRIS since there is a blob field expected in two tables, but IRIS is using longvarbinary type.
Can you provide me with clues on how to resolve this?

I am using org.quartz.impl.jdbcjobstore.StdJDBCDelegate driverDelegateClass.

This is the error:
MisfireHandler: Error handling misfires: Couldn't retrieve trigger: invalid stream header: 41434544

0 0
0 134
InterSystems Developer Community is a community of 24,987 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

InterSystems has encountered a defect that causes some upgrades of HealthShare® Health Connect to fail. This only affects instances that are not licensed for the use of FHIR® and that have interoperability-enabled namespaces. Under these conditions, the upgrade fails with an <HSFHIRErr> error.

1 0
0 134

Hello,

I have a .NET based web application and would like to front end it with an Iris4Health server, ie possible using the CSP or web application url's to reoute to the requests into the docker container. Kinda of like a reverse proxy but using Iris for health. Is the external language server a good use for this or is that only for direct interaction with I4H?

I know you can create a custom container with the app copied into it, but not sure if that is the best way.

Any suggestions on how I could accomplish this would be appreciated.

0 0
0 134

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2022:

New Videos
№ Video Views
1 Winners of the InterSystems IRIS for Health Contest: FHIR for Women's Health 7788
2 ObjectScript Data Types 390
3 Using Variables in InterSystems ObjectScript 217
4 Using System Functions in InterSystems ObjectScript 182
5 InterSystems IRIS Cloud SQL 103
6 Online Meetup with InterSystems IRIS for Health Contest Winners 77
7 Updates in Security 73
8 Introduction to Analytics with InterSystems IRIS 73
9 The Final Demo Day of InterSystems FHIR Startup Incubator — Caelestinus 71
10 InterSystems IRIS Cloud IntegratedML 61
11 Patient Experience and the EHR 29
12 InterSystems Cloud Services Overview 25

1 0
0 134

Hey Community,

We greatly appreciate all your feedback on the InterSystems Interoperability Contest! Please take a short survey and answer a few questions to help us improve our contests.

👉 Quick survey: Interoperability Contest Survey 2022

11 Best Questions to Ask in a Restaurant Survey (and how to ask them)

Feel free to share your feedback in the comments of this post as well!

0 0
0 134

In my previous article, Using LIKE with Variables and Patterns in SQL, we explored how the LIKE predicate behaves in different scenarios, from Embedded SQL to Dynamic SQL, and what happens to performance when wildcards and variables come into play. That piece was about getting comfortable writing a working LIKE query. But writing SQL that works is only the starting point. To build applications that are reliable, scalable, and secure, you need to understand the best practices that underpin all SQL, including queries that use LIKE.

This article takes the next step. We’ll look at a few key points to help strengthen your SQL code, avoid common pitfalls, and make sure your SELECT statements run not just correctly, but also efficiently and safely. I'll use SELECT statements with LIKE predicate as an example along the way, showing how these broader principles directly affect your queries and their results.

*This is what Gemini came up with for this article, kinda cute.

10 0
1 133

Hi Community,

We're continuing to improve and teach our Developer Community AI, and in this iteration, we've added descriptions of Open Exchange Applications to the knowledge base!

This new feature will allow DC AI to search app descriptions to answer your questions. This will give you better answers that require programming, not just general information.

To add this knowledge to your search, just tick the checkbox Open Exchange Applications:

6 0
0 133

I set up all the credentials and IP, Port, Namespace, SSL/TLS Server Name and .ini file but I still cannot connect to db. and It says

Iris ODBC][State : 08S01][Native Code 459]
[C:\Windows\system32\odbcad32.exe]
Connection via irisconnect failed:
Matching SSL server config not found in ssldefs.ini or registry

0 2
0 131

I am using a JDBC connection to MS SQL server to execute a stored procedure to select data and bring it into InterSystems as a EnsLib.SQL.Snapshot. I loop through the EnsLib.SQL.Snapshot using a while loop, but I also want to iterate through the Columns within that Row to do logic.

Is there a way to iterate through the Columns of the current Row of the EnsLib.SQL.Snapshot so I can apply logic/rules for further processing?

Thanks

Scott

0 4
0 129

I have a business process that adds data to a global variable on receipt of an HL7 message, and a scheduled task that executes a class method defined within the same business process that removes data from the same global variable. With this in mind it makes sense to consider concurrency and therefore make use of the LOCK command.

My first question is whether this is actually necessary?

0 1
0 132

Hey Community,

Watch the new video on InterSystems Developers YouTube:

⏯ Smart Data Fabric for Generative AI Readiness @ Global Summit 2024

https://www.youtube.com/embed/Z-x6Rk7Bi3I
[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]

1 0
0 133

Hello Community,

I have encountered the following SQL problem trying to create a table from a SELECT statement.

I narrowed the problem down to the following example:

1. The SELECT statement alone works as expected. 

SELECT m.Name, h.Status 
FROM EnsLib_HL7.Message m, Ens.MessageHeader h 
WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID

2. But if "CREATE TABLE ... AS" is added it fails

0 4
0 129

Hi Community,

Thank you for participating in our recent mini-contest! We received many great ideas, and we hope you enjoyed the process.

The mastermind of the winning concept will receive 5,000 points, while the astute "investors" in said concept will receive 200 points each.

The Winning Concept: Senior people loneliness

1 0
0 133
Question
· Aug 3, 2023
XCPD versus PDQ Settings

I noticed that the XCPD processor has a setting for PDQ minimum threshold and maximum record count returned, but PDQ does not have these settings. Can anyone explain why? They are essentially the same service.

0 0
0 133

Good morning,

first of all thank you for taking the time to read and answer this question.

Recently, since we have upgraded to HealtShare 2020, we experienced the fact that when opening in the Studio the Process (.bpl) and Transformation (.dtl) classes, it asks us to log in, i.e. username and password, almost every time we open a new Process or Transformation.

However, in previous versions, I think we had HealthShare 2016 or 2017 or 2018, and in it, you could log in from the Studio in Processes and Transformations, logging in 1 time only.

0 1
0 132

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in October 2021:

New Videos
№ Video Views
1 Fast & Efficient Provisioning & Testing with InterSystems Cloud Manager 749
2 Showcasing Health Insight & Integrated ML for Healthcare Applications 727
3 Data Warehousing with InterSystems 581
4 Introducing the InterSystems IRIS Smart Factory Starter Pack for Manufacturing 296
5 LabResultsVerification-HL7 Demo 116
6 InterSystems Interoperability Contest Kick-off Webinar 75
7 CSV to MS OFX App Demo 52
8 IRIS Interoperability Message Viewer 51
9 #VSummit21: "Who wrote this code? It makes no sense!” – the importance of software maintainability 33
10 Working with FHIR Profiles in IRIS for Health 33

3 0
0 133

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in September 2021:

New Videos
№ Video Views
1 Hands Off HealthShare Deployment Workflow with GitLab Runners 97
2 Tell the World About Your REST APIs: The Benefits of a Centralized Developer Portal 86
3 Best Practices for InterSystems API Manager 81
4 Getting Up to Speed on InterSystems API Manager 73
5 Kafka! Integrating the World's Favorite Stream Processor with InterSystems IRIS 66
6 Using Containers in Highly Secure Environments with IRIS Lockdown 55
7 Stay in Sync with Change Data Capture 55
8 Deploying & Upgrading IRIS with Kubernetes Operator 54
9 iKnow: Open Source NLP in InterSystems IRIS 50
10 How to list a solution on InterSystems Partner Directory 42
11 Showcasing New X12 Enhancements 34
12 HackMIT'21: Building the Next Wave of Healthcare Applications with FHIR, ML, and more 27
13 HackMIT'21: Meet InterSystems and Get Ready for the Challenge 25
14 HackMIT'21: Jumpstarting Development with InterSystems IRIS FHIR Accelerator Service 24
15 HackMIT'21: HL7 FHIR – From smart and dumb devices to consumer applications and population health 16
16 Beez-Woman-Menstrual-Tracker Demo 13
17 Fhirgure App Demo 11

1 0
0 133

Have you read the September newsletter from InterSystems Learning Services? You'll find info about:

• The 2021 Virtual Summit Experience Labs
• Developing database code in Python
• InterSystems Security Basics: Now updated for InterSystems IRIS and InterSystems IRIS for Health®
• New documentation content for upcoming releases, including features that are part of the 2021 Experience Labs

Plus upcoming virtual classroom courses! Read September's newsletter, and subscribe to receive it in your inbox!

1 0
0 133

Hi,

It's me again😁, recently I am working on generating some fake patient data for testing purpose with the help of Chat-GPT by using Python. And, at the same time I would like to share my learning curve.😑

1st of all for building a custom REST api service is easy by extending the %CSP.REST

Creating a REST Service Manually

Let's Start !😂

3 3
1 72