ORA-00972: identifier is too long

Benjamin Eberlei added a comment - 25/Sep/11 5:24 PM This is tricky. No way for you to reduce the column length to < 30 chars? The problem with a fix for this would be that we would need to execute a bunch of functions for every database vendor and every column alias used in every SQL statement: quite some overhead

Matheus Luis Ramos de Souza added a comment - 26/Sep/11 12:19 PM I get it. I don't know the implementation, but is there a possibilty to create a property that disable the "suffix field position" in alias, staying just <column_name>? Tks!

Benjamin Eberlei added a comment - 15/Oct/11 3:05 PM The following workaround will get you around this problem until i find a better solution. 1. Create a MyOraclePlatform extends \Doctrine\DBAL\Platforms\OraclePlatform 2. Override the "getSQLResultCasing($string)" to do: $val = parent::getSQLResultCasing($string); return substr($val, -30); This substrings every result alias to 30 chars.

Matheus Luis Ramos de Souza added a comment - 17/Oct/11 11:29 AM But how does the Doctrine will know about my implementation? I will have to change the Driver too? Thanks!

Benjamin Eberlei added a comment - 17/Oct/11 11:54 AM no, you can pass the "platform" into the DriverManager::create method as "platform" parameter for the $params AFAIK, relevant code is Doctrine\DBAL\Connection::__construct if you want to check it out.

Matheus Luis Ramos de Souza added a comment - 17/Oct/11 4:49 PM In some cases it works, but it doesn't work when the SqlWalker is invoked, I think that the problem is in walkSelectClause($selectClause) method in the else clause for this verification: if ($class->isInheritanceTypeSingleTable() || $class->isInheritanceTypeJoined()) { if ($class->isInheritanceTypeSingleTable() || $class->isInheritanceTypeJoined()) { ... } else { // Add foreign key columns to SQL, if necessary if ($addMetaColumns) { $sqlTableAlias = $ this ->getSqlTableAlias($class->table['name'], $dqlAlias); foreach ($class->associationMappings as $assoc) { if ($assoc['isOwningSide'] && $assoc['type'] & ClassMetadata::TO_ONE) { foreach ($assoc['targetToSourceKeyColumns'] as $srcColumn) { $columnAlias = $ this ->getSqlColumnAlias($srcColumn); $sql .= ', ' . $sqlTableAlias . '.' . $srcColumn . ' AS ' . $columnAlias; $columnAlias = $ this ->_platform->getSQLResultCasing($columnAlias); $ this ->_rsm->addMetaResult($dqlAlias, $ this ->_platform->getSQLResultCasing($columnAlias), $srcColumn); } } } } } } the problem is in the follow lines, because the getSQLResultCasing has no effect in $sql variable that is returned: $columnAlias = $ this ->getSqlColumnAlias($srcColumn); $sql .= ', ' . $sqlTableAlias . '.' . $srcColumn . ' AS ' . $columnAlias; $columnAlias = $ this ->_platform->getSQLResultCasing($columnAlias); The correct would be this way, wouldn't be? $columnAlias = $ this ->getSqlColumnAlias($srcColumn); $columnAlias = $ this ->_platform->getSQLResultCasing($columnAlias); $sql .= ', ' . $sqlTableAlias . '.' . $srcColumn . ' AS ' . $columnAlias; In the version of Doctrine that I'm using, there is no DriverManager::create method, I'm using DriverManager::getConnection(array $params,Configuration $config = null,EventManager $eventManager = null) instead. Tks!!

Benjamin Eberlei added a comment - 17/Oct/11 8:38 PM we found a simple way to fix this, expect a patch for this soon!

Alexander added a comment - 26/Oct/11 1:49 PM The issue should be fixed with the code over here: https://github.com/doctrine/doctrine2/pull/167 I haven't been able to test it on a real Oracle DB yet. Maybe you guys can give it a go?

Benjamin Eberlei added a comment - 30/Oct/11 3:48 PM Fixed, however will not be merged into 2.1.x because the patch is really large