Okay, I changed the NLS_LANG setting on the oracle client to match that of the server, and now it works. I found out about it here:
http://www.theserverside.com/discussions/thread.tss?thread_id=14634 On Mar 27, 1:27 pm, "shday" <[EMAIL PROTECTED]> wrote: > Hi, > > The table is reflected, with one column overridden, here: > > model_table = Table('model',metadata, > > Column('model_id',Numeric(precision=6,length=0),Sequence('model_seq'), > primary_key=True, nullable=False), > autoload=True) > > Here is what the resulting Table object looks like: > > Table('model',DynamicMetaData(), > Column('investigator_isid',OracleString(length=8),nullable=False), > Column('active',OracleNumeric(precision=1,length=0),nullable=False,default=PassiveDefault(<sqlalchemy.sql._TextClause > object at 0x0193E850>)), > Column('model_id',Numeric(precision=6,length=0),primary_key=True,nullable=False, > default=Sequence('model_seq',start=None,increment=None,optional=False)), > Column('model_acronym',OracleString(length=32),nullable=False), > Column('model_name',OracleString(length=256),nullable=False), > Column('therapeutic_area',OracleString(length=32)), > schema=None) > > On Mar 27, 12:12 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > > > this is most likely a typing error and id need to see the types of > > columns being used. in particular if you have any "String" columns > > without a size, they are now interpreted as CLOBs which might be > > where its tripping up. > > > On Mar 27, 2007, at 10:35 AM, shday wrote: > > > > Here is the surrounding code: > > > > def model_list(therapeutic_area='All'): > > > if therapeutic_area == 'All': > > > s = model_table.select(order_by=[model_table.c.model_acronym]) > > > elif therapeutic_area == 'Other': > > > s = > > > model_table.select(~(model_table.c.therapeutic_area.in_ > > > ('Respiratory','Diabetes', > > > > 'Inflammation','CVD')), > > > order_by=[model_table.c.model_acronym]) > > > else: > > > s = > > > model_table.select > > > (model_table.c.therapeutic_area==therapeutic_area,order_by= > > > [model_table.c.model_acronym]) > > > rs = s.execute() > > > return [(str(row['model_id']),(row['model_acronym'] +" - > > > "+row['model_name'])[:80]) for row in rs.fetchall()] > > > > On Mar 27, 10:29 am, "shday" <[EMAIL PROTECTED]> wrote: > > >> I upgraded to 0.3.6 from 0.3.5 and one of my querys stopped working: > > > >> s = > > >> model_table.select(~(model_table.c.therapeutic_area.in_ > > >> ('Respiratory','Diab etes', > > > >> 'Inflammation','CVD')), > > >> order_by= > > >> [model_table.c.model_acronym]) > > > >> All my other query still work fine. Although this is the only one > > >> using in_() and "~". > > > >> The funny thing is that the created sql appears to be exactly the > > >> same > > >> as before. Here is the error: > > > >> 2007-03-26 15:11:20,851 INFO sqlalchemy.engine.base.Engine.0x..d0 > > >> SELECT model.i > > >> nvestigator_isid, model.active, model.model_id, model.model_acronym, > > >> model.model > > >> _name, model.therapeutic_area > > >> FROM model > > >> WHERE model.therapeutic_area NOT IN > > >> (:model_therapeutic_area, :model_therapeutic > > >> _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY > > >> model.model_ac > > >> ronym > > >> 2007-03-26 15:11:20,851 sqlalchemy.engine.base.Engine.0x..d0 INFO > > >> SELECT model.i > > >> nvestigator_isid, model.active, model.model_id, model.model_acronym, > > >> model.model > > >> _name, model.therapeutic_area > > >> FROM model > > >> WHERE model.therapeutic_area NOT IN > > >> (:model_therapeutic_area, :model_therapeutic > > >> _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY > > >> model.model_ac > > >> ronym > > >> 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 > > >> {'model_therap > > >> eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > > >> 'model_therapeutic_ > > >> ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} > > >> 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO > > >> {'model_therap > > >> eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > > >> 'model_therapeutic_ > > >> ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} > > >> 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 > > >> ROLLBACK > > >> 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO > > >> ROLLBACK > > >> Traceback (most recent call last): > > >> File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt- > > >> project > > >> \start-sr > > >> t.py", line 23, in ? > > >> from srt.controllers import Root > > >> File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt- > > >> project > > >> \srt\cont > > >> rollers.py", line 9, in ? > > >> model_list = [('Respiratory',[('','Please select a model')] > > >> +dbmodel.model_li > > >> st('Respiratory')), > > >> File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt- > > >> project > > >> \srt\mode > > >> l.py", line 158, in model_list > > >> rs = s.execute() > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\sql. > > >> py", line 776, in execute > > >> return self.compile(engine=self.engine, > > >> parameters=compile_params).execute(* > > >> multiparams, **params) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\sql. > > >> py", line 669, in execute > > >> return e.execute_compiled(self, *multiparams, **params) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\engi > > >> ne\base.py", line 726, in execute_compiled > > >> return connection.execute_compiled(compiled, *multiparams, > > >> **params) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\engi > > >> ne\base.py", line 503, in execute_compiled > > >> proxy(str(compiled), parameters) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\engi > > >> ne\base.py", line 499, in proxy > > >> self._execute_raw(statement, parameters, cursor=cursor, > > >> context=context) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\engi > > >> ne\base.py", line 547, in _execute_raw > > >> self._execute(cursor, statement, parameters, context=context) > > >> File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > > >> \sqlalchemy\engi > > >> ne\base.py", line 566, in _execute > > >> raise exceptions.SQLError(statement, parameters, e) > > >> sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-01460: > > >> unimplemented or unre > > >> asonable conversion requested > > >> 'SELECT model.investigator_isid, model.active, model.model_id, > > >> model.model_acro > > >> nym, model.model_name, model.therapeutic_area \nFROM model \nWHERE > > >> model.therape > > >> utic_area NOT IN > > >> (:model_therapeutic_area, :model_therapeutic_ar_1, :model_thera > > >> peutic_ar_2, :model_therapeutic_ar_3) ORDER BY > > >> model.model_acronym' {'model_ther > > >> apeutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > > >> 'model_therapeuti > > >> c_ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'}- Hide > > >> quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
