Thank you so much for your advice Michael.
I'm switching to python 2 right now.
Regards,

-----Message d'origine----- From: Michael Bayer
Sent: Sunday, March 27, 2011 3:44 AM
To: [email protected]
Subject: Re: [sqlalchemy] cannot import name cx_oracle


On Mar 26, 2011, at 6:54 PM, tanc wrote:

Hi there,
Im new to sqlalchemy, be kind and gentle :)
Using sqlalchemy 0.6.6 and the last stable cx_Oracle.pyd on my windows
pc.
OracleXE 10g is installed locally.

Processing the following code, gives me the error
ImportError: cannot import name cx_Oracle

import sqlalchemy

sqlalchemy.create_engine('oracle://hr:hr@XE')
connection = oracle_db.connect()
result = connection.execute("select employee_id,first_name,last_name
from Employees")
for row in result:
   print (row)
connection.close()

This sound to be launched by the following code within cx_oracle

   def dbapi(cls):
       from . import cx_Oracle
       return cx_Oracle

Tried to fix without success.
Calling similar code from cx_Oracle is running fine.
Can someone point me on the right direction ?
Regards,

One aspect may be that the SQLAlchemy Oracle dialect has never been tested with Python 3 and likely has a lot of issues. I know you're using Python 3 due to the relative import in the code snippet you're attaching (a very important detail).

I'd strongly advise you stick with Python 2 until library maintainers have finished getting their act together. We're mostly getting much closer, but its still kind of early for end users.




--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.


--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to