New post

#Caché

45

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Hey Community,

my Caché Version is 2013.1 and I can't update now.

I want to serialize a SQL Answer row into an Array filled with objects and then convert it to json.

Actually I use the following, which is very error prone when I have to do that often:

0 7
0 756

Hi!

I believe the simplest is (to work with csv delimited by ";"):


set file = ##class(%File).%New( "data.csv" )
    set sc = file.Open( "R" ) 
    if $$$ISERR(sc) quit    ; or do smth

    while 'file.AtEnd {
        set str=file.ReadLine() 
        for i=1:1:$length( str, ";" ) {
            set id=$piece( str, ";" ,i ) 
            write !, id  // or do smth
        }
    }
    do file.Close()

Possible options:

different variants of error handling with sc code.

Embrace while loop into try/catch block.

And what's yours?

3 16
0 7K
Question
· Sep 25, 2018
Terminal can not be connected.

■Setting up CACHÉ preferred connection server.
server name:localhost
ip adress:127.0.0.1
port:1972
Telnetport:23
web server port:57772
web server ip adress:
CSP server instance:
comment:
Authentication method=>password

■hosts
localhost 127.0.0.1

■os
windows10 (virtual box)

0 6
0 2.2K

Hi all,

I have a class that has been working so far :(

The class extends the EnsLib.RecordMap.Service.FTPService class and add some information for each rows.

Now, when it saves the object it is raising the following error

ERROR #5803: Failed to acquire exclusive lock error

I've seen the other question in the community and I've tried to unlock

1 5
0 1.5K

I am experimenting with Relationships, both Parent to Child and One to Many.

I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?

Thank you in advance for any help provided.

1 25
0 2.1K

Some weeks ago, I was reading a book by Stephen Hawking and Leonard Mlodinow, The Grand Design. At a certain point, trying to define why do we exist? , why do we use the models we use in physics?, ...those kind of things you know... they pointed at the Game of Life example invented by the mathematician John Coward in 1970... Basically he wanted to show that a system with really basic fundamental laws (Physics) could evolve and "live" to become a more complex system (Chemistry) in which "something" (humans) could work out its own model and complex rules to explain its reality… the rules for this deterministic model that he exposed were so basic that I thought it could be funny to implement them in ObjectScript when I had some spare time... there are others implementations in JavaScript and other languages... but not in ObjectScript... and that had to be corrected!!… so here you are!

Open Exchange app
7 10
2 855

hi all,

I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.

I see the connection format is as "

   jdbc:Cache://<host>:<port>/<namespace>

"

What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.

how can I do that? what will be the format

0 4
0 487

Hello, everyone,

InterSystems Certification has designed another certification exam and we need input from our community to help to validate its topics. Here's your chance to have your say in what makes an expert in system administration with InterSystems Caché or IRIS. And, yes, we'd like to hear from you Caché admins!

Here's the exam title and the definition:

3 1
0 346

Full-Stack JavaScript development allows you to create state-of-the-art applications with Caché. With any (web) app you build nowadays, one has to make a lot of architectural decisions and you want to make the right ones. With the Node.js connector available for Caché, you can create a very powerful server side application server, allowing you to use the latest JavaScript technology and frameworks client- and server-side.

With all these new technologies, the most important is to integrate them in the most efficient way and to create a very productive development experience. This article willl get you started step-by-step with Node.js technology.

9 13
1 3.2K

My database service is on the cloud server, and I access it on the company intranet. When I user the %request.CgiEnvs to get "REMOTE_ADDR", but what I have been getting is the company's external address. I can't get my IP address in the LAN.
For example, my computer IP address is 192.168.11.11, and my company's external public network address is 214.17.17. I can only get 214.17.17 by using %request.CgiEnvs("REMOTE_ADDR"), but not 192.168.11.11.

I only want to get 192.168.11.11.

0 6
0 1.3K

Hi,

Has anyone tried to call Security.Users class (in %SYS namespace) for creating or editing users from a shell script (or any programming language)?

If yes, can you please share your code?

We are trying to automate some stuff and would like to know how this worked for others.

Thanks,

Bharath Nunepalli.

1 7
0 412
Question
· Apr 7, 2020
CSP Translation

Hi guys,

I have read thos two links how to translate CSP application 

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCSP_localization_tags#GCSP_localization_tags_compile

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=ASTRLOC#ASTRLOC_localization_util_export

I have exported strings to XML

<?xml version="1.0" encoding="UTF-8"?>

<MsgFile Language="sk">

<MsgDomain Domain="webshop">

1 1
0 222

HI,

I have sample %session like this

%session.Data("product", "1") = "Product 1"

%session.Data("product", "2") = "Product 2"

%session.Data("product", "3") = "Product 3"

%session.Data("product", "4") = "Product 4"

%session.Data("product", "5") = "Product 5"

How can i loop in tag based CSP application over %session?

if i have <csp:while condtion=""> Is there something like %session.Data("products").Next() ?

0 1
0 214

Hi,

Kindly find the below example :

If I open google chrome and I add the below link (just an example) , it will download a file to my local PC.

https://www.abc.com/cgi-bin/ocs/pswd=123&rpt=1

pswd correspond to the password

rpt represent the report

How can I do the above using code in cache studio ?

What type of services should I use? what's the parameters ? functions? and how can I test it?

0 4
0 398
Question
· May 12, 2017
Web Sockets

Hi

I am working on a project that will interact with some software called ROS (Robot Operating System). One of the development challenges we have is as follows:

ROS uses web sockets... So one connect with ws://localhost:9090 to the web socket server. It starts off as http, but then "upgrades" to web socket. It then keeps open this "tunnel" for bi-directional communication..

I need something like a HTTP Outbound adapter, but the Web Socket version of it...

Does anyone have any experience in this area?

Nigel

3 14
1 1.3K
Article
· Feb 11, 2019 4m read
Using Oauth2 with SOAP (Web)Services

Hi guys,

Couple days ago, a customer approached me with the wish to enhance their existing legacy application, that uses SOAP (Web)Services so it shares the same authorization with their new application API based on REST. As their new application uses OAuth2, the challenge was clear; how to pass access token with SOAP request to the server.

After spending some time on Google, it turned out, that one of possible ways of doing so was adding an extra header element to the SOAP envelope and then making sure the WebService implementation does what is needed to validate the access token.

8 1
3 11.8K

The attached code package provides a simple implementation of a web service client that utilizes the USPS Shipping API to normalize an address.

This code requires the developer to obtain a USPS Shipping API user ID which can be obtained from the USPS shipping API website. The assigned User Id can either be passed into the web service call as a parameter or can be coded as a parameter into the Request object.

3 1
0 452
Question
· Mar 30, 2020
Error Switching Journal

Hi,

I'm having a problem when I'm attempting to freeze the instance.

I have a pre-script and post-script to freeze and unfreeze the instance, but when the script execute: 

 csession INSTANCE_NAME -U '%SYS' "##Class(Backup.General).ExternalFreeze(\"$SNAPLOG\",,,,,,1800)"

It's give me this error and fails the freeze: 

Backup.General.ExternalFreeze: Failed, Unable to switch local journal file, Error: -99,ERROR #1142: Error switching journal file: 0
vi

At cconsole.log file show this:

0 4
0 629

The intersystems documentation gives the same description for both <MAXSTRING> and <NETWORK DATA UPDATE FAILED - MAXSTRING>. I suspect that the description for <MAXSTRING> is correct and the description for <NETWORK DATA UPDATE FAILED - MAXSTRING> was an accident. I would like to know what situation triggers the <NETWORK DATA UPDATE FAILED - MAXSTRING> error.

0 2
0 432

I want to create a CSP page that returns a pdf.
The pdf is identified by a pdftoken parameter.

My goal is to validate the token and return the pdf (ContentType=”application/pdf”) if the token
is good and return a text error message "Bad Token" (ContentType=”text/plain”) if the token is missing or bad.

My issue seems to be associated with ContentType. I can define one ContentType that works for the pdf or the error message.
I am unable to change the ContentType.

Any assistance is appreciated.

1 2
1 386