How is the connection to the database organized in a multi-threaded java servlet environment?

Question

Java

Each time a request is made to the servlet, a new thread is created for the client. If a connection to the database is made in the servlet, then for each client a new connection will be created, that is, for each thread, a separate connection?

Answer 1

In theory, connections to the database should already be created in advance. There is such a thing as Connection Pool - a set of already open connections. When the servlet needed to access the database, a connection is taken from this pool, and the servlet works with it, and as soon as the servlet no longer needs the base, it must release the connection (return it to the pool). If there are a lot of requests, and there are not enough connections, then the servlet suspends work until a free connection appears in the pool. It's in a nutshell.
You can read a short article or search online.