go to post David Hockenbroch · Feb 28, 2022 Unless I'm setting type=1, I do need the user's password still to do this, right?
go to post David Hockenbroch · Feb 18, 2022 Here's how I've been doing this: //Read in content from the HttpRequest set req = %request.Content.Read() //Convert content from JSON to a dynamic object set reqObj = {}.%FromJSON(req) //Access data from within the new dynamic object set userName = reqObj.%Get("UserName")
go to post David Hockenbroch · Feb 11, 2022 Eduard, can't the MAXSTRING one also mean that you've exceeded a specified MAXLEN parameter on a string? Like if I have a Property LastName As %String (MAXLEN = 30) and you try to save the object with a 50 character last name, doesn't that also give a "MAXSTRING" error?
go to post David Hockenbroch · Feb 8, 2022 Why not do this? set rset1 = ##class(%ResultSet).%New() set query = "Select statment" set sc = rset1.Prepare(query) set:+sc sc = rset1.Execute(parm1, parm2) set ^sql = query
go to post David Hockenbroch · Feb 7, 2022 Have you checked the security settings for the user you're logging in as? You should have %Developer and %DB_USER, I think. Or if you have %All, that works too.
go to post David Hockenbroch · Feb 1, 2022 Are you trying for the Cache driver, or the IRIS driver? I'm pretty sure the 3.0.0 jar you're using is an IRIS driver, and in that case, the driver is com.intersystems.jdbc.IRISDriver, not com.intersys.jdbc.CacheDriver (note that in that transition, the beginning of the package changed from com.intersys to com.intersystems.)
go to post David Hockenbroch · Jan 17, 2022 I've never done that, but if you add it as a menu item, can you then go to View -> Toolbars -> Customize and find it in the commands tab? And if so, can you drag it to the toolbar you want it on from there?
go to post David Hockenbroch · Jan 12, 2022 Depending on your needs, you might consider creating a class that extends both %Net.HttpRequest and %JSON.Adaptor and using the %JSON.Adaptor methods to create a JSON representation of the instance. That would be easier to analyze.
go to post David Hockenbroch · Jan 11, 2022 Your result.HttpResponse.Data can be either a string or a stream object. If it's a stream object you'll have to handle it a little bit differently using result.HttpResponse.Data.Read(): set response=result.HttpResponse.Data.Read() while 'result.HttpResponse.Data.AtEnd{ set response = response_result.HttpResponse.Data.Read() }
go to post David Hockenbroch · Jan 7, 2022 This is a long shot, but is the ODBC connection defined in User DSN or System DSN? We had an issue after a recent round of Windows updates where Excel suddenly wasn't always correctly seeing the System DSN connection, and setting it up under User DSN instead resolved that issue.
go to post David Hockenbroch · Jan 7, 2022 Here is some useful documentation. You're going to want to make a class that extends %CSP.REST and set up an application that uses that class as its dispatch class. You'll have a URL map in that class to tell IRIS or Cache what to do with the request. Depending on your specific application, you might also want to get familiar with using %request and %response in that process.
go to post David Hockenbroch · Dec 22, 2021 If you're using the IRIS ODBC driver, try switching to the IRIS ODBC35 driver. This kind of error may mean that the application is expecting the driver to do some ODBC 3.x stuff that the older driver might not be capable of.
go to post David Hockenbroch · Dec 22, 2021 The ones in italics are the ones that are a part of your current project. If you click on the Project tab, they'll show up there too.
go to post David Hockenbroch · Dec 13, 2021 You can also open your log4j.jar as you would a zip file, go to the META-INF folder, open MANIFEST.MF and look for "Implementation-Version" to see which version of log4j it is.
go to post David Hockenbroch · Dec 3, 2021 In your class definition, if you wanted a maximum length of 1000 as an example, you would define your string as: Property mystring As %String (MAXLEN = 1000); But as Robert has already pointed out, if you're dealing with something very large, it's better to use some sort of %Stream instead.
go to post David Hockenbroch · Dec 2, 2021 If I try to replicate some of these steps in my instance of Cache 2016, I get an error at: Set httpRequest.Https = $$$YES Does it make a difference if you try: Set httpRequest.Https = 1
go to post David Hockenbroch · Dec 1, 2021 ..Adapter.SSLConfig should get you the name of the SSL Configuration that the adapter is using. The property of the %Net.HttpRequest is called SSLConfiguration. So it should be: set httpRequest.SSLConfiguration = ..Adapter.SSLConfig
go to post David Hockenbroch · Nov 29, 2021 You can use $ZSTRIP for this, in your case: $ZSTRIP("Happy new year ","<>W")
go to post David Hockenbroch · Nov 23, 2021 In that case, does it meet your needs to make it a list of %String instead of making a separate class?
go to post David Hockenbroch · Nov 23, 2021 When you're projecting a list of a class to XML, you usually have a parent element for each of those objects, then a separate element for each of it's properties. So I think what you'd need to do would be something more like: <Results> <PersonIDs> <PersonID> <PersonID>1000000</PersonID> </PersonID> <PersonID> <PersonID>1000001</PersonID> </PersonID> <PersonID> <PersonID>1000005</PersonID> </PersonID> </PersonIDs> </Results> So that the outer PersonID element indicates your PersonID object, and the PersonID inside of that is the PersonID property of that object.
