Using a specific connection for an update


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?


In general, you can do:

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