I have a HATS Web service application that connects to a single host IP address. I am using connection pooling with the option Only allow single connection with each user ID checked. All this works wonderfully as long as the application is running on a single server. The problem will come when more than one server in an environment is in the picture such as in one of the following situations.
- Running in a cluster of more than one node
- Running in an environment where there are multiple servers in the Development environment, e.g. Development, User Acceptance Test, System Integration Test
The probability that the same user ID will be requested to the host from multiple machines is virtually 100%. This cannot be allowed to happen, so I am creating a connection pool for each server in the configuration and split up the allocated user IDs across the connections so that it is impossible to attempt a connection with the same ID at the same time.
Now my problem:
I have a single SignOn (connect) macro that I want to use on all the connections. However, all my efforts to get the connection to accept the same Signon macro have failed. I can have as many as 12 different connections to manage in this way, so I really do not want to create and maintain multiple copies of the SignOn macro just for this.
I cannot find anything in the InfoCenter on how to do this, or if it is even possible.
Anyone done this before, if so how?