Oracle and many internet posts suggest as the best practice, we should always call close() and dispose() after each database call. My question is if I dispose the connection, which cause the connection to be removed from the pool, with each use, the pooling service have to open a new connection every time when a connection is needed because all used connections are already disposed. This practice seems to contradict the purpose of connection pooling, and results in no pooling. Am I right?
Thanks,
Gary