Hi,
I've done some exploring and found that if I connect to the database
as the schema owner the error goes away. I had been connecting through
a proxy account and this was working fine in 4.3. You can see where
this is tripping up 4.6 from the sql log just after staring the app:
With 4.6:
C:\Documents and Settings\daystev\Desktop\asrt_trunk\srt-project>start-
srt.py dev.cfg
SELECT USER FROM DUAL
{}
select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION,
DATA_SCALE, NULLABLE
, DATA_DEFAULT from ALL_TAB_COLUMNS where TABLE_NAME = :table_name and
OWNER = : owner
{'owner': 'ASRT_PROXY', 'table_name': 'ACC_PROTOCOL'}
Traceback (most recent call last):
File "C:\Documents and Settings\daystev\Desktop\asrt_trunk\srt-
project\start-srt.py", line 24, in <module>
...
With 4.3:
C:\Documents and Settings\daystev\Desktop\asrt_trunk\srt-project>start-
srt.py dev.cfg
SELECT USER FROM DUAL
{}
select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION,
DATA_SCALE, NULLABLE
, DATA_DEFAULT from ALL_TAB_COLUMNS where TABLE_NAME = :table_name and
OWNER = : owner
{'owner': 'ASRT_PROXY', 'table_name': 'ACC_PROTOCOL'}
Traceback (most recent call last):
File "C:\Documents and Settings\daystev\Desktop\asrt_trunk\srt-
project\start-srt.py", line 24, in <module>
...
Note that 4.6 is using ASRT_PROXY as the owner while 4.3 uses ASRT
(the actual owner).
To fix the problem (and continue using the proxy account) I added
"schema=ASRT" to all my table definitions. Now everything works fine.
Thanks for all your work. Congrats on the book(s)!
Steve
On Jul 18, 1:45 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> On Jul 18, 2008, at 1:32 PM, shday wrote:
>
>
>
> > I upgraded from 0.4.3 to 0.4.6 and now I get the error below when
> > starting my TurboGears app. I'm using reflection and that fails on the
> > first table. I had a look at the changelog and tried adding
> > "oracle_resolve_synonyms=True" to that table's definition but I got
> > another error (not shown here).
>
> > Any help would be appreciated.
>
> what's the schema look like ? are synonyms in use ? are there cross-
> owner names in use ? what's the error you got with
> oracle_resolve_synonyms ?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
