A method in a computer system, the method comprising: establishing a first database session with a database system, wherein establishing the first database session comprises reading, by the computer system default session information; communicating non-default session information other than the default session information from the computer system to the database system, which defines a session context of the first database session; caching the non-default session information for the first database session in a cache memory of the computer system; setting a session flag to indicate that non-default session information has been cached; and establishing a second database session in response to detecting a disconnection of the first database session, including: determining that non-default session information has been cached based on the session flag; and communicating the non-default session information that is cached in the cache memory of the computer system for the first database session to transparently restore the session context of the first database session; wherein: the cache memory is structured as a [key, value] storage, where the key identifies a session attribute and the value is session data to be cached; and if the key is not found in the cache memory, a new entry is added to the cache memory, otherwise the existing entry is updated with the latest value. establishing a first database session with a database system, wherein establishing the first database session comprises reading, by the computer system default session information; communicating non-default session information other than the default session information from the computer system to the database system, which defines a session context of the first database session; caching the non-default session information for the first database session in a cache memory of the computer system; setting a session flag to indicate that non-default session information has been cached; and establishing a second database session in response to detecting a disconnection of the first database session, including: determining that non-default session information has been cached based on the session flag; and communicating the non-default session information that is cached in the cache memory of the computer system for the first database session to transparently restore the session context of the first database session; determining that non-default session information has been cached based on the session flag; and communicating the non-default session information that is cached in the cache memory of the computer system for the first database session to transparently restore the session context of the first database session; wherein: the cache memory is structured as a [key, value] storage, where the key identifies a session attribute and the value is session data to be cached; and if the key is not found in the cache memory, a new entry is added to the cache memory, otherwise the existing entry is updated with the latest value. the cache memory is structured as a [key, value] storage, where the key identifies a session attribute and the value is session data to be cached; and if the key is not found in the cache memory, a new entry is added to the cache memory, otherwise the existing entry is updated with the latest value.