Session object is a wrapper over the Database connection. The general understanding is that the connection gets established when the session object is created.
But the actual connection gets established only when the begin transaction request is made.