'OracleCursor' object has no attribute 'cursor' with cx_Oracle and sqlalchemy '0.6beta1'

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'

When running this script:

Comments (4)