On Sep 17, 2009, at 11:20 AM, tomolds wrote:
>
> Hi,
>
> I have exactly the same schema in Postgresql, MySQL and Oracle.
>
> I am reflecting the tables in my application using: self.meta.reflect
> (bind=self.engine, schema='schem')
>
> This works perfectly for MySQL and Postgresql but for Oracle I get no
> tables reflected and cannot understand why. I can however run this
> kind of query and get results with Oracle:
>
> outp = text('select l_name from schem.person',
> bind=self.engine).execute()
>
> for i in outp:
> print i[0]
>
> Can anyone either suggest what my problem might be or perhaps even
> suggest a further test I can do to determine the problem.
the first step would be to turn on echo='debug' on your create_engine
(). That will illustrate the queries SQLA is doing to locate the
table and the results it's getting back.
I notice you're prefixing the table name with "schem", so you'd have
to specify this as the "schema" argument when constructing the Table
object.
Also for Oracle you should defnitely be on SQLA version 0.5.6 at the
very least. the trunk (which is 0.6) also has full test coverage for
oracle.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
