JIMSMITH

Please delete this message. Problem solved

Okay. I do create them and can get a connection from a pool. I assume that a criticalsection is not required if doing this.

When accessing executing dbqueries using tFDQuert components in a tidtcpserver event should a tcriticalsection?

Remy are there any good articles on the TIdContext and the TIdServerContext and how to use them and when to use one over the other properly? Thanks in advance.

I am starting to work on this. I always have a high level of confidence in your responses on any topic. Thank you very much.

I want to create a server application that can handle multiple connections, even from the same computer. An important point is that if the client application disconnects from the server I need to be able to reconnect the application to the object in the server for continuity. I can handle the reconnect, I think, but need some assistance in associating the the context with the context or object from the original connection. When does the context get destroyed. Many question and I need help finding answers. Seems like I would have to keep a token or something to send to the server to recognize the repetitious connection for each application connected to the server. Am I correct in this assumption? I wonder how I know the connection that was disconnected if the network connection drops. Should I launch an anonymous thread to read and process the message from the execute event on the server? I am continuing m investigation.

You are correct. This is what I am about to correct. I am getting some good clues from these responses. A response could be sent to the client in xml with Success or fail. Success would have the data and fail would have the extended error details. In the case of the ssl failure trapping the message and logging it to a file on the server and then sending the XML with failure would normally work, but this was a failure on connection so there might not be a client to respond to. Just log it on the server when capturing via the exception handler and just move on so the next client communication happens. This might be what I am looking for.

This is a simple case where the 2 .dll files were not with the executable. The problem was not with the indy components either. The key information that I am looking for is how to manage the middle tier so that when any type of exception happens that the middle tier sends the exception to the client and continues to process other connections. Yes I can do this in the application using try finally and try except blocks. Just not sure how to implement this in a middle tier where I want the exception to be passed back to the client.

I use indy tidtcpserver and client. The other day I had a computer that did not have ssl .dll files which resulted in exception in the middle tier. All processing was disrupted. I just need to send exception back to that client connection and allow the other connections continue to process.

I tried to use Remobjects many years ago. Wasn't much documenrtation or many examples. Any questions took several days to get answers. Anyway I wonder how they handle exceptions so that other users continue to process without disruption..

I have an application that connects a middle tier application that I created all using VCL windows. The middle tier application is accessed VIA tcp using Indy. The client application from many computers can access the middle tier at the same time. The problem I have is how do I harden the middle tier so that if an exception happens the entire middle tier is not hung. I do want the exception message to go back to the respective client, but I need the middle tier to be able to continue processing requests from other users.

Thanks for the information. An interesting read.

Apologies. There are supposed to be commas. I have added. Thanks. I made manual changes to for illustration purposes and make my 1st mistake.

Given the JSON object below. I want to update the value of a JSON Pair. Here are a few questions - 1) Is there a fast way to find the JSON details for fiddler@office365.com. Do I have to loop through the each of the 4 entries. and check the value. 2) I want to update the new_token value from "rice" to "beans". 3) How do I add a new pair after "current_token". - This is last because I can probably figure #3 it out for myself. Help is much appreciaded in advance. { "SPWORKDATA": { "DB_PARAMS": { "DriverID":"Oracle", "Port":"9060", "Monitorby":"", "MetaDefSchema":"False" }, "MAILCONFIGS": [ {"sole.heel@apple.com": { "clickid": "307663883943-8", "social": "weeklyreader", "account": "rick.flair@gmail.com", "new_token":"", "current_token":"1//0f1U7S6-TZ-_r6RtWc" } }, {"timmona@office365.com": { "clickid": "client_data2", "secret": "appsecret", "social": "timmon.ray@office365.com", "new_token":"scacral", "current_token":"refreshtoken" } }, {"bruce@office365.com": { "clickid": "client_data2", "secret": "appsecret", "social": "bruce.richards@office365.com", "new_token":"soapl", "current_token":"refreen" } }, {"fiddler@office365.com": { "clickid": "client_d89", "secret": "appsoul", "social": "karen.richards@office365.com", "new_token":"rice", "current_token":"old" } } ], "MEDIASERVER": { "Server": "192.162.2.185" }, "MSGSERVER": { "Server": "127.0.0.1", "Port":"55555" } }

I am using Delphi 10.1 update2. When processing a json file I cannot find the containskey method with a TJSONObject? Is there a work around to the the equivalent check JSONObject.containskey('keyvalue') for this version of Delphi?