Keep database connection on connecting to MySQL/MariaDB using SQLAlchemy

You want the database connection will be keep on connect to MySQL/MariaDB, just use pool_recycle parameter in method create_engine(). Example: create_engine(db_url, pool_recycle=1) pool_recycle this setting causes the pool to recycle connections after the given number of seconds has passed. It defaults to -1, or no timeout. For example, setting to 3600 means connections will be… Read More Keep database connection on connecting to MySQL/MariaDB using SQLAlchemy

How to do when Oracle Vendor Code 28001

Open SQL Developer and perform the following steps: Right click on Connections > New Connection. Connection Name: sys Username: sys as sysdba Password: sys (or your sys password) Hostname: your database server IP Port: 1521 SID: your sid Click connect. Expand Other Users, and choose the user with the expired password. Right click on the… Read More How to do when Oracle Vendor Code 28001