Hello, Sorry for the late response.
Issue got solved, it is not problem with SA. mx.ODBC,unixODBC driver has limitation over column names length to support ANSI standards (i.e 38-1). I renamed my table column names and issue got solved. Thanks, On Mon, Jun 13, 2011 at 8:07 PM, Michael Bayer <mike...@zzzcomputing.com>wrote: > > On Jun 13, 2011, at 10:28 AM, pavi ena wrote: > > > Hello, > > > > I am using SQLAlchemy-0.7.1 and i am facing "Deferred loader for > attribute" Error while trying to access the table columns in my code. > > > > I have table with huge number of columns around 200 fields and i have > defined the schema and entity with hybrid declarative_base approach as > below. > > I have some sample testcases to assert newly inserted values in db with > normal python assert statements. When i run my sample test cases i am > getting > > following error: > > > > KeyError: "Deferred loader for attribute 'is_updated' failed to > populate correctly" > > > > Below is my code example due to large number of columns i have not > defined entire db Table definition here. > > > > Please suggest to me fix this error. > > would need a reproducing test case, it suggests something to do with the > mechanics of the table but its not clear nor is it an issue seen before. > > > > > Just a thought is this error is raised for following reasons. > > > > 1. If table column name length is more than 30 chars. > > "is_updated" doesn't appear to be more than 30 characters to me. Did you > create a test that sees if this is the case ? > > > 2. If table has large number of columns defined. > > Did you create a test with a fewer number of columns in a table to see if > this is the case ? > > > -- > 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 > 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 sqlalchemy@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.
