Hi everyone

when I use JDBC(Version:intersystems-jdbc-3.8.0.jar) to connect to the Iris(Version: 2021.1.2.338 xDBC Protocol Version 63)

I’m trying to execute SQL statements that include double quotes, but unfortunately, they’re failing.

For example:

[this query]

SELECT count(*) AS "_pfgnrtd_0" FROM "BILL_COM_PO"."PrintLog"

[Error ]

0 3
0 143

InterSystems Online Learning has updated courses to include the latest information about InterSystems IRIS. See descriptions below, and try a course today!

Troubleshooting Productions
Get an introduction to troubleshooting productions, with a focus on locating and understanding some of the key Management Portal pages when troubleshooting.

0 0
0 267

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

Leveraging Automation Tools for Deploying InterSystems IRIS Applications @ Global Summit 2024

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

0 0
1 169

I am trying to work with Epic on FHIR. Epic's documentation stated, your application makes a HTTP POST request to the authorization server's OAuth 2.0 token endpoint to obtain access token.

Set tSC = ##class(%SYS.OAuth2.Authorization).GetAccessTokenClient(pClient,pScopes,.prop,.err) returns

ERROR #9761: No key in provided JWKS for alg ES512 and kid

I check this /csp/sys/oauth2/OAuth2.JWTServer.cls?client_name=medbank and I see this:

0 1
0 67

Has anyone tried the Ansible module for qlist in the article "Ansible modules and IRIS demo"?

There appears to be a bug in the qlist code as it assumes that the qlist output has an undocumented field.

I do not have the undocumented field in the output.when I run qlist so I keep getting the error "Unexpected IRIS qlist output format".

I assume that in most cases there is no undocumented field in the output.

0 0
0 62

Hi everyone,

I'm trying to connect my Laravel application with the InterSystems IRIS Data Platform using ODBC.I need help setting up the ODBC connection and querying the database properly. What is the proper way to configure Laravel to work with an ODBC connection to InterSystems IRIS?

Any help would be greatly appreciated!

Thanks in advance!

0 1
0 128

Hi everyone,
I am trying to create a listen server in Cache 2016 that can capture data from a specific port. Can someone guide me on how to set this up, including handling incoming connections and reading data from the port? Any advice or example code would be much appreciated!

Thanks in advance!

0 2
0 66
Question
· Feb 10
CRLF to LF

For example we have a docker app that receives a .csv file from windows environment and then do some processing on it in docker linux environment.



Windows encode new line in CRLF format, but linux can understand only LF and throw an unexpected errors like

0 4
0 104
Question
· Mar 17, 2020
Building $lb from C

I have a C string and I need to build a $lb from it.

This code works fine for strings shorter than 254 characters:

char *str = "some string";
int len = strlen(str);
int add = 2;
char *list = malloc(len + add + 1);
char lenChar = len + add;
sprintf(list, "%c\x01%s", lenChar, str);

Thought maybe someone can share the code for longer strings?

0 1
1 337

I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work?

Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block?

0 2
0 65

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ Understanding System Performance Metrics

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

0 0
0 258

Hey Developers,

Watch this video to learn about InterSystems IRIS's new ability to integrate seamlessly with industry-standard observability tools to gather and visualize your InterSystems IRIS metrics, logs, and traces.

Modern Observability with InterSystems IRIS & Open Telemetry@ Global Summit 2024

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

0 0
0 70

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

Diving into InterSystems Cloud Technology

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

0 0
0 237

Hi Community!

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

Real World NLP Use Cases

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

0 0
0 281

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

Leveraging Containers for DevOps

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

0 0
0 356

Join our next in-person Developer Meetup in Cambridge to explore the latest trends, tools, and features for innovating on health data.

Talk 1: AI Coding Assistants in Practice
Speaker: @Derek Gervais, Developer Relations Evangelist, InterSystems

Talk 2: MCP, SkyNet and You!
Speaker: Dave McCaldon, Senior Development Manager, InterSystems

>> Register here

⏱ Day and Time: May 14, 5:30 p.m. to 7:30 p.m.
📍CIC Venture Café in Cambridge, Massachusetts

0 0
0 75

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

InterSystems IRIS: Easy to Consume and Easy to Use @ Global Summit 2024

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

0 0
0 13