Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread jose soares
Michael Bayer wrote: On Dec 17, 2011, at 1:52 AM, jo wrote: create_engine(oracle://user:password@SHELL) could you tell me how it becomes in sqlalchemy.dburi on tg prod.cfg ? sqlalchemy.dburi=oracle://username:password@host:port/service_name I tried in this way:

Re: [sqlalchemy] performance vs. psycopg2

2011-12-19 Thread Gaëtan de Menten
On Fri, Dec 16, 2011 at 15:58, Jon Nelson jnel...@jamponi.net wrote: Revised to use: for row in rows:  dict(row) # throw away result  count += 1 I wonder how this could even work... iterating over the row yields individual values, not tuples?! I wonder what kind of column types you are

[sqlalchemy] Re: Error after upgrading from v0.6.6 to 0.7.4

2011-12-19 Thread useher
Hi! Sorry for the late answer. I got it now: There was a relation called 'status' in the parent class and a function called status() in the derived class. After renaming the function everything seems to work correct. So the error does not belong to sqlalchemy, but concerns some bad coding by

[sqlalchemy] Re: Error after upgrading from v0.6.6 to 0.7.4

2011-12-19 Thread useher
Hi! Sorry for the late answer. I got it now: There was a relation called 'status' in the parent class and a function called status() in the derived class. After renaming the function everything seems to work correct. So the error does not belong to sqlalchemy, but concerns some bad coding by

Re: [sqlalchemy] How to work with python3.2 and mysql?

2011-12-19 Thread Florent Angebault
Le 18/12/2011 19:07, Michael Bayer a écrit : On Dec 18, 2011, at 6:29 AM, Florent Angebault wrote: Hello. I tried many different configurations to connect to mysql5 server using python3.2 and sqlalchemy 0.7.4 but couldn't have success. I always end with an error due to the fact that some

Re: [sqlalchemy] Re: Error after upgrading from v0.6.6 to 0.7.4

2011-12-19 Thread Michael Bayer
On Dec 19, 2011, at 5:03 AM, useher wrote: Hi! Sorry for the late answer. I got it now: There was a relation called 'status' in the parent class and a function called status() in the derived class. After renaming the function everything seems to work correct. So the error does not belong

Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread jose soares
Michael Bayer wrote: On Dec 19, 2011, at 3:28 AM, jose soares wrote: I tried as you said Michael and this is the error message: sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12154: TNS:could not resolve the connect identifier specified I tried like so:

Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread Michael Bayer
On Dec 19, 2011, at 10:17 AM, jose soares wrote: Michael Bayer wrote: On Dec 19, 2011, at 3:28 AM, jose soares wrote: I tried as you said Michael and this is the error message: sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12154: TNS:could not resolve the connect identifier

Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread jose soares
Michael Bayer wrote: On Dec 19, 2011, at 10:17 AM, jose soares wrote: Michael Bayer wrote: On Dec 19, 2011, at 3:28 AM, jose soares wrote: I tried as you said Michael and this is the error message: sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12154: TNS:could not

Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread Michael Bayer
On Dec 19, 2011, at 10:43 AM, jose soares wrote: this is my tnsnames.ora: # tnsnames.ora Network Configuration File: /usr/share/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SICER = (ADDRESS = (PROTOCOL =

Re: [sqlalchemy] sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

2011-12-19 Thread jose soares
Michael Bayer wrote: On Dec 19, 2011, at 10:43 AM, jose soares wrote: this is my tnsnames.ora: # tnsnames.ora Network Configuration File: /usr/share/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SICER = (ADDRESS =

[sqlalchemy] help decrypting exception re session management error?

2011-12-19 Thread Iain Duncan
Ok, I know this is my fault but maybe someone can help me know what kind of error I'm producing here, in saving a user, I'm getting the following expection, but only occasionally ( like 10% of the time? ) 15:13:18,160 INFO [xornot.dram.views] EditAction.post() Exception from self.update: Can't