On Jul 31, 2010, at 3:46 PM, maxi wrote:
> Hi,
>
> I'm trying to use SqlSoup with firebird backed.
> My environment is: python 2.6, sqlalchemy 0.6.3 all in virtualenv.
> The firebird version is 2.1
>
> I do all steps to do a simple test:
>
> db = SqlSoup('firebird://SYSDBA:master...@127.0.0.1/home/maxi/
> databases/test.fdb')
>
> people = db.people.all()
> for p in people:
> print p.name
>
>
> When SqlSoup tries to execute: people = db.people.all() I get the
> next Traceback
That error is issued by Firebird. It seems like /databases/ or test.fdb
doesn't exist, though if that's not the case you'd have to consult their
documentation / mailing list for a full explanation.
>
>
> Traceback (most recent call last):
> File "pru.py", line 24, in <module>
> people = db.people.all()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/ext/sqlsoup.py", line 550, in __getattr__
> return self.entity(attr)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/ext/sqlsoup.py", line 539, in entity
> table = Table(attr, self._metadata, autoload=True,
> autoload_with=self.bind, schema=schema or self.schema)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/schema.py", line 209, in __new__
> table._init(name, metadata, *args, **kw)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/schema.py", line 257, in _init
> include_columns=include_columns)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/engine/base.py", line 1772, in reflecttable
> conn = self.contextual_connect()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/engine/base.py", line 1742, in contextual_connect
> self.pool.connect(),
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 158, in connect
> return _ConnectionFairy(self).checkout()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 329, in __init__
> rec = self._connection_record = pool.get()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 177, in get
> return self.do_get()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 692, in do_get
> con = self.create_connection()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 138, in create_connection
> return _ConnectionRecord(self)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 213, in __init__
> self.connection = self.__connect()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/pool.py", line 279, in __connect
> connection = self.__pool._creator()
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/engine/strategies.py", line 76, in connect
> return dialect.connect(*cargs, **cparams)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> sqlalchemy/engine/default.py", line 238, in connect
> return self.dbapi.connect(*cargs, **cparams)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> kinterbasdb/__init__.py", line 478, in connect
> return Connection(*args, **keywords_args)
> File "/home/maxi/.virtualenvs/miskred/lib/python2.6/site-packages/
> kinterbasdb/__init__.py", line 641, in __init__
> b.dsn, b.dpb, b.dialect, timeout
> sqlalchemy.exc.OperationalError: (OperationalError) (-902,
> 'isc_attach_database: \n I/O error for file "home/maxi/databases/
> test.fdb"\n Error while trying to open file\n No such file or
> directory') None None
>
>
> What is wrong here?
>
> Thanks in advance.
> ----
> Maxi.
>
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> 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 sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
