Re: [sqlalchemy] Bulk Insert Exception Handling

2020-11-23 Thread hara chaitanya
he DBAPI cursor directly as per > https://docs.sqlalchemy.org/en/13/core/connections.html#working-with-raw-dbapi-connections > > . > > On Mon, Nov 23, 2020, at 10:48 AM, hara chaitanya wrote: > > Hello All, > > I am new to using SQLAlchemy. I am trying to insert rec

[sqlalchemy] Bulk Insert Exception Handling

2020-11-23 Thread hara chaitanya
Hello All, I am new to using SQLAlchemy. I am trying to insert records into Oracle table using "session.bulk_save_objects()" method. However it seems if one insert statement fails it would rollback complete transaction. Cx_oracle library helps achieve this by executemany method with batching