Stuart Clennett

Hi, I can see the MARS.OpenAPI.* units exist but I'm really not sure how to use them. I have a MARS server app and would like to provide OpenAPI JSON for consumption by other utils, like Swagger. 1. How do I set this up at the 'engine/application level, and 2. How do I provide the documentation for each resource/endpoint ? Thanks in advance.

Neither in this case, I have done multi-tenancy before.

Hi mvanrijnen Thanks very much - that's a great idea. The FD instance is declared as `[Context] FD : TMarsFireDAC` in the Resource I assume. I have a TBaseResource that all other resources inherit from (apart from Token) - so this will be easy to implement 🙂 For connection pooling do I need to use FD.ConnectionDefName as I am loading FireDAC.MAIN_DB into the FDManager at start up (as per the MARSTemplate ), or will FD.Connection also provide pooling? Thanks, (it's been a while since I've done _any_ DB programming at all)

Hi Andrea, Sorry, it seems that I had this project from a while ago and I thought the server pooling was part of the template - my mistake. I am getting a little confused on how to set up a data module (created per request of course) that can pool connections, and respond to various end-points. I have the data-module already (inherits from TMARSFDDataModuleResource) and has most of my TFDQueries on there. I just need to have an instance created per endpoint request. Seems simple, but I can't figure it out. Is there a more comprehensive example somewhere? I see in the INI file created that we have FireDAC.MAIN_DB items commented out. Thanks Stuart

I have attached an image which may explain better. This is from the latest MARS Template; there is a ServerConnectionPool (TDataModule) that has a TFDConnection and is auto-created. There is a ServerMainDB TDataModule that contains an FDQuery; this datamodule is created once per request by each endpoint that needs it. I have just noticed that the FDQuery is attached to the TFDConnection at designtime, so maybe that is sufficient? Maybe I have overlooked the obvious.

Hello all, I am returning to MARS after some years away. I noticed that the new template application has a ServerConnectionPool data module. Has anyone implemented connection pooling with a single, central datamodule and FDConnection, with a separate TDataModule for handling requests? If so, could someone give me a heads up on the best ways to set up the initial TFDConnection component on the connection-pool datamodule and how to connect this to my queries in the request handling datamodule? Thanks Stuart

Thanks Patrick - that would be useful.

SOLVED My VM had an out of date Windows 11 installation (22H2), with no TPM module enabled. I created a fresh VM and installed the latest Win 11 Pro and the installation has gone through.

I've tried both Web and ISO installer. Win 11 VM (fresh install) with over 200Gb free on C drive. Windows defender turned off. Installers run as Admin. Installing for Windows development only (no iOS, Mac, Android or Linux). The installer gets about 50% of the way through and stops with this: The file is present and is not locked. Pressing Try Again immediately shows the same dialog. There was one attempt I made which I thought was working, but then stopped with the same message, but a different file: "LinuxPAServer23.0.tar.gz". When I press Cancel, this is the message I see: The retry option goes back to the start and eventually I get the same error message. Anyone got any ideas? Thanks.

Thanks Andrea - I'll look into that.

Hi @Andrea Magni I implemented it using a simple base64 encoded string. Is there any benefit to using TStringWriter given that I may need the API to support web front ends written in a JS framework like Angular ? Thanks

HI, [Context] Request: TWebRequest; should be changed to [Context] Request: IMARSRequest; you'll need to include MARS.Core.RequestAndResponse.Interfaces in your uses clause. Regards

Hi, I am auto-renewing the JWT token on the server (as per the TokenAutoRenew demo). Having received the JWT token string from the server how do I update the client MARSToken with that value. The properties are read-only. Thanks

So I'm back to this. I'm currently thinking of using Data-URLs to get the base64 image data and embed direcly into the Angular client app. (ref: https://css-tricks.com/data-uris/ & https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/Data_URIs) Note that with the above TBytes solution I seem to get the response "[255, 0, 255, 0, 45, 56, 67 ..... ]" as text rather than raw bytes. The end point has the response type set as 'image/jpeg'

Hi, Not sure if I'm on the right track here. I have a legacy database that has some images stored in blob fields in the database (I know). I'd like to be able to expose these images directly from the REST API, e.g. localhost:8080/rest/default/images/{id} I guess I have to set the Produces attribute to `image/jpeg` .. but what data type should I return? I've tried TBytes but although I get the bytes returned in Postman - web browsers don't load the image. Thanks