How to close a DB connection in Python written using %sql

Question

I am using the %sql commands in Python to connect to Db2. The connection was established, however .close() function doesn't work to close such connection. What query can be used to check the status of the connection and close the connection afterwards?

The below code was used to establish the connection.

!pip install --force-reinstall ibm_db==3.1.0 ibm_db_sa==0.3.3
!pip uninstall sqlalchemy==1.4 -y && pip install sqlalchemy==1.3.24
!pip install ipython-sql

%load_ext sql

%sql ibm_db_sa://my-username:my-password@hostname:port/BLUDB?security=SSL

data_henrik · Accepted Answer · 2022-01-13 20:33:35Z

2

You can list all active connections and close them, see the options for the ipython-sql module.

%sql -l

%sql -x yourSession

answered Jan 13, 2022 at 20:33

data_henrik

17.3k2 gold badges33 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to close a DB connection in Python written using %sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related