79713827

Date: 2025-07-24 18:41:16
Score: 0.5
Natty:
Report link

Could this be because it's being raised as a SQLAlchemy DatabaseError, not directly as an cx_Oracle DatabaseError so you fail to catch it properly? You say it won't catch it but it would be good to validate at which stage it does get reported when you specify like this..

from my_DB_connector_wrapper import oracle
from tqdm import tqdm
from cx_Oracle import DatabaseError
from sqlalchemy.exc import DatabaseError as SQLAlchemyDatabaseError

aliases = ['I_CAN_CONNECT','I_CAN_NOT_CONNECT']

for i in tqdm(aliases, total=len(aliases)):
    try:
        oracle.connect_kerberos(i)
        tqdm.write('ok')
    except SQLAlchemyDatabaseError as e:
        tqdm.write(f'SQLAlchemy Database Error for {i}: {str(e)}')
        pass
    except DatabaseError as e:
        tqdm.write(f'cx_Oracle Database Error for {i}: {str(e)}')
        pass
    except Exception as e:
        tqdm.write(f'Unexpected error for {i}: {str(e)}')
        pass
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: SteWood