Assume that we get database connection from datasource pool in
jdbc. If we dont close the connection that connection
will be lying there as it is and consider as connection leak and will not return to pool. But if we close the connection that connection will
move back to pool , Is this correct?
Secone question is we always say connection is expensive and scarce reasource. Can't we get connection for every request
even if we dont close some of the connections in between(i mean some connection leaks exists)?Is there a maximum limit of connection production
on database server ?