#Caché

Hello everyone,

I'm doing a REST service for integration between 2 systems. The system that invokes me expects a response object where only one of its attributes changes.

In our last lesson, we implemented a linkage to our WidgetAccessory class, and debugged some errors we encountered along the way.  We now have our data being returned by REST, but what if we want to update or add new data to our application?  

So far we have only used HTTP GET commands with our REST Services, we now have to implement PUT (which roughly corresponds to an Update) and a POST (which roughly corresponds to a Create.  Author's note: there is a lot of writing online about why this statement isn't entirely correct, I'm not going to go into the detail here).

or "Things are going to break"

We left our application over the weekend, secure in the knowledge that it was returning data from our primary persistent class, User.Widget.  However, Widgets Direct are the premier supplier of both Widgets AND Widget Accessories, so we should really start working on adding these Accessories to our application. 

We should do some housekeeping first though.  Our Page Controlller code is currently sitting in the widgetmaster.js file.

Hi,

In SOAP Wizard, whatever WSDL I pass, I m getting the following error in the SOAP Response. Even If I create my own SOAP Web-Service and pass its WSDL, I am getting the same.

I'm breaking my head trying to figure how to solve this issue. 

When using SQL, If the column (property) is populated with at least one value and is a %List, then I can check if it's $listvalid and $listlength(column) > 0.
Now let's suppose there's no data inserted for that column on next row.
I can't simply use $listvalid because $listvalid("") = 1. Yeah, empty values is a $list for Caché.
So my question is, how do I discover if the regarding column is indeed a %List independently of being empty or not when retrieving it's value via SQL?

I need to guarantee that a parent AND child rows has been inserted successfully before any other process is able to read ANY of the data.

What is the proper way to prevent DIRTY reads?  Per the InterSystems's documentation I should be able to use ' START TRANSACTION ISOLATION LEVEL READ COMMITTED'.  I have attempted to use these commands in embedded and dynamic SQL calls to no avail.

I have to be able to insert the data via JDBC calls, but legacy Caché (.MAC) may be reading the data, and if the data is read to quickly, I could have processing errors, as all the child rows have not been inserted.

Hi!

During a Caché system management training course today we discussed structural database integrity (a.k.a. physical integrity) and the tools InterSystems provides for checking integrity and fixing problems.

I'm aware of two ways to get list of files in a dir:

set dir = "C:\temp\"
set rs = ##class(%File).FileSetFunc(dir, , , 1)
do rs.%Display()

and:

set dir = "C:\temp\"
set file=$ZSEARCH(dir_"*")
while file'="" {
   write !,file
   set file=$ZSEARCH("")
}

Yet they bot return only files and directories in a current directory, but not files in subdirectories.

I suppose I call one of these recursively, but maybe there's a better solution?

Is Healthshare a product?.Health share Database how to differ from another Product Database?.Are using any intermediate services for Healthshare DB?.

Is the InterSystems Cache has SQL or Non-SQL concept?

Hello,

is it possible to ZW variables in stack frames above the current one? I am calling a custom logging method, and would like to log variables from the point of call.

Thanks

Jiri

Hi,

Cache Studio's inspector window can show me a Cache class's properties,methods parameters, XDATA blocks, Triggers, Foreign Keys, Queries and more, in a table in the Inspector window. Additionally, for properties, where the property accepts parameters, these parameters are listed together with possible value choices.

       What is the difference between mac and class files and these files are how to converted int file format

Is there any methods/ways through which will get to know whether any of the Unit Test cases is/are failing in the Terminal with status as either 0 or False in case of Failure & 1 or Ture in case of Test Passes (we are getting an url of the csp page with the report which has the passed failed status) as we need to send this failure status to Jenkins for the Build to Fail (where in we have acheived this part in making the build failure/success based on  harcoded boolean)

I need to execute a single csession command which calls a multi-parameter routine, such as ^SECURITY. This will be to do things such as create databases, resources, etc. (see below). When I run the command all at once, I get a PARAMETER error.

i got an unspecified character in my try-cache i do sample class definition using stream collection what is my defect plz reply me as soon as possible

