Pandas to_sql creating table but not inserting data

Question

I am using Oracle, and I am seeing the table created in the schema (albeit all with CLOB columns for VARCHARs). But no data is being inserted? The dataframe does have data in it.

engine = create_engine('oracle+cx_oracle://user:password@host:1521/?service_name=myservice', max_identifier_length=128)
df = get_registrations()
df.to_sql(name='pandas_registrations', con=engine, if_exists='replace', chunksize=1000, schema='ANALYTICS', method=None)

I read a commit() is not needed here Does the Pandas DataFrame.to_sql() function require a subsequent commit()?

Well I got it working without con.commit(). I had to replace clobs and set autocommit on the connection. None of which was described in any examples. I am not sure which one solved the problem to be honest. — smackenzie
– smackenzie, Commented Dec 4, 2021 at 12:18
Apparently commit is not needed stackoverflow.com/questions/47741775/… — smackenzie
– smackenzie, Commented Dec 4, 2021 at 12:21

mr_develop · Accepted Answer · 2021-12-03 19:30:03Z

0

I encountered similar problem and switching to sqlalchemy instead of cx_Oracle as the engine helped in my scenario.

answered Dec 3, 2021 at 19:30

mr_develop

1774 bronze badges

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

3 Comments

smackenzie Over a year ago

I am using sqlalchemy create_engine, just with the oracle driver?

Christopher Jones Over a year ago

SQLAlchemy uses cx_Oracle!

smackenzie Over a year ago

So what would my driver string look like?

Collectives™ on Stack Overflow

Pandas to_sql creating table but not inserting data

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related