Pesquisar

Question

Pushyanthkumar ... · Aug 4, 2023

We encountered difficulties while attempting to establish a JDBC connection to Intersystems using AZURE Databricks, resulting in an inability to retrieve data. The JDBC version utilized was intersystems-jdbc-3.3.1.jar. If anyone has successfully employed Databricks for establishing a connection, we would appreciate information regarding the libraries you used

Error Message:
org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3) (10.140.70.71 executor driver): java.sql.SQLException: [SQLCODE: <-25>:<Input encountered after end of query>]

7 Comments

Discussion (7)3

Question

Norman W. Freeman · Jul 27, 2023

#Management Portal #InterSystems IRIS

There is several classes that allow to create TCP/IP connections (eg: to connect to a service).

Example : %Net.FtpSession (port 21), %Net.HttpRequest (usually port 80 or 443)

AFAIK connection will stay open unless closed explicitly or if variable that hold the instance is garbage collected.

Is there a way to get a list of all active (open) TCP/IP connections IRIS is maintaining so far ?

I took a look at Portal (eg: in dashboard, "System Resource Statistics") but couldn't find anything. Web Gateway panel provide information about connections but this is incoming connections for CSP pages. I am look for external connections (the other way around).

If it's not available in Portal, some API / classes will be fine too.

I could of course run TCPView , netstat or something like that but I am looking for something built-in in IRIS.

6 Comments

Discussion (6)2

Announcement

Elena E · Jul 20, 2023

#Development Environment #Git #Developer Community Official #Open Exchange

Exciting news for developers using GitLab for their InterSystems applications repositories! Open Exchange has expanded its support to include GitLab, allowing you to submit your projects just as easily as you would do with GitHub repos.

Submitting Your GitLab Repo app on Open Exchange:

Start by navigating to Open Exchange and log in to your account.
Head to the "Submit Application"
In the "GitHub/GitLab URL" field, include the link to your open GitLab repository.
Make sure to check the "Use GitHub/GitLab README as long description" checkbox. This ensures that your project's README file serves as a a long description for the app.

Fetching App Data from GitLab

With the integration of GitLab on Open Exchange, the platform fetches application data from your GitLab repository, much like it does with GitHub:. This means you can take advantage of Open Exchange's wide range of features and services regardless of the repository hosting platform.

Please don't hesitate to share your feedback on this feature here in comments or DM me.

1 Comment

Discussion (1)3

Article

Robert Cemper · Jul 8, 2023 2m read

Open Exchange

#Indexing #InterSystems IRIS

A recent question from @Vivian Lee reminded me of a rather ancient example.
It was the time when DeepSee's first version was released.
We got Bitmap Index.
And we got BitSlice Index: mapping a numeric value by its binary parts.
So my idea: Why not indexing strings by their characters?
The result of this idea was presented first in June 2008.
IKnow wasn't publicly available at that time.

The principal idea was to split Strings into its characters
Data type %Text had some kind of capability in this direction.
But it is designed to split a text string into words.
The split is language dependent and requires a dictionary.

So I had to build my own dictionary. And borrowed it.
In Japanese every single character can be a word.
This was my start and with a few adjustments it serviced my needs

The example that is also available now on IRIS and in Docker
consists of a Dictionary class and a Data class for demo data.

The result is impressive even with 3 documents of 158 lines
I compared normal [ (contains operator) to the character slices.

Search for a 2-char chunks: Global Access down from 159 to 34
Search for 2 independent chunks: Global Access down from 159 to 15

The Dictionary defines what chunks are indexed.
This example uses chunks from 1..4 char.
The larger the chunks the larger the index and the better the hit rate.
It might be worth experimenting with your special cases.

#Video

#Video

1 Comment

Discussion (1)1

Discussion

Robert Barbiaux · Jul 7, 2023

#SOAP #InterSystems IRIS for Health

Hi everyone,

This one had me breaking a sweat 😅

When a SOAP request has a %Stream.GlobalBinary property, it fails to serialize to base64 when stream is larger than ~43MB with

ERROR #6301: SAX XML Parser Error: <MAXSTRING>xeWrite+7^%occXMLInternal

Unless you enable the following parameters :

Parameter BASE64LINEBREAKS = 1;
Parameter USEPPGHANDLER = 1;

The first one instructs %SOAP.WebBase to insert line breaks in the XML text, and the second one to use globals rather than local array memory during serialization (to avoid <STORE> error, depending on your available $zstorage)

Enabling both in my SOAP client (created by the SOAP Wizard), solved my problem : the IRIS business operation using the client can now process requests holding very large streams (in my particular case, a whopping 221MB !)

Discussion (0)1

Azure Databricks JDBC connection to Intersystems

Is it possible to get a list all active open TCP/IP connections made by IRIS ?

GitLab is Now Supported on Open Exchange

Character-Slice Index

SAX XML Parser Error during SOAP request serialization (ERROR #6301: SAX XML Parser Error: <MAXSTRING>xeWrite+7)