Today I helped someone solve a mystery. He had been trying to use the -U namespace argument of a csession command to specify the namespace in which to run a particular routine, and was puzzled when the routine could not be found.

Hello!

I'm getting error <ENDOFFILE> zOutputToDevice %Library.FileBinaryStream.1 when sending XML request to Web Server.  How I can avoid this error? Can anyone help me?

I thought REST services is accessing confidential data, so we should follow the authenication rules?

As Bill has mentioned earlier in his post, we have carefully reviewed the JSON capabilities and made some adjustments to ensure they deliver the best benefit to you. In this post, I am going to describe the modifications in more detail and provide guidance for you to understand the implication for your code base.

I am inserting rows in a table. This table is appearing in all namespace as I did global mapping. 

So once I run insert command from a method, it insert the rows. When I run the same insert command from other namespace, it replace the existing data in table. 

Insert command is same in all namespace but the data I m inserting is different. 

Hi,

I want to know how exactly,do we invoke the SOAP Web Methods(Methods in the SOAP Web-service which has been created in the Studio) by Cache Class.

THANKS, Safeena.M

I need to know where i can have good understanding about Deepsee in cache and please provider some example code referring to Deepsee as i am beginner in it. what purpose is it used for ?

Hello,

I'm having a problem with %SQL.Statement.

I have a ClassMethod on Cache that I'm trying to access via - this.db.invoke_classmethod.

When I get to my %Prepare I get a <DYNAMIC LIBRARY LOAD> error. Upon checking cconsole.log I find the following...

05/25/17-09:45:35:224 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:45:35:224 (9876) 2 zlib unavailable
05/25/17-09:58:12:507 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:507 (9876) 2 zlib unavailable
05/25/17-09:58:12:585 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:585 (9876) 2 zlib unavailable
05/25/17-09:58:12:616 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:616 (9876) 2 zlib unavailable
05/25/17-09:58:23:663 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:663 (9876) 2 zlib unavailable
05/25/17-09:58:23:679 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:679 (9876) 2 zlib unavailable
05/25/17-09:58:23:741 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:741 (9876) 2 zlib unavailable

InterSystems is pleased to announce the availability of the following maintenance releases:

• Caché and Ensemble 2017.1.1
• HealthShare Health Connect v15.021 on core technology 2017.1.1

Caché and Ensemble are available on the same platforms as 2017.1.0, except as noted below

• The full list of corrections can be found in the release notes.
• The version number of the kits for these releases is 2017.1.1.111.0
• Oracle Solaris 10, 11 for SPARC-64 and Oracle Solaris 10, 11 for x86-64 are not yet approved.

HealthShare HealthConnect v15.021 on core technology 2017.1.1.111.

In my previous article, I gave an example of how to get the own image with InterSystems Caché. Now it's time to launch a project with container.

Check the new video on Developer Community YouTube Channel:

Mirroring - Architecting for Throughput 

In this video, learn how to provide high availability (HA) and disaster recovery (DR) in diverse architectures that demand high performance, including replication over long distances.

Enjoy!

Hi!

I'm saving object instance using RestForms.

RESTFormsUI calls %Save() for me, which is great. But I want to set the property CreationDate with the current date for every new record being inserted.

So  object callback implementation seems as a reasonable option. I did the following:

Method %OnBeforeSave(insert as %Boolean) As %Status [ Private, ServerOnly = 1 ] 
{

 if insert s ..CreationDate=$H

 q $$$OK

}

And it works fine.

But Documentation says I'd better use %OnAddToSaveSet()

What are you using for the callbacks in similar cases?

In Cache 2013.1.6.950.1 I have a ZEN dataGrid which works fine except if I use the mouse wheel to scroll through it.

If you use the mouse wheel (rather than the scroll bar) to scroll to the bottom of the grid and then click the checkbox against the bottom row it works the first time however if you then scroll back down the grid with the mouse wheel to the check box and uncheck it the check box will still be checked when you scroll back down to it and it only goes unchecked when you click in it a second time.  It works fine when the scroll bar is used.