On Jan 30, 2008, at 2:10 PM, jon wrote:

>
> Thanks for getting back to me and apologies for the stacktrace
> barf ;-)
>
> One thing...I have the following line in my environment.py:
>
> config['pylons.g'].sa_engine = engine_from_config(config,
> 'sqlalchemy.', convert_unicode=True, pool_size=1, max_overflow=3)
>
> I can turn on/off the convert_unicode option and I still get the same
> error. I spoke with one of our DBAs and he said the results of
> roleseq.nextval is a number. SA is looking for a String here or None,
> according to the exception error:
>
> exceptions.TypeError: expecting None or a string
>
> Sooo...is this still an SA thing and if so what do you suggest as a
> workaround?
>

jon -

none of that has anything to do with the error message here.  You need  
to grep thorugh your code for the specific string :   
Sequence(u'roleseq'), or something equivalent.  I know its there  
because the Oracle dialect does not invent or reflect any sequence  
names.  You need to make that sequence name into a regular string  
object; as above you'd take out the "u" inside the parenthesis.

let me know when you find it as I'd like to confirm this is the source  
of the issue....thanks !

- mike


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to