python oracle 匹配字符串,python cx oracle期望字符串,unicode或缓冲区对象

我试图在python中运行以下代码段以连接到oracle,但是经常遇到以下错误.我尝试了很多组合,但似乎不起作用.我了解该错误,但不了解这里有什么不兼容的地方.

有人遇到过这个问题吗？我如何解决它？

在执行中的文件“ /workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py”中的文件“”,行1,第1613行

connection = self.contextual_connect(close_with_result=True) File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1661, in contextual_connect

self.pool.connect(), File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 326, in connect

return _ConnectionFairy(self).checkout() File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 485, in __init__

rec = self._connection_record = pool._do_get() File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 770, in _do_get

return self._create_connection() File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 279, in _create_connection

return _ConnectionRecord(self) File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 372, in __init__

self.connection = self.__connect() File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/pool.py", line 433, in __connect

connection = self.__pool._creator() File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 80, in connect

return dialect.connect(*cargs, **cparams) File "/workplace/applications/python2.7/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 283, in connect

return self.dbapi.connect(*cargs, **cparams)

TypeError: expecting string, unicode or buffer object

from sqlalchemy.ext.declarative import declarative_base;

from sqlalchemy import create_engine;

engine = create_engine(u'oracle+cx_oracle://localhost:1521/orcl', echo=True)

result = engine.execute(u"select 1 from dual");

设定：

Python 2.7

SqlAlchemy 0.9.7和0.8.7

Cx Oracle(最新版本)

Oracle数据库10g版本10.2.0.2.0