intersystems-cache

Type checking on Caché Objects

What is the point of type definition on method parameters on Caché Object (from Intersystems) since after it's pre-compiled to the .int format, it removes any typing information, thus making no difference at all? ...

How to prevent <session disconnected> errors while running Intersystems Caché terminal scritps?

Hello y'all I'm developing a system that needs to execute Intersystems Cache Terminal Scripts. When I run a routine inside the regular Caché terminal or a telnet terminal, Cache executes the routine until the end with no problems. But when I try to run the same routine, but this time calling the routine within a Caché terminal Script, ...

How to really trap all errors with $etrap in Intersystems Caché?

Hello y'all I've been banging my head a lot because of this. In the way that $etrap (error handling special variable) was conceived you must be careful to really trap all errors. I've been partially successful in doing this. But I'm still missing something, because when run in user mode (application mode) there are internal Cache librar...

Continuous Integration for Intersystems Cache solutions

I am starting a project from scratch using Intersystems Cache. I would like to setup a Continuous Integration Server for the project. Cache has unit test libraries, so the idea is to import source into a test database, build the source, run unit tests in the cache terminal, based on changes in the version control system (ClearCase). Ap...

How to make Intersystems Caché use the new compiled class instead of the older one?

Hello I'm having trouble with loading and compiling a new version of existing classes. At the time they are loaded, there aren't any references in use to them. Class "Test.Extended" extends class "Test.Base". Class "Extended" calls a ClassMethod on class "Base". The problem is that even after loading and performing a forced compile on b...

How to get the SMTP response in CACHE

Hi friends, I want to retrive the SMTP response after sending the mail. I need to fetch the response for the send mail (whether its send properly or not) The response must be like this Return-path: [email protected] Envelope-to: [email protected] Delivery-date: Fri, 12 Dec 2008 23:54:57 -0500 Received: from pool-98-109-89-94.nwrkn...

Version control for InterSystems Ensemble/Caché

I'm in a group which is starting to develop using InterSystems Ensemble (an integration framework built on top of InterSystems Caché). InterSystems has not made the Ensemble Management Portal source-control-aware and this seems a source of problems for development team we would like to address. I would like to know which version contr...

split string in sql query

I have a value in field called "postingdate" as string in 2009-11-25, 12:42AM IST format, in a table named "Post". I need the query to fetch the details based on date range. I tried the following query, but it throws an error. Please guide me to fix this issue. Thanks in advance. select postingdate from post where TO_DATE(postingDat...

Is learning the Caché database hard coming from relational databases and object oriented programming language like Delphi ?

I am currently running the local version of Caché on my system in order to determine if I can (and will) take on a new possible project. The current project uses Delphi 7 as a front end calling a Caché dll where the business logic is stored in the database. I have a background of Sqlserver and Firebird (and before Access and Paradox) a...

cache in macosx

Hi to all, I installed cache in macos x. But i cant able to open a studio there and i cant able to see cache cube there.How do i will open it and create clasess,routines,...etc in cache in mac osx. ...

SMTP Server Issue in intersystem cache

I am facing an issue when I am sending Email from intersystems cache. I am able to send the mail, with out any problem the first time. But the second time when I am trying to send the smtp server is not responding properly. The first Helo command is sent. I recieve the confirmation 220 from the server. But I do not recieve the Message 25...

Have you used Intersystems Caché? What is your experience?

I came across few claims that usage of CacheDB instead of prooven RDBMS. But I couldn't understand how it is better than RDBMS? if so, why do they prefixed with Cache? Is it RDBMS or Caché server? Could you write brief notes about the use-case in your project? ...

DRIVER={InterSystems ODBC}

We need to access a InterSystems ODBC data source via php. The current default odbc driver is db2. Apache user can access datasource via isql on the command line using /etc/odbc.ini. Does anyone have any recommendations? This is what we have tried: 1) $conn = new PDO("odbc:DI01", "", ""); SQLSTATE[08001] SQLConnect: -1013 [IBM][CLI ...

Caché OREF Error - Getting More Information

I'm am trying to integrate with a Caché Web Service and I'm getting an error message similar to: ERROR #5002: Cache error: <INVALID OREF>zMethodName+45^AA.wsClass.8 I do have have access to the code (albeit just a copy, so read-only), and I'm trying to decipher what the error could be pointing me to. So does the number 45 and/or 8...

Intersystems Caché - Class for Data Encryption

I wonder which class is the class that I use to encrypt data (first time string data) and the best method of encryption (among those supported by caché). Must generate a strong encryption for data in my project. Any help is welcome. If someone can show me some example, I'll be even more grateful. ...

Extracting Cache Process information via SOAP in 2008.2

What is the best way to configure Intersystems Cache 2008.2 so that the Web Service interface could be utilized to export a table consisting of the process information? ...

Shell Scripting and Intersystems Cache: Extracting Information?

I would like to be able to execute a script to draw out the current cache process information. Has anybody done much scripting with cache? Is there an easier way to basically log the process information? The end result of this is I would like to present this information in a way that I could log it into Splunk ...

Intersystems Cache routine to write process information to a file on local system?

I am interested in creating a routine that would query the currently running cache processes and then write this information to a file. How could this be done in Cache 2008.2? ...

Intersystems Cache - How to Enable/Configure Security Services

Looking to create a script that will enable/configure snmp and related settings. Through the web portal it would be placed in: [Home] > [Security Management] > [Services] > Service_Monitor Would like to be able to enable, add allowed IP Addresses, etc. Thank you. ...

Getting the OID or ID of an object through ActiveX in Delphi from InterSystems Cache

Hi I have got the following code in a button on a form, but I want to get the OID or ID value of the saved object so that I can load it directly later. procedure TFormMain.ButtonNewClick(Sender: TObject); var Employee: Variant; OId: Variant; begin Employee := Factory.New('Sample.Employee', True); if VarIsNull(Employee) or VarIs...