Fallback by thick mode

[end1ess1]

1. What versions are you using?

Oracle 12

platform.platform: Windows-10-10.0.19043-SP0 sys.maxsize > 2**32: True platform.python_version: 3.12.2 oracledb.version: 2.1.0

2. Is it an error or a hang or a crash?

Crash

3. What error(s) or behavior you are seeing?

DPY-2019: python-oracledb thick mode cannot be used because a thin mode connection has already been created

4. Does your application call init_oracle_client()?

Yes. Im trying to use thin mode first and switch to thick when the database is incompatible

5. Include a runnable Python script that shows the problem.

import asyncio import oracledb from data import client_path,user,password,dsn

async def main(): oracledb.init_oracle_client(lib_dir=client_path) async with oracledb.connect_async(user=user, password=password, dsn=dsn) as connection: with connection.cursor() as cursor: await cursor.execute("select user from dual") async for result in cursor: print(result)

asyncio.run(main())

I saw that you have already solved the problem, it works with connect(), and with async_connect() doesn't work

[anthony-tuininga]

This is not a bug! The use of asyncio mandates thin mode. You cannot fall back to thick mode in that case. You will need to use the regular synchronous approach if you want to fall back to thick mode when connecting to an incompatible database.

[cjbj]

Closing - this has a straightforward answer.