Connect to Oracle error about sqlbucket HOT 6 CLOSED

@qiuqiuqiuqiuqiuqiu
SQLbucket uses SQLAlchemy under the hood, and Oracle can definitely work with it, so you should be able to use Oracle for sure. I set AUTOCOMMIT as default some time ago though but realized this isolation level is definitely not valid for most databases... so this needs to be changed for sure.

I should be able to do a hotfix in the next few days though. Would you like control on the isolation level to use and have it as a parameter?

from sqlbucket.

@philippe2803
Thank you very much for quick response.
Sure, have isolation level as a parameter with default value is a good choice.

Regards Qiu

from sqlbucket.

Made a PR yesterday. This is being reviewed as we speak: #25

from sqlbucket.

Hi @philippe2803

How should I configure the connection for oracle db after the change.
I configured the connection to oracle db as below.
connections = { 'db_zx': 'oracle+cx_oracle://xxxxxxx:[email protected]:1521/somedb?isolation_level=READ COMMITTED' }
Still got the error
TypeError: Invalid argument(s) 'isolation_level' sent to create_engine(), using configuration OracleDialect_cx_oracle/NullPool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

Regards Qiu

from sqlbucket.

@qiuqiuqiuqiuqiuqiu
The library is not updated yet with the changes. It should be at some point this week. In the meantime, you could try with the current development package. You just need to uninstall sqlbucket and re-install a dev package that I created for test purposes.

pip uninstall sqlbucket
pip install sqlbucket==0.3.3.dev3

READ COMMITTED is the default isolation level for oracle, and therefore will be the one applied by default. So, in your case, you won't need to set isolation level anymore.

from sqlbucket.

closing as this has been sorted.

from sqlbucket.