Hi all, I'm new to SQLAlchemy, and I've a problem using it.
[tu...@2kan-2:~/bigur/calculation]%
python
Python 2.5.2 (r252:60911, Feb 23 2009, 21:22:55)
[GCC 4.0.1 (Apple Inc. build 5488)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> from sqlalchemy import *
>>> db =
>>> create_engine('mssql://some_name:some_passwpod@/?dsn=Libra&driver=FreeTDS')
>>> metadata = MetaData()
>>> metadata.bind = db
>>> metadata.bind.echo = True
>>> users_table = Table('tax', metadata, autoload=True)
2009-02-24 20:54:55,261 INFO sqlalchemy.engine.base.Engine.0x...2850
SELECT user_name() as user_name;
2009-02-24 20:54:55,261 INFO sqlalchemy.engine.base.Engine.0x...2850
[]
2009-02-24 20:54:55,280 WARNING sqlalchemy.pool.QueuePool.0x...27b0
Error closing cursor: Attempt to use a closed cursor.
2009-02-24 20:54:55,280 INFO sqlalchemy.engine.base.Engine.0x...2850
ROLLBACK
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/schema.py", line 113,
in __call__
return type.__call__(self, name, metadata, *args, **kwargs)
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/schema.py", line 241,
in __init__
_bind_or_error(metadata).reflecttable(self,
include_columns=include_columns)
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
1265, in reflecttable
self.dialect.reflecttable(conn, table, include_columns)
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/databases/mssql.py",
line 1123, in reflecttable
current_schema = self.get_default_schema_name(connection)
File "<string>", line 1, in <lambda>
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
1894, in decorated
connection.info[key] = val = fn(self, connection)
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/databases/mssql.py",
line 1070, in get_default_schema_name
user_name = connection.scalar(sql.text(query))
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
814, in scalar
return self.execute(object, *multiparams, **params).scalar()
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
1676, in scalar
self.connection._handle_dbapi_exception(e, None, None,
self.cursor, self.context)
File "/opt/local/lib/python2.5/site-packages/
SQLAlchemy-0.5.3dev_r5814-py2.5.egg/sqlalchemy/engine/base.py", line
931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) Attempt to use a
closed cursor. None None
What I'm doing wrong?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
