Eclipse Community Forums: EclipseLink » Alias for identifier have more than 30 char. ora-00972 identifier too long

Help

Home

Home » Eclipse Projects » EclipseLink » Alias for identifier have more than 30 char. ora-00972 identifier too long

Show: Today's Messages :: Show Polls :: Message Navigator

Alias for identifier have more than 30 char. ora-00972 identifier too long [message #468186]

Tue, 04 August 2009 09:13

No real name
Messages: 8
Registered: July 2009

Junior Member

Hi,

I am using EclipseLink 1.0.2 on Oracle platform.

I am using ReadAllQuery & to use pagination, I use
ReadAllQuery.setMaxRows(100)
I have a column name with 30 chars. So query generated by EclipseLink
generates alias which is more than 30 chars. Hence I am getting error:
ora-00972 identifier is too long.

I am aware of bug which is logged
https://bugs.eclipse.org/bugs/show_bug.cgi?id=262923

It mentions workaround as:
oraclePlatform.setShouldUseRownumFiltering(false);
But I want to use RownumFiltering.

Attachment in comment #6 of PR 262923 corectly modifies the problem. New
alias name algorithm truncates the column name appropriately if
resulting string would be too long. It indicates that code in
SQLSelectStatement.java, OraclePlatform.java has been modified.

But Target Milestone is mentioned as 2.0. Can I get the fix in EclipseLink
1.0.2 through some patch or other mechanism.

Thanks for any help.

Regards.

Report message to a moderator

[Message index]

Alias for identifier have more than 30 char. ora-00972 identifier too long

By: No real name on Tue, 04 August 2009 09:13

Previous Topic:	Changes in mutable objects not detected
Next Topic:	EclipseLink Expressions - is there a better way to design the DAO?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 19:04:24 EDT 2013