Using a specific connection for an update

Data Abstract
#1

Hi,

Our server application is currently using connection pooling which works fine, however we have a scenario where, for reasons I won’t go into, we need to perform a specific update on a separate, dedicated connection that isn’t part of the existing pool and which would be freed immediately after and not used for anything else.

Is this possible at all?
Thanks.

#2

Hi,

In general, you can do:

  • create ConnectionManager on fly
  • switch to it
  • create a new connection
  • do your operation
  • revert back to default ConnectionManager.