'OracleCursor' object has no attribute 'cursor' with cx_Oracle and sqlalchemy '0.6beta1'
Issue #1609
resolved
I retrieved this version from svn , r6484.
This is on a Windows XP box. I'm using ActiveState Python 2.6.1.1, cx_Oracle 5.0.2-10g, Oracle client libraries 10.2.0.4.0, and an Oracle database also 10.2.0.4.0.
When running this script:
import sqlalchemy as sa
connect_url ='oracle://<user>@<instance>'
password = '<password>'
engine = sa.create_engine(connect_url, connect_args={'password':password})
conn = engine.connect()
I get this traceback:
Traceback (most recent call last):
File "satest.py", line 7, in <module>
conn = engine.connect()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 1420, in connect
return self.Connection(self, **kwargs)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 699, in __init__
self.__connection = connection or engine.raw_connection()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 1470, in raw_connection
return self.pool.unique_connection()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 120, in unique_connection
return _ConnectionFairy(self).checkout()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 313, in __init__
rec = self._connection_record = pool.get()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 162, in get
return self.do_get()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 651, in do_get
con = self.create_connection()
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 123, in create_connection
return _ConnectionRecord(self)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\pool.py", line 203, in __init__
l.first_connect(self.connection, self)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\strategies.py", line 136, in first_connect
dialect.initialize(c)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\dialects\oracle\base.py", line 522, in initialize
super(OracleDialect, self).initialize(connection)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\default.py", line 109, in initialize
self.default_schema_name = self._get_default_schema_name(connection)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\dialects\oracle\base.py", line 566, in _get_default_schema_name
return self.normalize_name(connection.execute('SELECT USER FROM DUAL').scalar())
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 991, in execute
return Connection.executors[c](c)(self, object, multiparams, params)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 1066, in _execute_text
context = self.__create_execution_context(statement=statement, parameters=parameters)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\base.py", line 1126, in __create_execution_context
return dialect.execution_ctx_cls(dialect, connection=self, **kwargs)
File "C:\opt\python26\Lib\site-packages\sqlalchemy\engine\default.py", line 284, in __init__
self.cursor = self.create_cursor()
File "c:\opt\python26\lib\site-packages\sqlalchemy\dialects\oracle\cx_oracle.py", line 237, in create_cursor
c.cursor.arraysize = self.dialect.arraysize
AttributeError: 'OracleCursor' object has no attribute 'cursor'
Comments (4)
-
Account Deleted -
repo owner -
Account Deleted Awesome! That works great. Thanks for the amazingly quick response.
-
repo owner - removed milestone
Removing milestone: 0.6.0 (automated comment)
- Log in to comment
I forgot to mention this works without error on sqlalchemy 0.5.3.