[FIXED] 'DB2ExecutionContext_ibm_db' object has no attribute 'compiled_parameters'

Issue

I ran into a problem while querying on ibm-db2 cloud.

I checked the db connection. The connection is okay but whenever I try to query something (anything) it gives me this error.

'DB2ExecutionContext_ibm_db' object has no attribute 'compiled_parameters'

a snapshot of the error -

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-22-ec7ae9958cc4> in <module>
......
......

~/conda/envs/python/lib/python3.6/site-packages/ibm_db_sa/ibm_db.py in pre_exec(self)
     47     def pre_exec(self):
     48         # if a single execute, check for outparams
---> 49         if len(self.compiled_parameters) == 1:
     50             for bindparam in self.compiled.binds.values():
     51                 if bindparam.isoutparam:

AttributeError: 'DB2ExecutionContext_ibm_db' object has no attribute 'compiled_parameters'

Any solution ?

Solution

you could check for these installment if you haven't

!pip install sqlalchemy==1.3.9

!pip install ibm_db_sa

I got the same error and this helps

Answered By - Sylnia