Stuart Clennett

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

@alejandro The demo does not save the file at all. You are required to implement that. However it is quite simple. For example, in the `StoreDataAndFile` method in `Server.Resources.pas` you could use a memory stream to access the Bytes and save to a file if SameText(LParam.FieldName, 'image') and LParam.IsFile then begin Result.FileSize := Length(LParam.AsFile.Bytes); Result.FileName := LParam.AsFile.FileName; // This will save the file lStream := TMemoryStream.Create; try lStream.Write(LParam.AsFile.Bytes, Length(LParam.AsFile.Bytes)); lStream.SaveToFile(TPath.Combine(C_RootPath, TPath.GetFileName(LParam.AsFile.FileName))); finally lStream.free; end; end In this instance, `C_RootPath` is just a folder on the server where uploaded files should be saved, but you could make this dynamic based on user info in the Token for example. Hope this helps

Excellent news & thanks for the merge.

Thanks @Andrea Magni - I spotted the difference immediately after posting my question. Just going through and updating my servers now. Hope you're all safe & well.

FIXED. The function signature now uses IMARSResponse and IMARSRequest from MARS.Core.ResponseAndRequest.Interfaces D'oh 🙂