Re: [Sqlalchemy-users] ORA-00972: identifier is too long

[Michael Bayer]

attached is a patch that creates 30 character max column labels, patched against the latest SVN head. I actually just checked it in so you could just "svn up" to get it, though im not totally confident about it as I would have to add some "long column name" unit tests, but im pretty sure the "tablename_columnname" pattern is entirely encapsulated as a property on ColumnClause and is arbitrary. try out this patch and see how much further you can get.

col.patch
Description: Binary data

On Mar 6, 2006, at 4:46 PM, Boersma, Matt wrote:

I'm trying to use sqlalchemy 0.1.3 with Oracle 9i and cx_Oracle, but can't get far.

FROM shampoo_class

Which leads to this Oracle error:





telephone (877-633-2436, ext. 0), and then delete it from your system.



-------------------------------------------------------

http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

I wrote Table and Mapper objects for an existing schema, It has fairly verbose table and column identifiers, like SHAMPOO_CLASS.SHAMPOO_OR_CONDITIONER_TYPE let's say. Running a simple select() on the ShampooClassMapper generates this SQL: SELECT shampoo_class.shampoo_or_conditioner_type AS shampoo_class_shampoo_or_conditioner_type sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-00972: identifier is too long (The identifier after an AS keyword is limited to 30 characters on Oracle.) This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory!